Menú
Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE.
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
Find the commit that introduced a regression automatically with git bisect run.
Configure Jest for a TypeScript project — ts-jest, module mapping, and coverage thresholds.
Test React components with Testing Library — render, query by role, and assert on user-visible behavior.
Fix TypeScript ES module import errors by adding .js extensions to relative imports.
Migrate a Jest test suite to Vitest — config, globals, and mock API differences.
Comprehensive guide for creating high-quality skills for Claude. Use when building a new skill, writing a SKILL.md, designing skill frontmatter, planning skill structure, debugging trigger issues, or reviewing an existing skill for improvements. Covers standalone skills, MCP-enhanced skills, and skill-tree programmatic skills.
| name | postgres-index-tuning |
| description | Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE. |
| version | 1.0.0 |
| tags | ["postgres","database","performance"] |
| status | active |
EXPLAIN (ANALYZE, BUFFERS) on the slow query; look for Seq Scan on large tables.CREATE INDEX CONCURRENTLY in production to avoid locks).EXPLAIN ANALYZE and confirm the planner switched to an Index Scan.pg_stat_user_indexes — they only slow writes.