db-optimizer
CommunityOptimize database schemas and queries.
Authorelihuvillaraus
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses database performance bottlenecks by optimizing schema design, query execution, and indexing strategies, ensuring applications run efficiently and scale gracefully.
Core Features & Use Cases
- Schema Design: Creates scalable and maintainable database schemas.
- Query Optimization: Analyzes and rewrites slow queries using
EXPLAIN ANALYZE. - Indexing Strategies: Implements effective indexing for improved read performance.
- N+1 Problem Resolution: Identifies and fixes inefficient data fetching patterns.
- Safe Migrations: Guides users through creating reversible and non-locking database migrations.
- Connection Pooling: Advises on efficient connection management.
Quick Start
Use the db-optimizer skill to analyze and optimize the provided SQL query for performance.
Dependency Matrix
Required Modules
None requiredComponents
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-optimizer Download link: https://github.com/elihuvillaraus/skills/archive/main.zip#db-optimizer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.