Steampipe
Query Email Data with SQL
Steampipe is an open-source tool that lets you query cloud APIs using SQL. The Tomba plugin allows you to search, verify, and analyze email data using standard SQL queries.
What is Steampipe?
Steampipe turns APIs into SQL tables, allowing you to:
- Query multiple data sources with SQL
- Join data from different APIs
- Build dashboards and reports
- Automate data analysis workflows
Tomba Plugin Tables
The Tomba Steampipe plugin provides these tables:
tomba_email_finder
Find email addresses by name and domain:
SELECT * FROM tomba_email_finder
WHERE first_name = 'John'
AND domain = 'example.com';
tomba_email_verifier
Verify email deliverability:
SELECT email, status, score
FROM tomba_email_verifier
WHERE email = 'john@example.com';
tomba_domain_search
Search all emails at a domain:
SELECT * FROM tomba_domain_search
WHERE domain = 'company.com';
tomba_enrichment
Get detailed email information:
SELECT * FROM tomba_enrichment
WHERE email = 'contact@company.com';
Use Cases
- Data Analysis: Analyze email patterns across companies
- Bulk Operations: Process large email lists with SQL
- Reporting: Build email intelligence dashboards
- Data Integration: Join email data with CRM data
- Compliance: Audit email discovery and usage
Example Queries
Find and verify emails for a list of 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';
Count emails by department:
SELECT
department,
COUNT(*) as email_count
FROM tomba_domain_search
WHERE domain = 'company.com'
GROUP BY department;
Find all valid emails at multiple companies:
SELECT * FROM tomba_domain_search
WHERE domain IN ('company1.com', 'company2.com', 'company3.com')
AND status = 'valid';
Installation
- Install Steampipe:
brew install steampipe - Install Tomba plugin:
steampipe plugin install tomba - Configure credentials in
~/.steampipe/config/tomba.spc:
connection "tomba" {
plugin = "tomba"
api_key = "your_api_key"
api_secret = "your_api_secret"
}
- Start querying:
steampipe query
Documentation
Full table schemas and query examples are available at the Steampipe Hub.
Integration Tips
- Dashboards: Use with Steampipe Dashboard for visualization
- Exports: Export results to CSV, JSON, or databases
- Automation: Schedule queries with cron jobs
- CI/CD: Integrate into data pipelines
Open Source
The Tomba Steampipe plugin is open source. Contributions welcome on GitHub!
Quick Links
Information
Ready to get started?
Sign up for free and start integrating Tomba with Steampipe.
No credit card required • 75 free credits
Discover More
Explore More Integrations
Discover other powerful integrations to extend your workflow
Airtable
OfficialEffortlessly sync leads saved with Tomba directly to your Airtable account, streamlining your data management and enhancing lead organization
Albato
Enhance your productivity by connecting Tomba with over 800+ applications using Albato. Streamline your workflow, automate processes
Apify
OfficialAutomate your workflows by connecting Tomba with thousands of apps using Apify. Simplify your processes and boost efficiency.
Claude
OfficialIntegrate Claude with Tomba
Flowmattic
Enhance your productivity by connecting Tomba with over 88 applications using Flowmattic. Streamline your workflow, automate processes
Hubspot
OfficialEffortlessly sync leads saved with Tomba directly to your Hubspot account, streamlining your data management and enhancing lead organization
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."