README

EVE Online's Static Data Export as Eloquent models.

This package downloads EVE Online's official Static Data Export (SDE) from CCP and seeds it into your Laravel application's database — complete with migrations, Eloquent models, and relationships. Build market tools, fitting apps, universe maps, or killboards on top of a fully queryable SDE without ever touching a YAML file.

What's included

Requirements

• PHP 8.3+ (tested up to 8.5, plus nightly)
• Laravel 12 or 13
• ext-zip

Installation

Install the package via composer:

composer require nicolaskion/sde

Publish and run the migrations:

php artisan vendor:publish --tag="sde-migrations"
php artisan migrate

Optionally, publish the config file:

php artisan vendor:publish --tag="sde-config"

Usage

Download the latest SDE from CCP:

php artisan sde:download

Seed everything into the database:

php artisan sde:seed

sde:seed orchestrates all individual seeders in dependency order. Each is also available on its own:

Querying the data

The models ship with their relationships wired up:

use NicolasKion\SDE\Models\Solarsystem;
use NicolasKion\SDE\Models\Type;

// A ship with its group, market group and dogma attributes
$rifter = Type::query()
    ->with(['group', 'marketGroup', 'typeAttributes'])
    ->where('name', 'Rifter')
    ->first();

// All low-sec systems in a region, with their stations
$systems = Solarsystem::query()
    ->with(['constellation', 'stations'])
    ->whereBetween('security', [0.1, 0.45])
    ->whereRelation('region', 'name', 'Heimatar')
    ->get();

Customizing the models

If you want to extend or override the bundled Eloquent models, publish them to your application and point the sde.models config entries at your own classes:

php artisan vendor:publish --tag="sde-models"

// config/sde.php
'models' => [
    'Type' => App\Models\Type::class,
    // ...
],

The seeders resolve every model through this config, so your overrides are used everywhere.

Keeping the data fresh

CCP updates the SDE with every game patch. To stay current, schedule the download and seed commands, e.g. in routes/console.php:

use Illuminate\Support\Facades\Schedule;

Schedule::command('sde:download')->weekly()->mondays()->at('11:30');
Schedule::command('sde:seed')->weekly()->mondays()->at('12:00');

Testing

composer test

This runs Rector (dry-run), Pint, PHPStan (level max) and Pest.

Changelog

Please see CHANGELOG for more information on what has changed recently. Releases are automated with release-please and published to Packagist.

Credits

• Nicolas Kion
• All Contributors

EVE Online and all related data are © CCP hf. This package is not affiliated with or endorsed by CCP.

License

The MIT License (MIT). Please see License File for more information.