sql-optimization

Optimizes SQL queries and database performance across PostgreSQL, MySQL, and SQLite.

1|Updated Feb 10, 2026

Search Tags:#performance #indexing #optimization #sql #query-tuning #schema-design

Ready to run

npx skills add https://github.com/IvanWeissVanDerPol/infrastructure-cost-tracker --skill sql-optimization-ivanweissvanderpol

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-optimization
Source: https://github.com/IvanWeissVanDerPol/infrastructure-cost-tracker/tree/main/openclaw-config/skills/sql-optimization
Command: npx skills add https://github.com/IvanWeissVanDerPol/infrastructure-cost-tracker --skill sql-optimization-ivanweissvanderpol

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQL query optimization is a common bottleneck in data-driven applications. This Skill provides best practices for writing efficient queries, designing scalable schemas, and diagnosing performance issues to reduce latency and resource usage.

Core Features & Use Cases

Query optimization guidance for PostgreSQL, MySQL, and SQLite across common patterns.
Indexing and schema design tips to improve lookups, data integrity, and maintainability.
Performance troubleshooting workflows including EXPLAIN plans, query rewrites, and normalization guidance.

Quick Start

Provide a single SQL query and schema context, and ask for an index recommendation and plan outline.

Frequently Asked Questions about sql-optimization

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize slow SQL queries using EXPLAIN plans?▼

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.

What are the best practices for SQL indexing and schema design?▼

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.

Does this SQL optimization guidance support MySQL, PostgreSQL, and SQLite?▼

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.

When should I normalize my database schema for better performance?▼

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.

How do I rewrite complex SQL query patterns to reduce 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.