Steampipe
Bevraag E-mailgegevens met SQL
Steampipe is een open-source tool waarmee u cloud-API's kunt bevragen met SQL. De Tomba-plugin stelt u in staat om e-mailgegevens te zoeken, verifiëren en analyseren met standaard SQL-query's.
Wat is Steampipe?
Steampipe verandert API's in SQL-tabellen, waarmee u kunt:
- Meerdere gegevensbronnen bevragen met SQL
- Gegevens van verschillende API's joinen
- Dashboards en rapporten bouwen
- Data-analyse workflows automatiseren
Tomba Plugin-tabellen
De Tomba Steampipe-plugin biedt deze tabellen:
tomba_email_finder
Vind e-mailadressen op naam en domein:
SELECT * FROM tomba_email_finder
WHERE first_name = 'John'
AND domain = 'example.com';
tomba_email_verifier
Verifieer e-mailbezorgbaarheid:
SELECT email, status, score
FROM tomba_email_verifier
WHERE email = 'john@example.com';
tomba_domain_search
Zoek alle e-mails bij een domein:
SELECT * FROM tomba_domain_search
WHERE domain = 'company.com';
tomba_enrichment
Verkrijg gedetailleerde e-mailinformatie:
SELECT * FROM tomba_enrichment
WHERE email = 'contact@company.com';
Gebruiksscenario's
- Data-analyse: Analyseer e-mailpatronen bij bedrijven
- Bulkbewerkingen: Verwerk grote e-maillijsten met SQL
- Rapportage: Bouw e-mailintelligentie-dashboards
- Data-integratie: Join e-mailgegevens met CRM-gegevens
- Compliance: Auditeer e-mailontdekking en -gebruik
Voorbeeldquery's
Vind en verifieer e-mails voor een lijst prospects:
SELECT
f.first_name,
f.last_name,
f.email,
v.status,
v.score
FROM tomba_email_finder f
LEFT JOIN tomba_email_verifier v ON f.email = v.email
WHERE f.domain = 'techcorp.com';
Tel e-mails per afdeling:
SELECT
department,
COUNT(*) as email_count
FROM tomba_domain_search
WHERE domain = 'company.com'
GROUP BY department;
Vind alle geldige e-mails bij meerdere bedrijven:
SELECT * FROM tomba_domain_search
WHERE domain IN ('company1.com', 'company2.com', 'company3.com')
AND status = 'valid';
Installatie
- Installeer Steampipe:
brew install steampipe - Installeer Tomba-plugin:
steampipe plugin install tomba - Configureer referenties in
~/.steampipe/config/tomba.spc:
connection "tomba" {
plugin = "tomba"
api_key = "your_api_key"
api_secret = "your_api_secret"
}
- Begin met bevragen:
steampipe query
Documentatie
Volledige tabelschema's en queryvoorbeelden zijn beschikbaar op de Steampipe Hub.
Integratietips
- Dashboards: Gebruik met Steampipe Dashboard voor visualisatie
- Exports: Exporteer resultaten naar CSV, JSON of databases
- Automatisering: Plan query's met cron jobs
- CI/CD: Integreer in datapipelines
Open Source
De Tomba Steampipe-plugin is open source. Bijdragen zijn welkom op GitHub!
Snelkoppelingen
Informatie
Juridisch
Klaar om te beginnen?
Meld u gratis aan en begin Tomba te integreren met Steampipe.
Geen creditcard vereist • 75 gratis credits
Meer ontdekken
Meer integraties verkennen
Ontdek andere krachtige integraties om uw workflow uit te breiden
Airtable
OfficieelSynchroniseer moeiteloos leads opgeslagen met Tomba rechtstreeks naar uw Airtable-account, stroomlijn uw gegevensbeheer en verbeter de organisatie van leads
Albato
Verhoog uw productiviteit door Tomba te verbinden met meer dan 800 applicaties via Albato. Stroomlijn uw workflow, automatiseer processen
Apify
OfficieelAutomatiseer uw workflows door Tomba te verbinden met duizenden apps via Apify. Vereenvoudig uw processen en verhoog de efficiëntie.
Claude
OfficieelIntegreer Claude met Tomba
Flowmattic
Verhoog uw productiviteit door Tomba te verbinden met meer dan 88 applicaties via Flowmattic. Stroomlijn uw workflow, automatiseer processen
Hubspot
OfficieelSynchroniseer moeiteloos leads opgeslagen met Tomba rechtstreeks naar uw Hubspot-account, stroomlijn uw gegevensbeheer en verbeter de organisatie van leads
Trusted by 150,000+ professionals
"Stellar product and amazing support. I have tested many tools and this one is far superior by far. I highly recommend it."
"I spend 3+ months creating best in class content in the form of data-based research studies. When all is said and done, Tomba is the tool I turn to."
"Tomba.io is very fast and has lots of features to help anyone prospect and find exactly who you need to find. I'm saving at least 5 hours a week!"
"The data is always fresh, and the n8n integration is excellent for my use case. Support is very responsive overall. I'd rate it 9/10."
"Since years, Tomba has provided the most results per search, and still it keeps getting better. I highly recommend Tomba."
"I've tested over a dozen email finder tools, and Tomba.io stands out as the best. It consistently delivers accurate results and is incredibly easy to set up."
"As a Founder, as well as a sales leader, there are three things that are important to me: cost effective, easy to use, and accurate data. I actively recommend it."
"It's a great product. I have tried a lot of products in the past, but this is the best one I have ever found."
"Stellar product and amazing support. I have tested many tools and this one is far superior by far. I highly recommend it."
"I spend 3+ months creating best in class content in the form of data-based research studies. When all is said and done, Tomba is the tool I turn to."
"Tomba.io is very fast and has lots of features to help anyone prospect and find exactly who you need to find. I'm saving at least 5 hours a week!"
"The data is always fresh, and the n8n integration is excellent for my use case. Support is very responsive overall. I'd rate it 9/10."
"Since years, Tomba has provided the most results per search, and still it keeps getting better. I highly recommend Tomba."
"I've tested over a dozen email finder tools, and Tomba.io stands out as the best. It consistently delivers accurate results and is incredibly easy to set up."
"As a Founder, as well as a sales leader, there are three things that are important to me: cost effective, easy to use, and accurate data. I actively recommend it."
"It's a great product. I have tried a lot of products in the past, but this is the best one I have ever found."
