Menú
PostgreSQL optimization: indexes, types, anti-patterns for this project
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Basado en la clasificación ocupacional SOC
Debug frontend vanilla JS issues - console errors, rendering bugs, SPA navigation, WebSocket
Automates the process of setting up the first admin user or adding new admins via the bootstrap endpoint. Includes a Python script for easy execution.
Push to remote and wait for CI to pass. If CI fails, read logs, fix bugs, and re-push. Repeat until green.
Use when building or debugging LangGraph multi-agent systems - eval-first execution, task decomposition, model routing by complexity, and cost discipline
Use when AI agent modifies API routes or backend logic - catch systematic blind spots where the same model writes and reviews code
Use when making or recording significant architectural decisions - capture context, alternatives, and rationale as structured ADRs
| name | postgres-patterns |
| description | PostgreSQL optimization: indexes, types, anti-patterns for this project |
NUMERIC not REAL (already migrated)TIMESTAMPTZ not TIMESTAMP (already migrated)TEXT for user_id, VARCHAR(255) for emailsBOOLEAN DEFAULT TRUE/FALSEJSONB for flexible metadataCREATE UNIQUE INDEX ... WHERE payment_tx_hash IS NOT NULLCREATE INDEX ON table(created_at DESC)%s placeholders)EXPLAIN ANALYZE for slow queriesLIMIT on all list endpointsFOR UPDATE SKIP LOCKED for queue processingDB_STATEMENT_TIMEOUT (default 30s)-pooler URL suffix