laravel-database-optimization - Laravel Database Optimization Guide
Comprehensive patterns and guidelines for optimizing Laravel database queries, indexing, caching, and performance
Tags
Updated: 2026-03-24Capabilities
Typical Inputs
Typical Outputs
What this skill does
- write Eloquent queries
- create database migrations
- configure Redis caching
- debug slow queries
- optimize database performance
- fix N+1 query problems
- add database indexes
- implement cache strategies
- paginate large datasets
- use database transactions
- write zero-downtime migrations
- analyze query performance
Inputs
- Laravel application
- database connection
- Redis cache server
- migration files
- Eloquent models
- query logs
- database schema
Outputs
- optimized Eloquent queries
- database indexes
- cache configurations
- migration files
- paginated data
- database transactions
- query analysis results
Requirements
- Laravel 13.x
- PHP 8.3+