sql-optimization

SQL query optimization uses EXPLAIN plans to diagnose bottlenecks and provide query rewrites, index recommendations, and troubleshooting workflows. Provide your query and schema context to receive structured guidance that reduces latency and resource usage.

Best practices for SQL indexing and schema design include applying normalization, selecting appropriate data types, and adding constraints to improve lookups and data integrity. This guidance applies to PostgreSQL, MySQL, and SQLite for scalable transactional and analytical workloads.

Yes, this SQL optimization guidance supports PostgreSQL, MySQL, and SQLite. It provides indexing, query tuning, and schema design best practices tailored to these specific database platforms for both transactional and analytical workloads.

Normalize your database schema for better performance when optimizing data integrity and maintainability across transactional workloads. This skill provides structured normalization guidance alongside indexing and data type recommendations to reduce query latency.

Rewrite complex SQL query patterns to reduce latency by applying query tuning best practices and analyzing EXPLAIN plans. This skill helps developers troubleshoot inefficient queries and apply index recommendations across PostgreSQL, MySQL, and SQLite environments.