database-indexing-strategy
CommunityDesign scalable, fast index strategies.
AuthorBFLabsAI
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Slow database queries and unoptimized data access kill performance and elevate maintenance costs; this Skill provides a structured approach to index design, selection, and deployment to accelerate reads and control write impact.
Core Features & Use Cases
- Index design patterns for B-tree, GiST, BRIN, and partial/filtered indexes to match query workloads.
- Scope across PostgreSQL and MySQL with guidance on when to use each index type, composites, and maintenance strategies.
- Use Case: Imagine a high-traffic order table with frequent range queries; this Skill helps design indexes that speed up lookups while minimizing lock contention.
Quick Start
Create and optimize indexes on your PostgreSQL or MySQL databases to improve query performance.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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-strategy Download link: https://github.com/BFLabsAI/algoritmo-milionario/archive/main.zip#database-indexing-strategy 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.