Skill Claude CodeCodex
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.
Skill Claude CodeCodex
Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks.
Skill Claude CodeCodex
Analyze and resolve deadlock patterns, lock contention, and transaction management issues. Use when investigating stuck queries, lock timeouts, deadlock errors, or transaction isolation problems.
Skill Claude CodeCodex
Analyze and optimize database indexes including duplicate detection, deduplication, foreign key indexes, JSONB GIN indexes, and ORM query coverage. Use when investigating slow queries, high disk usage from indexes, or missing index warnings.
Skill Claude CodeCodex
Monitor and optimize PostgreSQL maintenance operations including autovacuum tuning, vacuum progress, huge pages, and WAL management. Use when investigating table bloat, vacuum issues, or system resource optimization.
Skill Claude CodeCodex
Optimize JPA/Hibernate/Spring Boot ORM performance including N+1 queries, lazy loading, connection pool tuning, batch operations, and prepared statements. Use when investigating slow Java backend performance, high database load from ORM, or entity mapping issues.
Skill Claude CodeCodex
Manage and optimize PostgreSQL table partitioning including partition pruning, time-series partitioning, and partition maintenance. Use when investigating large table performance, time-series data growth, or partition-related issues.
Skill Claude CodeCodex
Track and validate database schema migrations including Flyway/Liquibase tracking, schema drift detection, generated columns, and extension management. Use when investigating migration failures, schema drift, or version control issues.
Skill Claude CodeCodex
Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.