Laravel Scale

Laravel Scale is a production-focused, modular package suite for Laravel applications that need database performance, scalability, and reliability from thousands to billions of records.

Highlights

• Multi-package architecture with independent installable modules
• Adapter-based database support (MySQL, MariaDB, PostgreSQL, SQLite, SQL Server)
• Architecture-ready aliases for Oracle and CockroachDB drivers
• Query intelligence: slow queries, duplicate queries, N+1 detection, fingerprinting
• Index intelligence recommendations
• Lifecycle tooling: archive and cleanup commands
• Health scoring and report generation
• Optional integrations: Debugbar, Telescope, Pulse, OpenTelemetry

Package Layout

• laravel-scale/core
• laravel-scale/database
• laravel-scale/query
• laravel-scale/index
• laravel-scale/cache
• laravel-scale/lifecycle
• laravel-scale/monitor
• laravel-scale/report
• laravel-scale/debugbar (optional)
• laravel-scale/telescope (optional)
• laravel-scale/pulse (optional)
• laravel-scale/opentelemetry (optional)

Installation

composer require laravel-scale/core laravel-scale/query laravel-scale/index laravel-scale/cache laravel-scale/monitor

Publish configuration:

php artisan vendor:publish --tag=scale-config

Configuration

config/scale.php:

return [
    'enabled' => true,
    'driver' => 'auto',
    'monitoring' => [
        'enabled' => true,
        'sampling' => 10,
    ],
    'query' => [
        'slow_threshold' => 500,
    ],
    'storage' => [
        'enabled' => true,
    ],
];

Facade API

use LaravelScale\Facades\Scale;

Scale::analyze();
Scale::health();
Scale::report();
Scale::score();
Scale::chunk(App\Models\Order::class);
Scale::cursor(App\Models\Order::class);

Commands

• php artisan scale:doctor
• php artisan scale:queries
• php artisan scale:indexes
• php artisan scale:database
• php artisan scale:health
• php artisan scale:report --format=json
• php artisan scale:archive
• php artisan scale:cleanup

Extending Database Drivers

use LaravelScale\Facades\Scale;

Scale::extendDatabaseDriver('custom', App\Scale\Drivers\CustomDriver::class);

Event System

Events include:

• SlowQueryDetected
• IndexRecommendationCreated
• NPlusOneDetected
• HealthScoreChanged
• ArchiveCompleted
• StorageWarning

Testing

composer test
composer analyse
vendor/bin/php-cs-fixer fix --dry-run --diff

License

MIT