FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
Laravel query, index and cache optimization v1.0.0
Use this resource to optimize a Laravel application's Eloquent queries, indexes, cache and pagination
New
- 308 downloads
- 175 likes
- 126 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install laravel-database-query-optimizationWith no option, the skill goes to ~/.agents/skills/; add --agent claude-code (or codex, cursor…) to target an agent.
First time: connect the CLI with
npx --yes palatekit@latest loginThe agent reviews Eloquent queries, migrations and cache configuration against 33 rules in nine categories. It looks for N+1 problems, suggests indexes, cursors for large datasets and suitable cache invalidation. You get faster queries, with EXPLAIN ANALYZE used when it helps diagnose a slow one.
Mostly picked by
Updated November 2, 2026
Previews
Details
- Install guides
- Generates with
- Your agent's model
- Licence
- MIT
Similar resources
View all- Free
FreeSkills
Sentry CLI guide
- 525525 downloads
- 117117 likes
- 128128 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Drizzle ORM best practices with PostgreSQL
- 407407 downloads
- 194194 likes
- 151151 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
SLO design wizard
- 537537 downloads
- 105105 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
User stories and sprint fit
- 451451 downloads
- 150150 likes
- 132132 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Capacity-based sprint plan
- 423423 downloads
- 192192 likes
- 102102 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Startup CTO advisor
- 580580 downloads
- 201201 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Creating GitHub pull requests with quality checks
- 427427 downloads
- 230230 likes
- 196196 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
What you get
- AGENTS.md: rule categories by priority and Laravel 13 conventions
- rules/: rules on Redis caching, large datasets, cursors and query debugging
Good fit for
- A Laravel page takes too long to respond
- Your lists trigger N+1 queries
Not for
Tags
- laravel
- eloquent
- indexes
- cache
About
You say
“Find the N+1 queries in the orders list and suggest the right eager loading and indexes.”
Skill published by asyrafhussin under the MIT license, delivered in its original version.
Show moreShow less
How to use it
- Install the skill in your agent's skills folder
- Ask your agent to optimize a Laravel application's Eloquent queries, indexes, cache and pagination
- Review and adjust the result
Content preview
Files
- AGENTS.md96.2 KB
- LICENSE1.1 KB
- metadata.json3.4 KB
- NOTICE-PALATEKIT.md0.5 KB
- README.md2.6 KB
- rules/_sections.md3.2 KB
- rules/_template.md1.8 KB
- rules/cache-invalidation.md3.5 KB
- rules/cache-remember.md2.6 KB
- rules/cache-tags.md3.7 KB
- rules/cache-ttl.md3.6 KB
- rules/data-avoid-unbounded.md2.7 KB
- rules/data-chunk-by-id.md2.8 KB
- rules/data-cursor-iteration.md2.3 KB
- rules/data-cursor-pagination.md2.2 KB
- rules/debug-explain-analyze.md3.3 KB
- rules/debug-laravel-debugbar.md2.8 KB
- rules/debug-slow-query-log.md3.5 KB
- rules/eloquent-query-builder-hot-paths.md2.1 KB
- rules/eloquent-subquery-selects.md2.5 KB
- rules/eloquent-where-has-optimization.md2.7 KB
- rules/eloquent-with-count-aggregates.md2.4 KB
- rules/index-composite-indexes.md3 KB
- rules/index-covering-indexes.md2.6 KB
- rules/index-foreign-keys.md2.7 KB
- rules/index-full-text.md2.8 KB
- rules/lock-deadlock-retry.md2.9 KB
- rules/lock-pessimistic-locking.md3 KB
- rules/lock-short-transactions.md3 KB
- rules/migrate-concurrent-indexes.md3 KB
- rules/migrate-safe-column-additions.md3.2 KB
- rules/migrate-zero-downtime.md3.2 KB
- rules/naming-columns.md4.4 KB
- rules/naming-migrations.md4.2 KB
- rules/naming-relationships.md5 KB
- rules/naming-tables.md3.6 KB
- rules/query-auto-eager-loading.md2.4 KB
- rules/query-eager-loading.md2 KB
- rules/query-prevent-lazy-loading.md2.3 KB
- rules/query-select-columns.md2.4 KB
- SKILL.md7.3 KB
Origin and licence
Listed unmodified
- Author
- asyrafhussin
- Source
- github.com/asyrafhussin/agent-skills/tree/1aa0ff717c10309226c9e678f00873976450fd76/skills/laravel-database-optimization
- Licence
- MIT
Notice
« laravel-database-optimization » (asyrafhussin, MIT) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…