Analyze executed queries to identify missing database indexes and estimate performance impact.
npx skills add https://github.com/thoreinstein/opencode-config --skill indexes
Please help me install this Agent Skill. Skill: indexes Source: https://github.com/thoreinstein/opencode-config/tree/main/skill/indexes Command: npx skills add https://github.com/thoreinstein/opencode-config --skill indexes
Database query performance is often limited by missing or poorly targeted indexes. This Skill analyzes queries across the codebase and identifies where indexes would improve read performance, providing actionable recommendations.
Run the indexes skill against your target database or codebase to generate an index recommendations report.
High-intent search queries and answers about installing and using this skill.
To find missing database indexes and improve query performance, you analyze executed query workloads and schema metadata to detect suboptimal indexes and generate concrete index recommendations with associated impact metrics.
Yes, you can analyze SQL query performance by running a targeted scan against specific query sets rather than a full-database scan, allowing you to optimize slow reads, multi-table joins, and analytics workloads directly.
Generating SQL index recommendations requires access to query workloads and schema metadata, which the analysis uses to evaluate performance characteristics and propose actionable index definitions.
Yes, index analysis applies to relational databases across both codebases and production environments, detecting missing or suboptimal indexes by evaluating query patterns universally.
The best way to optimize multi-table joins and analytics workloads with slow read performance is to scan query patterns to identify missing indexes and apply the proposed concrete index definitions to accelerate data retrieval.
A limitation of automated index recommendations is that the analysis requires direct access to representative query workloads and schema metadata, meaning incomplete workload data will result in inaccurate or suboptimal index guidance.
DexploarerAnalyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.
XSpoonAiAnalyze SQL/NoSQL queries and generate optimization recommendations with structured JSON output.
cenjieAnalyze EXPLAIN ANALYZE diagnostics and apply indexing to optimize database queries.
patricio0312revDetect and analyze database performance issues by collecting real-time metrics and highlighting slow queries.
