Can it help me process large datasets without crashing?

Absolutely. It provides specific patterns for memory-efficient processing using chunking and cursors to prevent memory exhaustion.

Which PHP ORMs are supported by this skill?

The skill provides specialized guidance for Laravel's Eloquent and Symfony's Doctrine, as well as native PHP Data Objects (PDO).

Can this skill help with database performance issues?

Yes, it includes advanced modules for query profiling, indexing strategies, and analyzing EXPLAIN plans to eliminate full table scans.

How does this skill handle database security?

It enforces a 100% prepared statement policy to prevent SQL injection and provides secure transaction patterns for ACID compliance.

Does it support databases other than MySQL?

Yes, the skill is designed to work with MySQL, PostgreSQL, and SQLite, including database-specific optimization techniques.

PHP Database Mastery

Name: PHP Database Mastery
Author: pluginagentmarketplace

bypluginagentmarketplace

•

数据库管理

Optimizes PHP database interactions using advanced PDO patterns, ORM implementations, and high-performance query tuning.

关于

This comprehensive skill empowers Claude to act as a senior database architect for PHP environments. It covers everything from low-level PDO prepared statements and transaction retry logic to advanced ORM patterns for Laravel Eloquent and Symfony Doctrine. By focusing on performance and reliability, the skill provides actionable guidance on query indexing, EXPLAIN plan analysis, N+1 query prevention, and memory-efficient data processing using chunking and cursors.

主要功能

Expert implementation of PDO, Eloquent, and Doctrine ORM patterns
Automated N+1 query detection and eager loading strategies
Advanced query optimization using indexing and EXPLAIN analysis
Memory-efficient data processing via chunking and cursor implementations
Robust transaction management with exponential backoff retry logic
2 GitHub stars

使用场景

Troubleshooting and optimizing slow-running SQL queries in production
Refactoring legacy PHP database code to modern, secure PDO standards
Designing scalable database schemas and migration workflows

关于

主要功能

Expert implementation of PDO, Eloquent, and Doctrine ORM patterns
Automated N+1 query detection and eager loading strategies
Advanced query optimization using indexing and EXPLAIN analysis
Memory-efficient data processing via chunking and cursor implementations
Robust transaction management with exponential backoff retry logic
2 GitHub stars

使用场景

Troubleshooting and optimizing slow-running SQL queries in production
Refactoring legacy PHP database code to modern, secure PDO standards
Designing scalable database schemas and migration workflows