Claude-skill-registry indexes

Analyze database queries and recommend missing indexes with performance impact analysis

install

source · Clone the upstream repo

git clone https://github.com/majiayu000/claude-skill-registry

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/indexes" ~/.claude/skills/majiayu000-claude-skill-registry-indexes && rm -rf "$T"

manifest: skills/data/indexes/SKILL.md

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