New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Laravel Database Expert

by HoangNguyen0403 in HoangNguyen0403/agent-skills-standard

Optimize Laravel queries with subqueries, joinSub, Redis cache-aside patterns, and read/write connection splitting.

MITAuto-check passedBackend & APIs

Install Laravel Database Expert

skills CLI
$ npx skills add HoangNguyen0403/agent-skills-standard --skill laravel-database-expert -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install HoangNguyen0403/agent-skills-standard laravel-database-expert --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/HoangNguyen0403/agent-skills-standard.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/laravel/laravel-database-expert .claude/skills/laravel-database-expert && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
laravel-database-expert
GitHub stars
572
Token cost
~802 tokens
SKILL.md length
284 words
Files
3 (incl. references)
Skills in repo
211
Repo updated
First seen
Licence
MIT

At a glance

Optimize Laravel queries with subqueries, joinSub, Redis cache-aside patterns, and read/write connection splitting.

  • Works in 5 steps: Profile query — Use DB::enableQueryLog()… → Add missing indexes — Create migration… → Replace N+1 — Use withCount(),… → …
  • Writing complex joins
  • SKILL.md covers Priority: P1 (HIGH), Workflow: Optimize Slow Query, Cache-Aside with Tags Example and Implementation Guidelines, plus 3 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Laravel Database Expert is an agent skill from HoangNguyen0403/agent-skills-standard. Optimize Laravel queries with subqueries, joinSub, Redis cache-aside patterns, and read/write connection splitting. Use when writing complex joins, implementing Cache::remember with tags, or configuring database read replicas.

Its SKILL.md is about 800 tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including reference files (for example `evals/evals.json` and `references/implementation.md`).

It sits in Backend & APIs, covering Backend development and Caching. It works with Laravel and Redis. The repository describes itself as: A collection of Agent Skills Standard and Best Practice for Programming Languages, Frameworks that help our AI Agent follow best practies on frameworks and programming laguages. The licence is MIT.

When your agent uses it

  • Writing complex joins
  • Implementing Cache::remember with tags
  • Configuring database read replicas

Example prompts

  • “/laravel-database-expert”

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. Profile query — Use DB::enableQueryLog() or Laravel Debugbar.
  2. Add missing indexes — Create migration for join/where columns.
  3. Replace N+1 — Use withCount(), withSum(), or addSelect subqueries.
  4. Cache results — Apply Cache::remember() with tags for frequently accessed data.
  5. Split reads/writes — Configure read/write keys in config/database.php.

What it can do on your machine

Read from SKILL.md and the folder at commit b529c2d. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Laravel Database Expert loads about 802 tokens when it runs, and up to ~1.1k if it reads all its reference files. Until then it costs about 63 tokens; SKILL.md has 284 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~63
When it runs · the whole SKILL.md, loaded when a task matches
~802
With references · SKILL.md plus every file in references/, read only if the agent opens them
~1.1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from HoangNguyen0403/agent-skills-standard at commit b529c2d, republished under its MIT licence (© HoangNguyen0403). 284 words, ~802 tokens.

Download SKILL.mdSave it as .claude/skills/laravel-database-expert/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.
name
laravel-database-expert
description
Optimize Laravel queries with subqueries, joinSub, Redis cache-aside patterns, and read/write connection splitting. Use when writing complex joins, implementing Cache::remember with tags, or configuring database read replicas.

Laravel Database Expert

Priority: P1 (HIGH)

Workflow: Optimize Slow Query

  1. Profile query — Use DB::enableQueryLog() or Laravel Debugbar.
  2. Add missing indexes — Create migration for join/where columns.
  3. Replace N+1 — Use withCount(), withSum(), or addSelect subqueries.
  4. Cache results — Apply Cache::remember() with tags for frequently accessed data.
  5. Split reads/writes — Configure read/write keys in config/database.php.

Cache-Aside with Tags Example

See implementation examples for cache-aside pattern with tag-based invalidation.

Implementation Guidelines

Advanced Query Builder
  • Complex Joins: Prefer joinSub($subquery, 'alias', ...) and whereExists(fn($q) => $q->select(DB::raw(1))...) over raw SQL or whereIn for correlated subqueries.
  • Subqueries: Use addSelect with DB::raw subquery to avoid N+1 issues.
  • Aggregates: Use withCount(), withSum(), and withAvg() directly via Eloquent for optimized column-based aggregation.
  • Raw Expressions: Always use selectRaw or whereRaw with bindings; never use string concatenation in raw queries.
Caching Strategy (Redis/Memcached)
  • Cache-Aside: Utilize Cache::remember('key', $ttl, $closure) for frequently accessed data (e.g., posts.all).
  • Redis Tagging: Group related keys using Cache::tags(['posts', 'user:1']) for grouped invalidation.
  • Invalidation: Call Cache::tags(['posts'])->flush() to clear specific subsets; never use Cache::flush() globally in production.
Scalability & Infrastructure
  • Read/Write Splitting: Configure 'read' and 'write' keys in config/database.php mysql/pgsql connections. Laravel automatically routes SELECT to read and INSERT/UPDATE/DELETE to write; no code changes needed.
  • Indices: Ensure correct database indexes present on all join and aggregate columns.

Anti-Patterns

  • No string SQL concatenation: Use bindings or Query Builder.
  • No queries in loops: Use subqueries, joins, or aggregates.
  • No Cache::flush(): Use tags to target specific cache groups.
  • No direct Redis calls: Use Laravel Cache wrappers consistently.

References

Canonical response anchors

When this skill applies, preserve the following domain terminology or equivalent concrete examples in the answer when relevant:

  • INSERT/UPDATE/DELETE

  • correlated subqueries

  • grouped invalidation

  • no code changes needed

  • posts.all

  • Additional task-grounded exact anchors: Cache::remember; withAvg

© HoangNguyen0403, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 2 other files (references) in skills/laravel/laravel-database-expert of HoangNguyen0403/agent-skills-standard.

  • SKILL.md
  • evals/evals.json
  • references/implementation.md

Open the folder on GitHubat commit b529c2d

Compare with similar skills

Laravel Database Expert next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Laravel Database Expert compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Laravel Database Expert this skillHoangNguyen0403/agent-skills-standard572—~802Automated safety check: PassMIT
Configuring Horizoncoollabsio/coolify63k4 repos~898Automated safety check: PassMIT
FastAPI-Redis SDK Developmentredis/fastapi-redis-sdk405—~2.5kAutomated safety check: NotesMIT
Pulse DevelopmentMineTrax/minetrax1161 repos~1.7kAutomated safety check: PassMIT
Olm ArchitectureOpenLitterMap/openlittermap-web134—~5.2kAutomated safety check: PassGPL-3.0
AsyncTheBeardedBearSAS/claude-craft107—~741Automated safety check: PassMIT

Similar skills

  • Configuring Horizon

    coollabsio/coolify

    A skill your agent uses whenever the user mentions Horizon by name in a Laravel context.

    63k GitHub starsUsed in 4 repos~898 tokens
    Backend & APIsAuto-check passed

  • FastAPI-Redis SDK Development

    redis/fastapi-redis-sdk

    Official

    Guides development on the fastapi-redis-sdk library itself - its connection lifecycle, dependency-injected caching, and async/sync bridging.

    405 GitHub stars~2.5k tokensUpdated 9 days ago
    Backend & APIsAuto-check: notes

  • Pulse Development

    MineTrax/minetrax

    Handles Laravel Pulse setup, configuration, and custom card development.

    116 GitHub starsUsed in 1 repo~1.7k tokens
    Backend & APIsAuto-check passed

  • Olm Architecture

    OpenLitterMap/openlittermap-web

    OpenLitterMap v5 architecture reference. An agent skill from OpenLitterMap/openlittermap-web.

    134 GitHub stars~5.2k tokensUpdated 26 days ago
    Backend & APIsAuto-check passed

  • Async

    TheBeardedBearSAS/claude-craft

    Architecture async-first avec messaging et queues (Symfony Messenger, Laravel Queue, Ecotone).

    107 GitHub stars~741 tokensUpdated 27 days ago
    Backend & APIsAuto-check passed

  • Laravel Cloud Ops

    freekmurze/dotfiles

    Day-to-day Laravel Cloud operations with the cloud CLI and the Cloud REST API, plus the conventions for setting up a new Cloud app.

    1k GitHub stars~3.9k tokensUpdated 3 days ago
    Backend & APIsAuto-check passed

More from HoangNguyen0403/agent-skills-standard

All 211 skills in this repo

  • Subagent-Driven Development

    HoangNguyen0403/agent-skills-standard

    Runs a multi-task implementation plan by sending each task to a fresh implementer subagent, reviewing it independently, then reviewing the whole branch.

    572 GitHub stars~1.3k tokensUpdated yesterday
    Auto-check passed

  • draw.io Architecture Diagramming

    HoangNguyen0403/agent-skills-standard

    Draws architecture diagrams as editable draw.io files from a JSON spec, with a fixed house style, one C4 level per diagram and evidence-tagged shapes.

    572 GitHub stars~1.3k tokensUpdated yesterday
    Auto-check passed

  • Android Navigation 3 Guide

    HoangNguyen0403/agent-skills-standard

    Implements and migrates to Jetpack Navigation 3 in Compose: NavDisplay, typed route objects, a state-list back stack, deep links, multiple back stacks and dialog scenes.

    572 GitHub stars~687 tokensUpdated yesterday
    Auto-check passed

  • Angular HttpClient Standards

    HoangNguyen0403/agent-skills-standard

    Sets rules for Angular HTTP code: functional interceptors, typed requests, services that own every call, and httpResource for reactive data loading in Angular 17+.

    572 GitHub stars~652 tokensUpdated yesterday
    Auto-check passed

  • Angular Tooling

    HoangNguyen0403/agent-skills-standard

    Angular CLI usage, code generation, build configuration, and bundle optimization.

    572 GitHub stars~743 tokensUpdated yesterday
    Auto-check passed

  • Common Code Review

    HoangNguyen0403/agent-skills-standard

    Conduct high-quality, persona-driven code reviews. An agent skill from HoangNguyen0403/agent-skills-standard.

    572 GitHub stars~772 tokensUpdated yesterday
    Auto-check passed

Works with

Categories

Questions about Laravel Database Expert

What does Laravel Database Expert do?

Optimize Laravel queries with subqueries, joinSub, Redis cache-aside patterns, and read/write connection splitting. Laravel Database Expert is an agent skill from HoangNguyen0403/agent-skills-standard. Optimize Laravel queries with subqueries, joinSub, Redis cache-aside patterns, and read/write connection splitting.

When should I use Laravel Database Expert?

Laravel Database Expert fits situations like: writing complex joins; implementing Cache::remember with tags; configuring database read replicas.

How do I install Laravel Database Expert in Claude Code?

Run `npx skills add HoangNguyen0403/agent-skills-standard --skill laravel-database-expert -a claude-code`. Or copy the skill folder (skills/laravel/laravel-database-expert in HoangNguyen0403/agent-skills-standard) into .claude/skills/laravel-database-expert in your project. Claude Code loads it when a task matches its description.

How do I install Laravel Database Expert in Codex?

Run `npx skills add HoangNguyen0403/agent-skills-standard --skill laravel-database-expert -a codex`. Or copy the skill folder (skills/laravel/laravel-database-expert in HoangNguyen0403/agent-skills-standard) into .agents/skills/laravel-database-expert in your project. Codex loads it when a task matches its description.

Can I use Laravel Database Expert in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add HoangNguyen0403/agent-skills-standard --skill laravel-database-expert -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/laravel-database-expert, .gemini/skills/laravel-database-expert, .github/skills/laravel-database-expert and .opencode/skills/laravel-database-expert in your project.

What does Laravel Database Expert need to run?

SKILL.md names no scripts, command-line tools or credentials: Laravel Database Expert is instructions for the agent only.

Does Laravel Database Expert access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Laravel Database Expert safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Laravel Database Expert use?

Laravel Database Expert is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Laravel Database Expert use?

About 802 tokens (SKILL.md is roughly 3.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 298 tokens, read only when the agent opens those files.

What are the alternatives to Laravel Database Expert?

Skills that share tags, products or a category with Laravel Database Expert: Configuring Horizon (coollabsio/coolify, 63k stars), FastAPI-Redis SDK Development (redis/fastapi-redis-sdk, 405 stars), Pulse Development (MineTrax/minetrax, 116 stars) and Olm Architecture (OpenLitterMap/openlittermap-web, 134 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Laravel Database Expert?

HoangNguyen0403 (a GitHub user) maintains it in HoangNguyen0403/agent-skills-standard, which has 572 GitHub stars. The repository holds 211 skills in this directory. The repository was last updated on October 9, 2026.

Source: HoangNguyen0403/agent-skills-standard on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.