Query optimization y data seeding Postgres: EXPLAIN ANALYZE, N+1, cursor pagination, CTEs, factories, fixtures.
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 | Sección |
|---|---|---|
| "query lenta", "EXPLAIN", "N+1", "optimizar SQL", "OFFSET", "índice" | OPTIMIZE | → Sección 1: Query Optimization |
| "seed", "fixtures", "datos demo", "faker", "factory", "test data", "anonimizar" | SEED | → Sección 2: Data Seeding |
Regla: si la intención es ambigua, preguntar antes de ejecutar.
Diagnosticar/optimizar queries lentas, crear seeders dev/test/staging, anonimizar dumps prod.
Siempre: EXPLAIN (ANALYZE, BUFFERS, FORMAT TEXT) <query>;. Visualizar planes complejos: explain.dalibo.com. Top queries: pg_stat_statements ORDER BY total_exec_time DESC LIMIT 20.
→ Read references/query-optimization.md for EXPLAIN signal table, common problems (N+1, SELECT *, OFFSET, etc.), CTEs, LATERAL joins, and materialized views
4 tipos: Reference (all envs), Dev fixtures (local), Test fixtures (CI), Demo (staging). Structure: db/seeds/ with reference/, fixtures/, demo/, anonymize/. Key rules: upserts for idempotency, factory pattern, guardrail anti-prod (APP_ENV != "production").
→ Read references/seeding.md for seeding types, structure, factory patterns, performance tips, and anonymization guide
→ Read references/anti-patterns.md for query (5 items) and seeding (5 items) anti-patterns
/database-setupNo 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.