Laravel Database Optimization Skill for Agents

Where this fits

A developer asks an agent to speed up a sluggish Laravel API endpoint. The agent inspects the Eloquent query, spots an N+1 pattern, and needs to know whether to eager-load, add an index, or cache the result. This skill gives agents the exact Laravel 13 patterns to make those decisions without guessing.

Why agents benefit

• Applies 33 rules across 9 categories directly to Eloquent and query builder code, not generic SQL advice.
• Detects N+1 query patterns and generates eager-loading fixes with with() or load().
• Creates migrations with proper index types and column order for production databases.
• Chooses Redis caching strategies for expensive queries, including cache tags and invalidations.
• Uses EXPLAIN and Laravel's query log to debug slow queries and suggest concrete next steps.

Practical scenarios

Fixing N+1 queries in an API endpoint

An agent reviews a posts endpoint that loads comments and authors for each post. Instead of suggesting a generic fix, the agent applies the skill's naming and batch-loading rules, producing a query with with(['comments.author']) and a note on why the subquery order matters.

Adding indexes during migration design

A developer is creating a migration for a job_applications table with frequent filters on status and created_at. The agent references the skill's indexing rules to add a composite index with the correct column order, avoiding a full table scan in production.

Caching expensive queries with Redis

A dashboard query aggregates daily sales across millions of rows. The agent uses the skill's Redis patterns to cache the result for five minutes with a tags-based invalidation strategy, and adds a fallback for cache misses.

Add it to your agent workflow

Install the skill with:

npx skills add AsyrafHussin/agent-skills --skill laravel-database-optimization

After installation, an agent can be prompted with: "Optimize the query in App\Models\Report::topSpenders using the laravel-database-optimization skill." The agent will then pull the relevant rules from the skill's README, inspect the query, and apply eager loading, indexing, or caching as needed.

Compare before adopting

Before relying on this skill, compare it against the official Laravel documentation and other database optimization guides. Check whether the repository is actively maintained (recent commits, version updates for Laravel 13/PHP 8.3), read the rule list to see if it matches your team's conventions, and confirm the skill fits your workflow — especially if you already use tools like Laravel Debugbar or Horizon. A skill is only useful if it aligns with the way your agent already debugs queries.

Why it is worth tracking

At 72 stars with a 1.1.1 release, this skill shows steady community interest. The maintainer has kept the rule set current with the Laravel 13 framework, which is a good sign for freshness. Track it if you write Laravel code with AI agents, and evaluate it again when a new major version of Laravel lands or if you find yourself repeatedly correcting the agent's database decisions. For a centralized directory of similar skills, check out the entry at https://www.openagentskill.com/skills/asyrafhussin-laravel-database-optimization.