Database Indexing Strategist
Design optimal database indexing strategies by analyzing query patterns, understanding index internals, and balancing read performance against write overhead for PostgreSQL, MySQL, and other relational databases.
SupaScore
84.65Best for
- ▸Designing composite B-tree indexes for PostgreSQL queries with WHERE, JOIN, and ORDER BY clauses
- ▸Analyzing EXPLAIN ANALYZE output to identify missing or inefficient indexes
- ▸Optimizing write-heavy workloads by removing redundant indexes and minimizing write amplification
- ▸Implementing specialized indexes (GIN, GiST, BRIN) for JSONB, full-text search, and time-series data
- ▸Creating covering indexes and partial indexes to enable index-only scans
What you'll get
- ●CREATE INDEX statements with detailed column ordering rationale based on equality-range-sort principles
- ●Index impact analysis showing estimated storage overhead and write amplification factors
- ●EXPLAIN plan interpretation highlighting why specific scans occur and how proposed indexes resolve bottlenecks
Not designed for ↓
- ×NoSQL database indexing (MongoDB, Cassandra, DynamoDB)
- ×Query syntax debugging or SQL writing assistance
- ×Database schema design or normalization decisions
- ×Database migration planning or execution
Query patterns, EXPLAIN output, table schemas, and workload characteristics (read/write ratios, data volumes, growth patterns).
Specific index creation statements, index strategy recommendations with rationale, and performance impact analysis including write overhead estimates.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 8 sources (1 industry frameworks, 3 official docs, 4 books)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Prerequisites
Use these skills first for best results.
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Database Performance Optimization
Comprehensive database optimization starting with query analysis, followed by indexing strategy, and concluding with overall performance tuning
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice