メニュー
Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion. Use when the database is unresponsive, connections are refused, or queries are stuck waiting.
Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.
| name | database-health |
| description | Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks. |
Run the diagnose_database MCP tool to get a composite health assessment.
Interpret results by status:
If slow queries appear in results, offer to run get_slow_queries for deeper analysis. If connection issues appear, offer to run get_connections for per-connection detail. If pg_stat_statements is not installed, suggest enabling it for slow query visibility.
