How does this skill improve PHP application performance?

It identifies patterns where data is loaded unnecessarily or inefficiently, suggesting optimizations like specific field selection, count queries, and proper pagination.

Can it detect N+1 query problems in PHP?

Yes, it analyzes eager and lazy loading configurations to prevent excessive database round-trips caused by accessing relations in loops.

Does it support specific PHP ORMs like Eloquent or Doctrine?

The skill is designed to recognize common patterns found in major PHP ORMs, repository patterns, and Query Builders used in modern frameworks.

Why does it recommend cursor-based pagination?

Cursor-based pagination provides consistent performance as datasets grow, avoiding the significant performance degradation associated with large offsets in SQL.

PHP Lazy Loading Analyzer

Name: PHP Lazy Loading Analyzer
Author: dykyi-roman

bydykyi-roman

•

Database Management

Optimizes PHP performance by identifying inefficient database loading patterns, missing pagination, and memory-intensive queries.

This Claude Code skill provides specialized architectural guidance for PHP developers to optimize database interactions and memory usage. It identifies common performance bottlenecks such as N+1 query problems, missing pagination in API endpoints, and premature entity loading. By analyzing patterns in Doctrine, Eloquent, or standard repository implementations, it helps developers implement efficient cursor-based pagination, DTO patterns for serialization, and optimized existence checks, ensuring high-performance applications that scale gracefully under heavy data loads.

Key Features

01Identifies premature entity loading that leads to unnecessary memory consumption.

02Recommends cursor-based or keyset pagination for high-performance infinite scrolling.

03Prevents accidental lazy loading of object graphs during JSON serialization.

04Detects missing pagination in list-style API endpoints and repository methods.

05Flags inefficient count operations and suggests optimized SQL count queries.

0645 GitHub stars

Use Cases

01Refactoring legacy PHP applications to improve database response times and reduce server memory load.

02Automating architectural code reviews for performance-critical backend services and APIs.

03Optimizing data-heavy dashboards and mobile backends to handle large-scale datasets efficiently.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code check-lazy-loading

For use in Claude.ai and ChatGPT

Download Skill