Dynamic multi-schema PostgreSQL connections for Laravel. Schemify models
each PostgreSQL schema as a layer (a layer_items row pointing at a
db_connections row) and adds a --layer option to Laravel's migrate,
db:seed and db:wipe commands so you can run them against any layer's schema
on the fly. Layers can live in the same database (different schemas) or in
entirely different databases.
Schemify is a lightweight schema/connection switcher wired into the migration commands — not a full tenancy framework. If you need automatic tenant identification, cache/queue/filesystem isolation or single-DB row scoping, reach for stancl/tenancy or spatie/laravel-multitenancy.
| Versions | |
|---|---|
| PHP | 8.2 · 8.3 · 8.4 · 8.5 |
| Laravel | 11 · 12 · 13 |
| Database | PostgreSQL |
composer require dskripchenko/laravel-schemify
php artisan layers:installThe provider is auto-discovered. layers:install publishes the config and core
migration, creates the db_connections / layer_items tables on the central
connection, and registers the default main layer.
php artisan layers:new acme --schema=acme --migrate # create a layer + schema, run tenant migrations
php artisan migrate --layer=acme # migrate a single layer
php artisan layers:list # list layersuse Dskripchenko\Schemify\Facades\Schemify;
$total = Schemify::use('acme', fn () => Invoice::sum('amount'));Upgrading from 2.x? See UPGRADE.md and the CHANGELOG.
MIT © Denis Skripchenko