How do I install Lead Tracking DB?

Install via the Claude Code Skills Marketplace at leadgenjay.com/skills.

Is Lead Tracking DB free?

Lead Tracking DB is available exclusively to AI Automation Insiders members.

What skills work well with Lead Tracking DB?

Lead Tracking DB works well with: consulti-scrape, email-verification, list-optimize, cold-email-campaign-deploy, inbox-insiders.

What's included in Lead Tracking DB?

Lead Tracking DB includes 10 files: SKILL.md, manifest.yaml, evals/evals.json, scripts/db-setup.sh, scripts/db-query.sh, scripts/import-leads.sh, scripts/email-guesser.sh, scripts/sync-analytics.sh, scripts/lead-report.sh, scripts/schema.sql.

AI System · Cold Email Infrastructure

Lead Tracking DB

One SQLite database runs your entire cold email operation - from scraped lead to closed deal.

See how it works

13-table schemaAudit trail built inFree Turso account

Generated report Synced

Pipeline · Summary

1,847 leads tracked across 6 campaigns

342 verified · 91 replied · 14 interested · 3 bounced

>> Get This System

Synced · 0 unclassified replies · audit trail clean

The problem

Spreadsheet lead tracking is done.

Google Sheets

No deduplication, no audit trail

CRM hodgepodge

Can't query raw send and reply data

Sequencer exports

Siloed CSVs you never actually use

Manual reporting

Copy-pasting numbers wastes your morning

Works with

How it works

Tell Claude what you need from your leads

Claude runs the right script, writes the SQL, and hands you a clean answer - you never touch a terminal if you don't want to.

lead-tracking-db · pipeline report

Connected to Claude

The flow Claude builds

01
Bootstrap DB
db-setup.sh creates your Turso database, applies the 13-table schema, and writes credentials to .env automatically.
02
Import Leads
import-leads.sh pulls Apify JSON into the leads table, deduplicates on email, and logs every record to the audit trail.
03
Guess + Verify Emails
email-guesser.sh patterns emails, hits Reacher and No2Bounce, and writes verified or failed events per lead.
04
Sync Analytics
sync-analytics.sh pulls open, click, reply, and bounce data from your sequencer into campaign_analytics and lead_analytics.
05
Run Reports
lead-report.sh delivers 11 report types - from pipeline summary to per-lead timeline - straight in your terminal.

Claude

Lead Tracking DB assistant

Online

Your DB is live. 1,847 leads imported, 342 verified, 91 have replies waiting to be classified. Want a pipeline summary or should I flag the stale ones first?

Show me any campaigns with bounce rate over 5% and which mailboxes aren't warming yet.

Found 1 campaign - 'Agency Owners Q2' at 6.2% bounce. Two mailboxes on domain2.com have warmup disabled even though status is 'warming'. I'd pause that campaign and fix the warmup before sending another round.

Building pipeline · 5 nodes

Describe your campaign…

Setup

Live in four steps

No paid database. No complex infra. A free Turso account and your existing sequencer credentials are all you need.

Non-technical · point and click

Create your free Turso account

Run the bootstrap

Claude runs db-setup.sh for you - it installs the CLI, authenticates, creates the DB, and writes your .env.

Import your first leads

Point import-leads.sh at any Apify JSON export and your first batch lands in the database, deduplicated and logged.

Ask Claude for reports

Request a pipeline summary, flag stale leads, or find campaigns with high bounce rates - Claude queries and explains the results.

Members only

Get Lead Tracking DB inside AI Automation Insiders

One membership unlocks Lead Tracking DB plus every other AI system Jay ships - including the full cold email stack below.

Join Lead Gen Insiders

Cancel anytime · New system every month