Skip to content

galiprandi/job-seeker / .agents/skills/db

Safe Postgres CLI. Reads DATABASE_URL from .env, runs SQL, prints JSON. Read-only by default.

db — Postgres CLI for agents

scripts/db.js is the single entry point to the database. Use it instead of psql or inline pg scripts.

Why

  • Reads DATABASE_URL from .env automatically. No manual sourcing, no leaked credentials.
  • Read-only by default. Writes require explicit --write. Prevents accidental destructive SQL.
  • JSON output. Easy to parse, token-efficient.
  • Portable. Works on any machine that cloned the repo and ran onboarding (no psql in PATH required).
  • Never prints the connection string. --ping shows masked user@host/db only.

Commands

# Read (default, JSON array out)
node scripts/db.js "SELECT * FROM users WHERE id = <user_id>"
node scripts/db.js "SELECT data->'profile' AS profile FROM users WHERE id = <user_id>"

# Write (requires --write)
node scripts/db.js "INSERT INTO applications (user_id, platform, company, role, url, status, data) VALUES (<user_id>, 'linkedin', 'Acme', 'Eng Manager', 'https://...', 'applied', '{}'::jsonb)" --write
node scripts/db.js "UPDATE users SET data = jsonb_set(data, '{linkedin_profile}', '\"https://...\"') WHERE id = <user_id>" --write

# Introspection
node scripts/db.js --tables
node scripts/db.js --schema applications
node scripts/db.js --ping

Rules

  • Always use this CLI for DB access. Never write inline pg scripts in skills, never call psql directly.
  • Read-only by default. A statement that does not start with SELECT/WITH/SHOW/EXPLAIN/VALUES/DESCRIBE is refused without --write.
  • Output is JSON. SELECTs print [{...}, ...]. Writes print {rowCount, command}.
  • Never echo DATABASE_URL. If you need to confirm connectivity, use --ping (masked).
  • Parametrize when needed by interpolating safely into the SQL string. This CLI has no parameter binding for CLI args; for user-supplied strings, escape single quotes (' -> '').
  • JSONB access: use data->'key' (jsonb) or data->>'key' (text). Use jsonb_set for updates.

Schema reference

Tables live in public. Discover with --tables and --schema <table>. Known tables:

  • users — single row (repo owner). data JSONB holds profile, job_preferences, style_profile, platforms, linkedin_profile.
  • applications — user_id, platform, company, role, url, status, applied_at, data.
  • messages — recruiter / contact messages.

applications table

Columns: id, user_id, platform, company, role, url, status, applied_at, data

Platforms used:

  • linkedin = Easy Apply jobs
  • linkedin_invite = connection requests
  • email = direct emails to recruiters
  • teamtailor = applications via Teamtailor (with LinkedIn auth, email verification, Connect)
  • humand = applications via Humand.co
  • <company>_career_site, etc. = specific career sites

Status values (pipeline stages, canonical):

Active stages (left to right in the kanban):

  • discovered = found but no action taken
  • contacted = invite/email sent, no formal application
  • applied = application submitted
  • in_review = company reviewing, no response
  • screening = screening call scheduled/done
  • interview = technical interview in progress
  • offer = offer received, negotiating
  • hired = accepted, starting

Closed stages (shown with --closed):

  • rejected = company rejected
  • withdrawn = user withdrew
  • skipped = decided not to apply / not a fit

data JSONB: include source, match (high/medium/low), location, tech array, stage_history array (audit trail of status changes), and any relevant metadata.

Helper library

lib/browser-helpers.js provides atomic helpers that prevent session death between browser calls:

const {
  goto, evalJS, evalJSON, clickByText,
  waitFor, waitForSelector, waitForText,
  snapshotReliable, dismissModals,
  dbQuery, dbWrite,
  // Atomic helpers (prevent session death between calls)
  openAndEval, openAndEvalJSON,
  gotoAndEval, gotoAndEvalJSON,
} = require('./lib/browser-helpers');

Atomic helpers chain open/goto + eval in a single shell command to prevent session death between calls:

// Open browser + extract in one call (no session death risk)
const jobs = openAndEvalJSON(
  'https://www.linkedin.com/jobs/search/?keywords=...',
  `(function(){ ... return JSON.stringify(...); })()`,
  { session: 'my-session', headed: true }
);

// Navigate + extract in one call (browser already open)
const emails = gotoAndEvalJSON(
  'https://mail.google.com/mail/u/0/#all',
  `(function(){ ... return JSON.stringify(...); })()`,
  { session: 'my-session' }
);

Dependencies

  • Depends on onboarding (.env + DB must exist).
  • Consumed by every flow that reads or writes DB: profile, apply, news, daily.
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall