laravel-database-optimization
This skill provides 33 optimization rules across 9 categories for Laravel 13 applications, covering eager loading, indexing strategies, Redis caching, pagination, and transaction handling. Use it when writing Eloquent queries, diagnosing N+1 issues, configuring indexes, or debugging slow queries with Laravel Debugbar.
Laravel Database Optimization helps eliminate N+1 queries and boost Eloquent performance through eager loading, indexing, and caching strategies.
AI-generated summary based on this skill's SKILL.md
Install
AsyrafHussin/agent-skills/laravel-database-optimization
git clone https://github.com/AsyrafHussin/agent-skills
cp -r agent-skills/skills/laravel-database-optimization ~/.claude/skills/laravel-database-optimizationnpx skillfed install AsyrafHussin/agent-skills/laravel-database-optimizationFrequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I fix N+1 queries in Laravel?
laravel-database-optimization addresses N+1 query problems through eager loading techniques and relationship optimization. The skill provides rules for using Eloquent's `with()` and `load()` methods to fetch related data in single queries rather than iterating through results. It covers detecting N+1 issues with Laravel Debugbar, understanding lazy loading pitfalls, and implementing eager loading patterns across your application's query structure.
What indexing strategies does laravel-database-optimization recommend?
laravel-database-optimization covers database indexing best practices including single-column indexes, composite indexes for multi-column queries, and full-text search indexes. The skill provides guidance on index selection during migrations, query execution plan analysis, and identifying which columns benefit most from indexing. It addresses zero-downtime migration patterns for adding indexes to large tables without locking production data.
How can I implement Redis caching for Laravel queries?
laravel-database-optimization teaches Redis caching integration for query results, including cache key strategies and invalidation patterns. The skill covers cache-aside patterns, setting appropriate TTLs, and invalidating cached data when records change. It provides rules for deciding which queries benefit from caching and how to avoid stale data issues in your Laravel application.
How should I handle large datasets with pagination?
laravel-database-optimization covers pagination and memory-efficient processing for large datasets, including offset-based and cursor pagination approaches. The skill addresses chunking large tables with `chunk()` for batch processing, using `lazy()` collections, and selecting pagination strategies based on dataset size. It includes rules for preventing memory exhaustion when processing millions of records.
What tools help debug slow queries in Laravel?
laravel-database-optimization provides guidance on using Laravel Debugbar for query analysis, identifying slow queries, and diagnosing database performance issues. The skill covers query profiling, execution plan interpretation, and systematic debugging approaches. It includes techniques for measuring query impact and prioritizing optimization efforts across your Eloquent application.
What are the key optimization categories in this skill?
laravel-database-optimization organizes 33 optimization rules across 9 categories: eager loading, indexing strategies, Redis caching, pagination, transaction handling, query performance tuning, cursor pagination, cache invalidation, and lazy loading prevention. The skill applies to Laravel 13 applications and covers both query-level and database-level optimizations for comprehensive performance improvement.
SKILL.md
rendered from the published skill — quoted content, verbatim
Laravel Database Optimization
Comprehensive database optimization guide for Laravel 13 applications. Contains 33 rules across 9 categories for writing performant database queries, proper indexing, efficient caching, naming conventions, and debugging slow queries in Laravel 13.
Metadata
- Version: 1.1.0
- Framework: Laravel 13.x
- PHP: 8.3+
When to Apply
Reference these guidelines when: - Writing Eloquent queries or using the query builder - Diagnosing and fixing N+1 query problems - Adding database indexes to migrations - Implementing Redis or cache-based optimizations - Paginating or processing large datasets - Wrapping operations in database transactions - Creating or modifying migrations for production databases - Debugging slow queries with EXPLAIN or
(truncated - see the full file via the links below)
Read as markdown · JSON record · Browse the source repository
File tree — 15 files
skills/laravel-database-optimization/AGENTS.md
skills/laravel-database-optimization/README.md
skills/laravel-database-optimization/SKILL.md
skills/laravel-database-optimization/metadata.json
skills/laravel-database-optimization/rules/_sections.md
skills/laravel-database-optimization/rules/_template.md
skills/laravel-database-optimization/rules/cache-invalidation.md
skills/laravel-database-optimization/rules/cache-remember.md
skills/laravel-database-optimization/rules/cache-tags.md
skills/laravel-database-optimization/rules/cache-ttl.md
skills/laravel-database-optimization/rules/data-avoid-unbounded.md
skills/laravel-database-optimization/rules/data-chunk-by-id.md
skills/laravel-database-optimization/rules/data-cursor-iteration.md
skills/laravel-database-optimization/rules/data-cursor-pagination.md
skills/laravel-database-optimization/rules/debug-explain-analyze.md