Agent skill · data analytics · aj-geddes
database-indexing-strategy
Design and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.
Why this skill is useful
Provides specific strategies and SQL commands for optimizing database indexing in PostgreSQL and MySQL that the AI wouldn't reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-03-04. 307 stars on the source repository.
What this skill does
Database Indexing Strategy Table of Contents Overview When to Use Quick Start Reference Guides Best Practices Overview Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures. When to Use Index creation and planning Query performance optimization through indexing Index type selection (B-tree, Hash, GiST, BRIN) Composite and partial index design Index maintenance and monitoring Storage optimization with indexes Full-text search index design Quick Start B-tree Indexes (Default): Reference Guides Detailed implementations in the references/ directory: Guide Contents --- --- PostgreSQL Index Types PostgreSQL Index Types MySQL Index Types MySQL Index Types Single Column Indexes Single Column Indexes, Composite Indexes, Partial/Filtered Indexes, Expression Indexes Best Practices ✅ DO Follow established patterns and conventions Write clean, maintainable code Add appropriate documentation Test thoroughly before deploying ❌ DON'T Skip testing or validation Ignore error handling Hard-code configuration values
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aj-geddes/database-indexing-strategy