القائمة
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.
