skills.rest
dhruvinrsoni
dhruvinrsoniCOMMUNITY
Explore all skills by this author →
Website𝕏@dhruvinrsoniGitHub

db-tuning

Identify slow queries, analyze execution plans, and recommend index optimizations.

Updated Feb 3, 2026
Search Tags:#indexing#database#connection pooling#performance tuning#query analysis#sql optimization
One-click install
npx skills add https://github.com/dhruvinrsoni/agentskills-garden --skill db-tuning
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-tuning
Source: https://github.com/dhruvinrsoni/agentskills-garden/tree/main/skills/50-performance/db-tuning
Command: npx skills add https://github.com/dhruvinrsoni/agentskills-garden --skill db-tuning

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses slow database queries and inefficient database configurations that lead to poor application performance and increased operational costs.

Core Features & Use Cases

  • Slow Query Identification: Pinpoints the most time-consuming database queries.
  • Query Plan Analysis: Analyzes execution plans to find bottlenecks like missing indexes or inefficient joins.
  • Index Optimization: Recommends and generates SQL for creating, dropping, or modifying indexes.
  • Connection Pooling: Tunes database connection pool settings for optimal resource utilization.
  • Use Case: An e-commerce site experiences slow page load times during peak hours. This Skill can identify the specific database queries causing the slowdown and suggest index additions to speed them up.

Quick Start

Analyze the database performance for the 'users' table and suggest index optimizations.

Frequently Asked Questions about db-tuning

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

FAQPage Schema
How do I identify slow database queries causing poor application performance?▼

Database query analysis identifies slow queries by examining execution plans to find bottlenecks like missing indexes or inefficient joins. This reduces latency and improves throughput in database-intensive applications.

How do I optimize SQL indexes to speed up query execution?▼

SQL index optimization recommends and generates SQL for creating, dropping, or modifying indexes based on execution plan analysis. This addresses bottlenecks in data processing pipelines and reduces page load times during peak traffic hours.

What is the best way to tune database connection pooling for optimal resource utilization?▼

Connection pooling tuning adjusts database connection pool settings to optimize resource utilization and reduce latency. This addresses inefficient database configurations that lead to poor application performance and increased operational costs.

Why does query analysis require examining execution plans for database performance tuning?▼

Query analysis requires examining execution plans because they reveal specific bottlenecks like missing indexes or inefficient joins causing slow database queries. This identifies the root cause of poor performance in database-intensive applications.

Can database performance tuning address bottlenecks in data processing pipelines?▼

Database performance tuning addresses bottlenecks in data processing pipelines by analyzing slow queries, recommending index optimizations, and tuning server configurations. This reduces latency and improves throughput for database-intensive applications.

Related Skills

Explore More Software Engineering Skills→
AratKruglikAratKruglik
150

database-optimizer

Analyze slow SQL queries and execution plans for PostgreSQL and MySQL.

Community
Advanced
kevinnguyen271090kevinnguyen271090
15

databases

Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.

Community
Intermediate
luokai25luokai25

performance-engineer

Identify and resolve performance bottlenecks in applications, databases, and infrastructure systems.

Community
Advanced
francanetefrancanete
1

postgres-query-optimization

Analyzes slow PostgreSQL queries using EXPLAIN ANALYZE to recommend index and query optimizations.

Community
Advanced