Does it provide the actual SQL to fix the issues?

Yes, the skill generates specific CREATE INDEX SQL recommendations tailored to the detected architectural gaps.

Why is composite index order important?

Database engines match columns from left to right; this skill ensures your indexes align with your query filters (equality before range) for maximum efficiency.

Does this skill work with any PHP framework?

Yes, it is designed to analyze standard PHP code and is particularly optimized for projects using Doctrine ORM and repositories.

Can it detect indexes that are technically present but not used?

Yes, it identifies 'index-defeating' patterns where functions or wildcards prevent the database engine from utilizing existing indexes.

PHP Database Index Auditor

Name: PHP Database Index Auditor
Author: dykyi-roman

bydykyi-roman

•

Database Management

Identifies missing database indexes and optimizes query performance within PHP and Doctrine-based applications.

This skill performs a deep static analysis of PHP code to uncover database performance bottlenecks caused by suboptimal indexing. It scans repository files and entities to detect unindexed WHERE or JOIN clauses, incorrect composite index ordering, and patterns that defeat index usage like leading wildcards or functions on columns. By auditing foreign key constraints and ORDER BY clauses, it provides actionable SQL recommendations to transform slow full-table scans into high-performance index seeks, ensuring your PHP architecture remains scalable and efficient.

Key Features

01Provides recommended SQL snippets for creating missing indexes

02Identifies index-defeating patterns like functions or leading wildcards

0345 GitHub stars

04Detects unindexed columns in WHERE and JOIN clauses

05Analyzes composite index ordering for optimal query matching

06Audits foreign key indexes specifically for PostgreSQL and MySQL

Use Cases

01Auditing Doctrine ORM entities for missing index annotations

02Performance tuning of legacy PHP applications with slow database queries

03Pre-deployment code reviews to ensure new database schemas are properly indexed

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code check-index-usage

For use in Claude.ai and ChatGPT

Download Skill