skills.rest
bcastelino
bcastelinoCOMMUNITY
Explore all skills by this author →
Website𝕏@cas7elinoGitHub

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
One-click install
npx skills add https://github.com/bcastelino/agent-skills-kit --skill database-optimizer-bcastelino
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
samChang72samChang72
1

database-specialist

Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.

Community
Intermediate
EstomEstom

sql-pro

Optimize SQL queries and database schemas for PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
cosmixcosmix
53

caching

Implement caching strategies with TTL management and Redis or Memcached.

Community
Advanced
shalevaminshalevamin

database-optimizer

Analyze execution plans and optimize PostgreSQL and MySQL database performance.

Community
Advanced