Talktodre-ops

database

Talktodre-ops/claude-skills/database/SKILL.md

Production-grade PostgreSQL for an app backend, distilled from a real multi-tenant SaaS on Neon. Covers connection pooling that does not exhaust the server (pooled endpoint, capped app pools, the pool-times-processes math, PgBouncer transaction-mode rules), indexing the hot paths (foreign keys, composite order, functional and partial indexes, verifying with EXPLAIN, CONCURRENTLY on live tables), Postgres-native search instead of a separate cluster (pg_trgm for fuzzy/substring, native FTS, pg_search/BM25 as the Elasticsearch-in-Postgres option, pgvector for semantic), idempotent and retry-safe writes (unique keys, the claim pattern that eliminates a check-then-act race for exactly-once, dedup, exponential backoff with jitter, append-only ledgers for money), and migration discipline. Load when configuring a DB connection, writing or reviewing queries and migrations, adding search, diagnosing "too many connections" or slow reads, handling a race condition or concurrent writers, or making a write safe to retry.