job-seeker: Skill for Claude Code

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: