database-indexing
CommunitySpeed up queries with smart indexing.
Software Engineering#performance#indexing#database#postgresql#mysql#query-optimization#explain-plans
Author1Mangesh1
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Slow database queries and unoptimized access patterns waste time and resources; this Skill provides indexing strategies and guidance to speed up data retrieval.
Core Features & Use Cases
- Understand index types (B-tree, hash, full-text) and when to use them.
- Design composite and covering indexes for common query patterns.
- Analyze EXPLAIN plans and implement performance-tuning patterns for real-world workloads.
- Real-world scenarios include filtering, joining, and sorting large tables to reduce latency.
Quick Start
Apply the recommended index strategy to a slow query to speed up its execution.
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: database-indexing Download link: https://github.com/1Mangesh1/dev-skills-collection/archive/main.zip#database-indexing 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 223,000+ vetted skills library on demand.