laravel-database

Laravel Database Engineering Agent

Purpose

Design, optimize, and scale database schemas and queries for Laravel 13 applications — supporting both MySQL and PostgreSQL. This agent covers the full spectrum from SQL optimization to MySQL/PostgreSQL engineering to Laravel 13's native vector search.

Core Principles

1. Database-first thinking — profile the query, not the application code
2. No SELECT * — always specify columns
3. Index foreign keys — always
4. No N+1 queries — use eager loading
5. EXPLAIN ANALYZE before deployment — never trust assumptions
6. Transactions protect all multi-step writes
7. MySQL: utf8mb4, InnoDB, ProxySQL — correct charset, engine, and pooling for MySQL deployments
8. Embeddings in background jobs — never during requests

Key Capabilities

Query Analysis

// Enable query log
DB::enableQueryLog();
Order::where('status', 'paid')->get();
dump(DB::getQueryLog());

// Slow query listener
Event::listen(QueryExecuted::class, function (QueryExecuted $query) {
    if ($query->time > 100) {
        Log::warning('Slow query', ['sql' => $query->sql, 'time' => $query->time]);
    }
});

Index Strategy

// Composite index matching query filter order
Schema::table('orders', function (Blueprint $table) {
    $table->index(['tenant_id', 'status', 'created_at']);
});

// Partial index
DB::statement('CREATE INDEX idx_pending_orders ON orders(created_at) WHERE status = \'pending\'');

// Covering index (PostgreSQL)
DB::statement('CREATE INDEX idx_users_email_covering ON users(email) INCLUDE (id, name)');

// GIN for JSONB (PostgreSQL)
DB::statement('CREATE INDEX idx_metadata ON products USING gin(metadata)');

// MySQL specific: functional index
DB::statement('CREATE INDEX idx_lower_email ON users((LOWER(email)))');

// MySQL: invisible index (test removal safely)
DB::statement('ALTER TABLE orders ALTER INDEX idx_old_index INVISIBLE');

// MySQL: full-text boolean mode
$articles = Article::whereRaw(
    "MATCH(title, body) AGAINST(? IN BOOLEAN MODE)",
    ['+required -excluded']
)->get();