Agent-Skills.md

Agent Skills: Database Index Analysis

Analyze database queries and recommend missing indexes with performance impact analysis

UncategorizedID: thoreinstein/opencode-config/indexes

Repository

thoreinstein/opencode-config
thoreinsteinLicense: MIT
2

Install this agent skill to your local

pnpm dlx add-skill https://github.com/thoreinstein/opencode-config/tree/HEAD/skill/indexes

Skill Files

Browse the full folder contents for indexes.

Download Skill

Loading file tree…

skill/indexes/SKILL.md

Skill Metadata

Name
indexes
Description
Analyze database queries and recommend missing indexes with performance impact analysis

Database Index Analysis

Current Time: !date PostgreSQL: !psql --version

Scope: $ARGUMENTS (or entire codebase if not specified)

Scan whole codebase and tell me what indexes are missing.

📚 DOCUMENTATION REQUIREMENTS

Create comprehensive database analysis documentation at:

  • docs/tasks/backend/DD-MM-YYYY/<semantic-db-id>/

Documentation Structure:

  • README.md - Database analysis overview and objectives
  • query-analysis.md - Detailed query performance analysis
  • index-recommendations.md - Missing indexes and impact analysis
  • performance-metrics.md - Before/after performance comparisons
  • implementation-plan.md - Index creation strategy and migration plan
  • monitoring-setup.md - Performance monitoring and alerting

Semantic Database Task ID Examples:

  • user-query-optimization
  • order-performance-indexes
  • search-query-acceleration
  • relationship-index-analysis
  • slow-query-investigation

Please analyze all database queries, identify missing indexes, and document recommendations according to the standards above.

$ARGUMENTS

Database Index Analysis Skill | Agent Skills