Menu
Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle SOC
| 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.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.