Optimize PostgreSQL SQL queries for readability, performance, and maintainability.
npx skills add https://github.com/heyAyushh/stacc --skill db-heyayushh
Please help me install this Agent Skill. Skill: db Source: https://github.com/heyAyushh/stacc/tree/main/configs/stacks/databases Command: npx skills add https://github.com/heyAyushh/stacc --skill db-heyayushh
PostgreSQL query writing and review can drift into hard-to-maintain, slow, and error-prone SQL. This Skill provides guidelines to keep queries readable, efficient, and safe across schemas and changes.
Use the db skill to audit a sample SQL query and rewrite it to use explicit columns, proper joins, and a validated EXPLAIN ANALYZE plan.
High-intent search queries and answers about installing and using this skill.
You optimize PostgreSQL queries by enforcing explicit column lists, using CTEs for complex logic, avoiding NOT IN clauses, and validating execution plans with EXPLAIN ANALYZE to ensure maintainability and speed.
Reviewing SQL queries involves checking for explicit column lists, clear aliases, and beneficial CTE usage, then validating performance with EXPLAIN ANALYZE and indexing considerations to catch slow or error-prone logic.
Use CTEs in PostgreSQL when you need to improve query readability, enable safe composition of complex logic, or reuse intermediate result sets, avoiding nested subqueries that drift into hard-to-maintain SQL.
You avoid NOT IN clauses because they can produce error-prone results with NULL values, making queries hard to maintain; using alternative joins or NOT EXISTS constructs keeps PostgreSQL queries clean and safe.
Yes, you validate schema migrations or refactors by running EXPLAIN ANALYZE on affected PostgreSQL queries to check execution plans, confirm performance tuning, and ensure safe changes across development and production environments.
Writing explicit column lists improves PostgreSQL query maintainability by preventing unexpected schema drift, ensuring clear aliases, and keeping query results predictable across schema migrations and production environments.
1lastphoenixCreate type-safe SQL queries and migrations for PostgreSQL, MySQL, and SQLite.
enigmaicon-engAnalyze EXPLAIN execution plans to identify and validate PostgreSQL and MySQL database bottlenecks.
thehivegroup-aiManage PostgreSQL schema design, migrations, and query optimization with psycopg2.
kevinnguyen271090Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.
