Skills
.Work. You
Rest

db-tuning

Community

Optimize database performance.

Software Engineering#indexing#database#connection pooling#performance tuning#query analysis#sql optimization
Authordhruvinrsoni
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: db-tuning
Download link: https://github.com/dhruvinrsoni/agentskills-garden/archive/main.zip#db-tuning

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.