DB migrations Postgres: DDL/DML, expand-contract zero-downtime, rollbacks, locks, CONCURRENTLY, batching, multi-tenant.
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 | Qué hace |
|---|---|---|
| "nueva migration", "agregar columna", "crear tabla", "rename" | CREATE | Genera archivos .up.sql + .down.sql con naming correcto |
| "correr migrations", "aplicar", "migrate up", "deploy migration" | RUN | Valida staging → ejecuta → confirma estado |
| "revertir", "rollback", "deshacer migration", "migrate down" | ROLLBACK | Verifica .down.sql, evalúa riesgo, ejecuta con backup previo |
| "qué migrations hay", "estado", "pendientes", "aplicadas" | STATUS | migrate version + lista pendientes vs aplicadas |
Regla: si la intención combina CREATE + RUN, hacer en ese orden. Si es ROLLBACK destructivo, pedir confirmación explícita.
Migraciones de DB sin romper producción. Stack: Postgres con golang-migrate (Go) o Prisma Migrate (TS).
| Usar | NO usar |
|---|---|
| Schema: CREATE/ALTER TABLE, ADD COLUMN, índices | Seeds de datos de prueba (usar fixtures) |
| Data: backfills, transformaciones, normalizaciones | Lookup tables triviales de dev local |
| Rename/drop columnas o tablas en prod | Scripts one-shot limpieza manual (usar job) |
| ALTER TYPE, split/merge tablas, multi-tenant | Cambios de config app (env/config) |
| Stack | Tool | Archivos |
|---|---|---|
| Go (default) | golang-migrate/migrate | migrations/NNNNNNNNNNNNNN_nombre.up.sql + .down.sql |
| TS (Prisma) | Prisma Migrate | Si usa Prisma como ORM |
| TS (pg directo) | node-pg-migrate | Si usa pg sin ORM |
| TS (Drizzle) | drizzle-kit | Si stack Drizzle |
Alinear herramienta con ORM elegido. No mezclar dos sistemas en mismo repo.
Formato: YYYYMMDDHHMMSS_description.up.sql + .down.sql. Timestamp UTC (no secuenciales). Description snake_case con verbo (add_, create_, drop_, alter_, backfill_). Una migration = un cambio lógico atómico. Nunca editar migration ya mergeada a main.
Todo breaking change se divide en múltiples releases (expand → backfill → dual-write → migrate reads → contract).
→ Read references/expand-contract.md for fases detalladas y breaking changes multi-step
CREATE INDEX CONCURRENTLY en tablas con datos (no bloquea writes)-- +migrate NoTransaction (golang-migrate) o --create-only + editar SQL (Prisma)ALTER TABLE toma ACCESS EXCLUSIVE LOCK. Patrón seguro: SET lock_timeout = '5s'; SET statement_timeout = '30s'; antes del ALTER. Si no consigue lock → falla rápido → retry con backoff. ADD COLUMN con DEFAULT no-volátil es instantáneo desde PG 11. ADD COLUMN NOT NULL DEFAULT <volátil> reescribe tabla — evitar.
Keyset pagination (id > last_id), batch 10k, checkpoints, idempotente, job separado.
→ Read references/batching.md for reglas completas de batching
.down.sql (aunque sea NO-OP documentado)up desde limpio → down → up otra vez (valida reversibilidad + idempotencia). Lint SQL si configurado.| Patrón | Cómo | Cuándo |
|---|---|---|
| Shared schema (default Educabot) | Una migration global, backfills consideran todos tenant_id | SaaS standard |
| Schema-per-tenant | Runner itera tenants, trackea fallo parcial | Aislamiento medio |
| Database-per-tenant | Máximo aislamiento | Solo enterprise compliance |
→ Read references/anti-patterns.md for lista completa (12 items)
/db-diagram — ER diagram post-migration/deploy-check — checklist deploy con migration/audit-dev — revisión integral migrations acumuladas/scaffold-go — setup golang-migrate en proyecto nuevo→ Read references/checklist.md for checklist completo (12 items)
.up.sql and .down.sql files exist for every migrationlock_timeout and statement_timeout configured before ALTER statements.down.sql then .up.sql againCONCURRENTLY outside transactions on populated tablesNo 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.