domains / families / data / phy-db-index-advisor

phy-db-index-advisor

separate

Database index advisor that statically analyzes ORM query patterns to predict missing indexes before they become production bottlenecks. Scans SQLAlchemy, Django ORM, TypeORM, Prisma, GORM, ActiveRecord, and Sequelize code for columns used in WHERE/filter, ORDER BY, and JOIN conditions. Cross-references existing model index definitions and migration files to suppress already-indexed columns. Ranks recommendations by query frequency and outputs ready-to-run CREATE INDEX SQL + per-ORM migration snippets. Zero competitors on ClawHub — not a single db-index-advisor SKILL.md in 13,700+ files.

When to use

• Statically analyze ORM query patterns
• Predict missing database indexes
• Scan SQLAlchemy, Django ORM, TypeORM, Prisma, GORM, ActiveRecord, and Sequelize code
• Identify columns used in WHERE/filter, ORDER BY, and JOIN conditions
• Cross-reference existing model index definitions and migration files
• Rank recommendations by query frequency
• Generate CREATE INDEX SQL
• Generate per-ORM migration snippets

When not to use

• Tasks not explicitly stated in the skill text

Skill page

Source