Diagnose and optimize PostgreSQL databases with SQL audit queries and configuration recommendations.
npx skills add https://github.com/cenjie/skills --skill postgres-cenjie
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/cenjie/skills/tree/main/skills/postgres Command: npx skills add https://github.com/cenjie/skills --skill postgres-cenjie
Helps engineers and DBAs diagnose, optimize, and troubleshoot PostgreSQL databases to improve query performance, reduce resource contention, and ensure reliable backups and replication behavior, with PlanetScale-specific guidance when applicable.
Ask the postgres skill to analyze a specific slow SQL query and return index, configuration, and monitoring recommendations for the target database.
High-intent search queries and answers about installing and using this skill.
To optimize slow PostgreSQL queries, this skill provides query rewrite advice, EXPLAIN analysis, and planner tuning recommendations like adjusting random_page_cost and effective_cache_size to reduce latency and IO.
Fix WAL bloat and slow PostgreSQL checkpoints using this skill's procedures for WAL and checkpoint configuration, autovacuum tuning, and actionable rollback plans to manage high-write database operations reliably.
PostgreSQL monitoring queries for autovacuum health and XID wraparound include checking pg_stat views and pg_stat_statements, which this skill provides alongside host metric checks to identify long transactions.
Yes, it provides PlanetScale-specific guidance for connection pooling scenarios, including PgBouncer sizing strategies and PlanetScale CLI insights to ensure PostgreSQL connection stability.
Audit PostgreSQL indexes using this skill's SQL audit queries to identify unused, duplicate, or bloat-prone indexes, and receive recommendations for composite, partial, and primary key index configurations.
PostgreSQL point-in-time recovery and replication slot management procedures are provided by this skill, detailing backup configurations, PITR steps, and replication behavior to ensure database reliability.
GDSDNAnalyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.
xukrutdonutExecute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.
djankiesConfigure Prisma Client connection pools for PostgreSQL deployments.
rnavarychCompare 12 NewSQL and distributed SQL databases for consistency and sharding.
