ops-database-sql

SQL query optimization involves analyzing execution plans with EXPLAIN ANALYZE, identifying bottlenecks, and applying targeted improvements like better indexing, query restructuring, or schema adjustments. This Skill provides AI-assisted analysis of query plans and automated optimization suggestions for PostgreSQL, MySQL, and other platforms to reduce query execution time.

EXPLAIN ANALYZE shows how a database executes a query, including actual row counts, execution time, and resource usage per operation. This Skill interprets these execution plans automatically and recommends specific optimizations like indexing changes or query rewrites to improve performance.

Effective indexing balances query speed gains against write overhead and storage cost by targeting high-selectivity columns and eliminating unused indexes. This Skill helps identify which indexes will deliver measurable performance improvements while avoiding unnecessary index proliferation.

Yes. Beyond query optimization, this Skill covers schema migrations, backup and recovery procedures, high-availability replication setup, and security audits to ensure databases remain reliable, secure, and operationally sound in production environments.

SQL optimization techniques work across relational databases including PostgreSQL, MySQL, and similar platforms. This Skill provides patterns and AI-assisted guidance tailored to these systems' specific execution behaviors and indexing capabilities.