database-optimizer

Analyze SQL query execution plans and design indexing strategies.

2|Updated Feb 6, 2026

Search Tags:#query optimization #indexing #SQL #database #scalability #performance tuning

Ready to run

npx skills add https://github.com/bcastelino/agent-skills-kit --skill database-optimizer-bcastelino

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/bcastelino/agent-skills-kit/tree/main/skills/database-optimizer
Command: npx skills add https://github.com/bcastelino/agent-skills-kit --skill database-optimizer-bcastelino

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses slow database performance, inefficient queries, and scalability challenges by providing expert guidance on optimization techniques across various database platforms.

Core Features & Use Cases

Query Optimization: Analyzes and rewrites slow or complex SQL queries.
Indexing Strategies: Recommends and designs optimal indexing for performance.
Performance Tuning: Adjusts database configurations and parameters.
Use Case: When a web application experiences slow load times due to database bottlenecks, this Skill can identify the problematic queries, suggest appropriate indexes, and tune configurations to improve response times.

Quick Start

Analyze the provided SQL query for performance bottlenecks and suggest optimizations.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema

How do I fix slow SQL query performance and resolve N+1 problems?▼

Optimize slow SQL queries by analyzing execution plans to identify bottlenecks, rewriting inefficient data retrieval logic, and resolving N+1 problems through advanced indexing strategies and configuration tuning.

What is the best way to design indexing strategies for database scalability?▼

Design indexing strategies for database scalability by analyzing query execution plans to recommend optimal indexes, tuning database configurations, and adjusting parameters to support high-volume data retrieval.

Does database performance tuning work across multiple database platforms?▼

Database performance tuning applies across multiple platforms by analyzing SQL execution plans and adjusting configurations universally, requiring deep understanding of database internals and platform-specific monitoring tools.

How to analyze query execution plans to identify web application database bottlenecks?▼

Analyze query execution plans to identify web application database bottlenecks by examining slow query logs, detecting N+1 issues, and evaluating inefficient data retrieval paths to suggest targeted optimizations.

What are the limitations of SQL query optimization for highly complex data retrieval?▼

SQL query optimization for complex data retrieval is limited by underlying database configurations and requires deep understanding of database internals; poorly structured schemas may prevent indexes and rewrites from improving response times.