Schema design, migrations y data operations para Postgres + Prisma/GORM. Setup, indexing, queries, seeds, backups.
The English summary is being prepared. Showing the original description.
Run score Not tested
See how to installReview the instructions the agent will receive before you install.
| Intención del usuario | Modo | Secciones relevantes |
|---|---|---|
| "diseñar schema", "nueva tabla", "relación", "índice" | SCHEMA | → 2. Schema Design, 3. Migrations |
| "query lenta", "EXPLAIN", "N+1", "optimizar" | QUERY | → 5. Query Patterns |
| "migration", "ALTER TABLE", "expand-contract", "rollback" | MIGRATION | → 3. Migrations |
| "sin datos", "seed", "fixtures", "datos demo" | SEED | → 7. Seed Data |
| "conexiones", "pool", "timeout", "PgBouncer" | CONNECTIONS | → 4. Connection Management |
| "backup", "restore", "recovery", "PITR" | OPS | → 8. Backup & Recovery |
Regla: si el argumento es full, ejecutar Checklist completo. Si la intención es ambigua, preguntar.
Stack: Fastify + Prisma + PostgreSQL + Zod + TypeScript
Default Prisma (type-safe, declarative schema, built-in migrations). Consider Drizzle for SQL-like type-safe syntax, node-pg-migrate + pg for raw SQL control, golang-migrate for Go codebases. Never mix migration tools in one repo.
Naming: snake_case tables/columns, PascalCase Prisma models, singular names.
| Criteria | Rule |
|---|---|
| PKs | UUID or CUID; avoid auto-increment if distributed |
| FKs | Always explicit, always indexed on child side |
| Timestamps | created_at + updated_at on every table |
| Soft delete | deleted_at NULL + partial index on non-nulls |
| Enums | Prisma enum for fixed sets; string if values change often |
| Relations | Explicit join tables for M:N; no circular FK deps |
| Composites | Equality first, range second, ORDER BY last |
| Nullability | NOT NULL by default; nullable only for meaningful absence |
Index types: B-tree (95% — equality/range/sort), GIN (arrays/jsonb/tsvector), GiST (geo/ranges), BRIN (huge ordered tables). Use partial indexes to reduce size, covering indexes (INCLUDE) to avoid heap access, expression indexes when WHERE has functions.
Forward-only default. .down.sql for reversible DDL; document one-way explicitly. Name: YYYYMMDDHHMMSS_verb_desc. Never edit merged migrations.
Rules: One change per migration. DDL and data backfills always separate (mixing = long locks). Set lock_timeout + statement_timeout on ALTER TABLE. CREATE INDEX CONCURRENTLY on live tables (outside transaction). ADD COLUMN with non-volatile DEFAULT instant on PG 11+. Adding NOT NULL: CHECK NOT VALID then VALIDATE in separate migration.
Zero-downtime expand-contract: Expand (nullable col/new table/concurrent idx, release N) -> Backfill (async idempotent batched ~10k, N) -> Dual-write (N+1) -> Migrate reads (N+2) -> Contract DROP (N+3, after 1+ stable release). CI: up -> down -> up must pass.
Pool size: max(2, cores*2) per instance, never exceed total max_connections. Connection timeout 5s, statement timeout 30s. Health check via SELECT 1 in health endpoint. PgBouncer transaction-mode for serverless/high-connection loads.
→ Read references/query-patterns.md for: N+1 fixes, pagination, bulk ops, seed strategies, backup/recovery.
→ Read references/anti-patterns.md for the full 16-item checklist.
.env.example with DATABASE_URLlock_timeout + statement_timeout on ALTER; CONCURRENTLY for prod indexesup -> down -> up passesNo reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Plan, design, and implement A/B tests and experiments with statistical rigor. Covers hypothesis frameworks, sample sizing, metrics, and result analysis.
The English summary is being prepared. Showing the original description.
Web/mobile accessibility decision guide: WCAG 2.2 AA, ARIA, keyboard nav, focus management, contrast, testing. Use for: a11y, accessibility, wcag, aria, screen reader, keyboard, contrast.
The English summary is being prepared. Showing the original description.
Generate, iterate, and scale ad creative for paid advertising across Google, Meta, LinkedIn, and X. Covers platform specs, creative frameworks, and quality validation.
The English summary is being prepared. Showing the original description.
Musica interactiva para juegos: layering vertical, re-secuenciacion horizontal, stingers, reglas de transicion con sync points, y mapeo de estados de gameplay a musica. Usar para: musica adaptativa, sistema de musica dinamica, transiciones musicales, combat music.
The English summary is being prepared. Showing the original description.
Design multi-agent systems, create agent architectures, define communication patterns, and build autonomous agent workflows with structured evaluation frameworks.
The English summary is being prepared. Showing the original description.
Inter-agent communication protocol for C-suite agent teams. Defines invocation syntax, loop prevention, isolation rules, response formats, and quality loops.
The English summary is being prepared. Showing the original description.