Menu
Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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.