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

1. Data Analysis: Analyze email patterns across companies
2. Bulk Operations: Process large email lists with SQL
3. Reporting: Build email intelligence dashboards
4. Data Integration: Join email data with CRM data
5. 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

1. Install Steampipe: brew install steampipe
2. Install Tomba plugin: steampipe plugin install tomba
3. Configure credentials in ~/.steampipe/config/tomba.spc:

connection "tomba" {
  plugin  = "tomba"
  api_key = "your_api_key"
  api_secret = "your_api_secret"
}

4. 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!