Can this skill detect issues in ORM code?

Yes, it specifically analyzes Doctrine repository patterns, QueryBuilder calls, and raw SQL strings within PHP files.

Can it help with slow pagination in PHP?

Absolutely. It identifies large OFFSET usage which causes database scanning and suggests more efficient keyset pagination strategies.

How does it find performance issues in large codebases?

It uses specialized grep patterns to scan for known anti-patterns such as leading wildcards in LIKE statements, functions in WHERE clauses, and large OFFSET values.

Does it provide the SQL to fix index issues?

Yes, the skill generates specific 'CREATE INDEX' recommendations based on the columns found in your WHERE and ORDER BY clauses.

PHP Query Efficiency Analyzer

Name: PHP Query Efficiency Analyzer
Author: dykyi-roman

bydykyi-roman

•

Database Management

Analyzes PHP code and SQL queries to identify performance bottlenecks, missing indexes, and inefficient data retrieval patterns.

This skill empowers Claude to perform deep static analysis of PHP applications to detect common database performance anti-patterns. It scans for issues like 'SELECT *' usage, full table scans, missing composite indexes, and suboptimal pagination techniques. By identifying these bottlenecks early in the development lifecycle, developers can optimize their SQL queries and ORM calls—such as those in Doctrine or Eloquent—to ensure high-performance applications, reduced server load, and faster response times.

Key Features

01Evaluates join complexity to minimize unnecessary data processing and redundant table links.

02Analyzes pagination logic to replace slow OFFSET queries with high-performance keyset pagination.

0345 GitHub stars

04Identifies missing index opportunities and provides ready-to-use SQL index recommendations.

05Flags full table scans caused by suboptimal WHERE clauses or functions on indexed columns.

06Detects inefficient 'SELECT *' usage and suggests column-specific fetching.

Use Cases

01Automating database performance audits during the code review process.

02Optimizing legacy PHP applications with slow-running database interactions.

03Refactoring ORM queries to improve application scalability and reduce database CPU usage.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code check-query-efficiency

For use in Claude.ai and ChatGPT

Download Skill