Plan, design, and implement A/B tests and experiments with statistical rigor. Covers hypothesis frameworks, sample sizing, metrics, and result analysis.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane32026年10月27日 更新
免费在 GitHub 公开
data-operations
Query optimization y data seeding Postgres: EXPLAIN ANALYZE, N+1, cursor pagination, CTEs, factories, fixtures.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane星标 3(GitHub 3 + cccskills 0)
集成工具PostgreSQL
实测评分 未实测
查看安装方法包含的文件（4）
- SKILL.md2.2 KB
- references/anti-patterns.md307 B
- references/query-optimization.md1.9 KB
- references/seeding.md1.2 KB
SKILL.md（原文）
安装前可以查看交给 AI 代理的指令内容。
data-operations — Query Optimization & Seeding
Route
| 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.
Cuándo usar
Diagnosticar/optimizar queries lentas, crear seeders dev/test/staging, anonimizar dumps prod.
1. Query Optimization
EXPLAIN primero
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
2. Data Seeding
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
Anti-patterns
→ Read references/anti-patterns.md for query (5 items) and seeding (5 items) anti-patterns
Checklist
Query optimization
- EXPLAIN ANALYZE antes y después
- pg_stat_statements top queries revisado
- N+1 eliminados (JOIN/Preload/DataLoader)
- Paginación cursor, no OFFSET
- Índices validados →
/database-setup
Seeding
- Reference data separado de fixtures
- Upserts idempotentes
- Guardrail anti-prod
- Sin PII real en fixtures
- Factory pattern para datos random
- faker.seed() para tests determinísticos
评价
还没有评价。欢迎分享你的使用感受。
评论
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
同一仓库的技能
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.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane32026年10月27日 更新
Generate, iterate, and scale ad creative for paid advertising across Google, Meta, LinkedIn, and X. Covers platform specs, creative frameworks, and quality validation.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane32026年10月27日 更新
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.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane32026年10月27日 更新
Design multi-agent systems, create agent architectures, define communication patterns, and build autonomous agent workflows with structured evaluation frameworks.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane32026年10月27日 更新
Inter-agent communication protocol for C-suite agent teams. Defines invocation syntax, loop prevention, isolation rules, response formats, and quality loops.
中文简介正在准备中。当前显示原文说明。
SebastianLuser/claude-code-arcane32026年10月27日 更新