メニュー
Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
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.