Analyze PostgreSQL query performance and recommend indexing and schema improvements.
npx skills add https://github.com/singh-gur/opencode --skill postgresql-singh-gur
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/singh-gur/opencode/tree/main/skills/postgresql Command: npx skills add https://github.com/singh-gur/opencode --skill postgresql-singh-gur
PostgreSQL performance and design optimization to reduce slow queries, improve data integrity, and streamline migrations.
Run a targeted analysis on your slow query and propose concrete indexing and plan improvements.
High-intent search queries and answers about installing and using this skill.
PostgreSQL query optimization analyzes expensive queries using explain plans to identify bottlenecks and proposes concrete indexing strategies and plan improvements to reduce execution time.
PostgreSQL schema design recommends appropriate data types, constraints, and normalization choices to balance query performance with long-term maintainability and strict data integrity.
PostgreSQL migration patterns provide guidance for zero-downtime migrations, safe column changes, and robust versioning strategies to update production schemas without service disruption.
PostgreSQL performance analysis applies to both production and development workloads, debugging performance issues, and managing migrations safely across different environments.
PostgreSQL performance tuning evaluates expensive queries to determine whether indexing strategies or SQL rewrites are more effective, ensuring recommendations satisfy safe migration patterns and data-type choices.
rabbicseOptimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.
brenordvProvide architectural guidance and performance optimization for PostgreSQL 16+ databases.
ariesanhthuAnalyze EXPLAIN plans and optimize queries for PostgreSQL, MySQL, MongoDB, and SQLite.
brenordvModel NoSQL database systems using query-driven structures and horizontal scalability.
