Lead Gen JaySkillsLead Tracking DB

Lead Tracking DB

LGJ Exclusive Skill v2.0 10 files

Manage a Turso/SQLite lead-tracking database for cold email. Ships db-setup.sh + db-query.sh + 4 wrapper scripts (import-leads, email-guesser, sync-analytics, lead-report) plus the 13-table schema.sql. You provide a free Turso account; the bootstrap creates the DB and writes credentials to .env.

cold-emailtursosqlitedatabaselead-trackinganalyticsschema

Lead Tracking DB is a Claude Code skill. Manage a Turso/SQLite lead-tracking database for cold email. It works well with consulti-scrape, email-verification, list-optimize, cold-email-campaign-deploy, inbox-insiders.

Documentation

--- name: lead-tracking-db description: "Manage a Turso/SQLite lead-tracking database for cold email. Ships db-setup.sh + db-query.sh + 4 wrapper scripts (import-leads, email-guesser, sync-analytics, lead-report) plus the 13-table schema.sql. You provide a free Turso account; the bootstrap creates t
Insiders Only

This skill’s full documentation, trigger phrases, and install command are reserved for AI Automation Insiders members.

JF
Built by Jay Feldman
Founder, Lead Gen Jay · Inc. 5000 · 80K+ YouTube subs

You’re missing the playbook

Insiders unlock full docs for this skill plus every other LGJ-exclusive skill. $1,497 one-time · 14-day refund · cancel anytime.

Join Insiders

Works Well With

Consulti Scrape

Scrape leads from Consulti.ai's three databases (500M+ B2B contacts, Google Maps local businesses, podcast/YouTube creators) via the Consulti REST API. Prompt-only skill — teaches Claude how to call the API inline, build deduplicated audience lists (excludeListId native on B2B, client-side dedup on local + creator), and pipe results into lead-tracking-db's import-leads.sh. You provide CONSULTI_API_KEY; the lead-tracking-db skill must be installed for the ingest pipeline.

Email Verification

Verify emails before adding to cold email campaigns. Two backends: Consulti /verify (default for <500 batches; one key + server-side cache) and Reacher + No2Bounce (>1K batches; 8x faster via proxy + parallel xargs with N2B catch-all recovery). Prompt-only skill — teaches Claude how to call the APIs inline; you provide CONSULTI_API_KEY (or Reacher/N2B envs).

List Optimize

Qualify, normalize, research, and personalize a scraped lead list before campaign launch. Bundles 9 shell scripts (qualify.sh, normalize-company.sh, research.sh, personalize.sh, run-pipeline.sh, validate-campaign-vars.sh, migrate-schema.sh + db-query.sh helper). Interactive phase picker. Validates target Instantly/Email Bison campaign template carries the personalization variable + fallback before any DB writes. Updates Turso leads table with qualification + normalization + personalization fields. Requires the lead-tracking-db skill (provides db-setup.sh + V1 schema).

Cold Email Campaign Deploy

Deploy cold email campaigns to Email Bison or Instantly. Prompt-only skill that teaches Claude how to compile upstream artifacts (strategy.md + copy/sequence.md + ab-testing/variants.md) into a campaign brief, run the 8-gate pre-launch checklist, and create the campaign via REST API in PAUSED state. You provide INSTANTLY_API_KEY or EMAIL_BISON_API_KEY.

LGJ Exclusive Content

Enter your Insiders email to unlock the full documentation and install command.

  • Full documentation
  • One-line install command
  • All future updates
  • Priority support
Files included
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 Automation Insiders · Cohort #14

Unlock all exclusive skills now

Get every Claude Code skill, command, and agent Jay uses to run an Inc. 5000 company — plus live coaching, the private community, and lifetime access.

  • Claude Code Zero to ProFastest way to learn Claude
    $2,997
  • Claude Remote AgentBuild your own 24/7 Bob
    $3,497
  • 100+ Exclusive Skills & AutomationsClaude Code & n8n
    $1,997
  • Unlimited Live CoachingOn-demand + Tuesdays with Jay
    $1,497
  • Top 1% Skool Community3,000+ founders
    $997
Total real-world value$13,479
You pay today$1,497
Encrypted 14-day refund Cancel anytime