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

Insiders Only

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

Sign in to install
JF
Built by Jay Feldman
Founder, Lead Gen Jay · Inc. 5000 · 84K+ 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

Members install this skill from the authenticated portal.

Member sign-in required

Sign in to the member portal to view the full documentation and install this skill.

Sign in to installNot a member? Unlock with AI Automation Insiders
  • Full documentation
  • One-line install command
  • All future updates
  • Priority support
Files included
10 files
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