Diagnose and optimize PostgreSQL schema, queries, indexes, and production operations.
npx skills add https://github.com/kanade0404/dotfiles --skill postgres-kanade0404
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/kanade0404/dotfiles/tree/main/.opencode/skills/postgres Command: npx skills add https://github.com/kanade0404/dotfiles --skill postgres-kanade0404
This Skill helps you diagnose, tune, and operate PostgreSQL systems without guesswork, reducing slow queries, connection issues, bloat, and recovery risk.
Ask me to analyze your PostgreSQL schema, query, or operational issue and I will provide concrete tuning, troubleshooting, and safety recommendations.
High-intent search queries and answers about installing and using this skill.
To optimize slow PostgreSQL queries, you need to analyze your schema to identify missing, duplicate, or unused indexes and rewrite inefficient SQL patterns. This reduces slow query performance and connection issues without guesswork.
Tuning PostgreSQL for production involves applying operational guidance for memory allocation, autovacuum, WAL, and checkpoints. This ensures reliable long-term operation and reduces recovery risk by following best-practice decisions for safe changes.
Troubleshooting PostgreSQL replication and backup recovery failures requires diagnosing operational problems and applying validated workflows for restore. This provides concrete tuning and safety recommendations to reduce recovery risk during failure events.
Yes, you can use it for safe PostgreSQL database design reviews to choose better schemas, keys, and partitioning strategies. This ensures reliable long-term PostgreSQL operation by validating queries and applying best-practice design decisions.
PostgreSQL bloat and connection pooling issues arise from suboptimal autovacuum and memory configurations. You can fix them by applying monitoring practices and operational tuning guidance to diagnose and reduce these specific performance bottlenecks.
You should avoid direct schema modifications or indexing changes on production PostgreSQL without validated queries and safe change procedures. Applying best-practice operational decisions prevents downtime and reduces recovery risk during failure recovery.
nimadorostkarAnalyze execution plans and query logs to resolve database latency and throughput issues.
mtsatryanIdentify deployment requirements and bottlenecks in a PostgreSQL environment.
pohlai88Optimize PostgreSQL performance with indexing, partitioning, and replication strategies.
ovachieverOrchestrate distributed training across clusters with Ray Train and Ray Tune.
