Analyze PostgreSQL queries with EXPLAIN ANALYZE and recommend indexes.
npx skills add https://github.com/tchawla827/GraphForge --skill postgres-pro-tchawla827
Please help me install this Agent Skill. Skill: postgres-pro Source: https://github.com/tchawla827/GraphForge/tree/main/.claude/skills/postgres-pro Command: npx skills add https://github.com/tchawla827/GraphForge --skill postgres-pro-tchawla827
This Skill helps database professionals optimize PostgreSQL performance by analyzing slow queries, designing indexes, tuning maintenance, and configuring replication for reliable and scalable systems.
Provide a slow-running query and I will analyze its plan with EXPLAIN ANALYZE and propose indexing and tuning steps.
High-intent search queries and answers about installing and using this skill.
To optimize slow PostgreSQL queries, use EXPLAIN ANALYZE to identify execution bottlenecks and verify performance improvements. This Skill analyzes the provided query plan and proposes specific indexing and tuning steps to reduce latency.
For JSONB optimization, GIN and GiST indexes are highly effective for common access patterns. This Skill provides index design recommendations, including partial and covering indexes, to keep JSONB query workloads responsive.
Configuring PostgreSQL replication for high availability involves establishing and validating primary/standby configurations. This Skill provides best-practice guidance to support read scaling and ensure reliable database failover across production environments.
B-tree indexes suit standard equality and range queries, while BRIN indexes excel for large, naturally ordered tables. This Skill analyzes your specific access patterns to recommend the correct index design for performance tuning.
PostgreSQL index tuning effectively resolves slow production report generation by applying recommended indexing and query refactoring. This reduces latency and maintains workload reliability from development to production environments.
PostgreSQL maintenance strategies to keep workloads responsive include managing routine maintenance tasks alongside JSONB optimization and replication tuning. This ensures reliable and scalable systems across development and production environments.
rabbicseOptimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.
Marwan78888Diagnose and optimize PostgreSQL query plans, indexes, and replication workflows.
manutejAutomate PostgreSQL administration for customer support platform databases.
vecearAnalyze EXPLAIN plans and rewrite SQL queries for PostgreSQL and MySQL.
