OpenClaw LaunchOpenClaw Launch
📑

Index Advisor

Verified

by Community

Analyzes your queries and table structures to recommend appropriate database indexes. Covers B-tree, hash, GIN, GiST, and partial indexes with guidance on index maintenance overhead and when to avoid over-indexing.

indexesperformancedatabaseoptimizationsql

Index Advisor

Recommend optimal database indexes based on your query patterns and table structures for improved performance.

Usage

Share your common queries and table schemas, and this skill will recommend appropriate indexes.

Examples

  • "What indexes should I add for my user search queries?"
  • "Is a composite index better than separate indexes for this query?"
  • "Should I use a partial index for filtering active records?"

Guidelines

  • Index columns that appear in WHERE, JOIN, and ORDER BY clauses
  • Consider composite indexes for multi-column filter patterns
  • Use partial indexes to reduce index size for filtered queries
  • Monitor index usage and remove unused indexes
  • Balance read performance gains against write overhead

More Database & SQL Skills

🗂️
Database Schema Designer

Design normalized database schemas for applications.

🔀
Migration Script Generator

Generate database migration scripts for schema changes.

🔍
Query Explain Analyzer

Interpret database EXPLAIN output to diagnose performance.

⏰
Database Backup Scheduler

Set up automated database backup schedules and retention.