{"id":285,"date":"2025-08-27T19:14:19","date_gmt":"2025-08-27T19:14:19","guid":{"rendered":"https:\/\/1v0.net\/blog\/?p=285"},"modified":"2025-08-27T19:14:21","modified_gmt":"2025-08-27T19:14:21","slug":"building-a-multi-tenant-app-in-laravel-with-separate-databases","status":"publish","type":"post","link":"https:\/\/1v0.net\/blog\/building-a-multi-tenant-app-in-laravel-with-separate-databases\/","title":{"rendered":"Building a Multi-Tenant App in Laravel with Separate Databases"},"content":{"rendered":"\n

Building a Multi-Tenant App in Laravel with Separate Databases<\/strong><\/h2>\n\n\n\n

In a multi-tenant architecture with separate databases, each customer gets their own schema. This provides strong data isolation, simplifies compliance, and makes backups or migrations safer. In this tutorial, we\u2019ll build a central database for tenants, dynamically switch DB connections per request, define a tenant-aware base model, run per-tenant migrations, seed both central and tenant databases, and create an admin UI + sample controller to operate on tenant data.<\/p>\n\n\n\n

<\/div>\n\n\n\n\n

1 – Central Database for Tenants<\/strong><\/h2>\n\n\n\n

Create a central tenants<\/code> table to store each customer\u2019s domain and DB credentials. This table lives in the default connection (usually mysql<\/code>).<\/p>\n\n\n

\/\/ database\/migrations\/2025_08_27_000000_create_tenants_table.php<\/span>\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Migrations<\/span>\\Migration<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Schema<\/span>\\Blueprint<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Schema<\/span>;\n\nreturn<\/span> new<\/span> class<\/span> extends<\/span> Migration<\/span> <\/span>{\n    public<\/span> function<\/span> up<\/span>()<\/span>: void<\/span> <\/span>{\n        Schema::create('tenants'<\/span>, function<\/span> (Blueprint $table)<\/span> <\/span>{\n            $table->id();\n            $table->string('name'<\/span>);\n            $table->string('domain'<\/span>)->unique();   \/\/ e.g. acme.example.com<\/span>\n            $table->string('database'<\/span>)->unique(); \/\/ e.g. tenant_acme<\/span>\n            $table->string('db_host'<\/span>)->default('127.0.0.1'<\/span>);\n            $table->unsignedInteger('db_port'<\/span>)->default(3306<\/span>);\n            $table->string('db_username'<\/span>);\n            $table->string('db_password'<\/span>);\n            $table->timestamps();\n        });\n    }\n    public<\/span> function<\/span> down<\/span>()<\/span>: void<\/span> <\/span>{\n        Schema::dropIfExists('tenants'<\/span>);\n    }\n};<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Each row represents one tenant. The domain<\/code> identifies requests, and the DB credentials allow dynamically connecting to that tenant\u2019s database. Store secrets securely in production (e.g., encrypt db_password<\/code> or use a secret manager).<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
2 – Models and Base Class<\/strong><\/h2>\n\n\n\n
Define a central Tenant<\/code> model and a tenant-aware base model. Tenant-owned models will extend the base and automatically use the tenant connection after middleware config.<\/p>\n\n\n
\/\/ app\/Models\/Tenant.php<\/span>\nnamespace<\/span> App<\/span>\\Models<\/span>;\n\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\Model<\/span>;\n\nclass<\/span> Tenant<\/span> extends<\/span> Model<\/span>\n<\/span>{\n    protected<\/span> $connection = 'mysql'<\/span>; \/\/ central DB<\/span>\n    protected<\/span> $fillable = [\n        'name'<\/span>, 'domain'<\/span>, 'database'<\/span>, 'db_host'<\/span>, 'db_port'<\/span>, 'db_username'<\/span>, 'db_password'<\/span>\n    ];\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This model reads from the central database and exposes tenant rows we\u2019ll use at runtime to configure the per-request tenant connection.<\/p>\n\n\n
\/\/ app\/Models\/TenantModel.php<\/span>\nnamespace<\/span> App<\/span>\\Models<\/span>;\n\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\Model<\/span>;\n\nabstract<\/span> class<\/span> TenantModel<\/span> extends<\/span> Model<\/span>\n<\/span>{\n    protected<\/span> $connection = 'tenant'<\/span>; \/\/ dynamic connection, set per request<\/span>\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Any model extending TenantModel<\/code> will query the tenant<\/code> connection. We\u2019ll create and reconnect that connection dynamically in middleware before controllers run.<\/p>\n\n\n
\/\/ app\/Models\/TenantUser.php<\/span>\nnamespace<\/span> App<\/span>\\Models<\/span>;\n\nuse<\/span> Illuminate<\/span>\\Foundation<\/span>\\Auth<\/span>\\User<\/span> as<\/span> Authenticatable<\/span>;\n\nclass<\/span> TenantUser<\/span> extends<\/span> Authenticatable<\/span>\n<\/span>{\n    protected<\/span> $connection = 'tenant'<\/span>;\n    protected<\/span> $fillable = ['name'<\/span>,'email'<\/span>,'password'<\/span>];\n    protected<\/span> $hidden = ['password'<\/span>,'remember_token'<\/span>];\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This tenant-scoped user model lives in each tenant DB and supports isolated authentication per customer.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
3 – Middleware to Configure the Tenant Connection<\/strong><\/h2>\n\n\n\n
Detect the tenant by the request\u2019s host, then configure and reconnect the tenant<\/code> connection for the lifetime of the request.<\/p>\n\n\n
\/\/ app\/Http\/Middleware\/IdentifyTenant.php<\/span>\nnamespace<\/span> App<\/span>\\Http<\/span>\\Middleware<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\Tenant<\/span>;\nuse<\/span> Closure<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Config<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\DB<\/span>;\n\nclass<\/span> IdentifyTenant<\/span>\n<\/span>{\n    public<\/span> function<\/span> handle<\/span>($request, Closure $next)<\/span>\n    <\/span>{\n        $host = $request->getHost(); \/\/ e.g. acme.example.com<\/span>\n        $tenant = Tenant::where('domain'<\/span>, $host)->firstOrFail();\n\n        Config::set('database.connections.tenant'<\/span>, [\n            'driver'<\/span>   => 'mysql'<\/span>,\n            'host'<\/span>     => $tenant->db_host,\n            'port'<\/span>     => $tenant->db_port,\n            'database'<\/span> => $tenant->database,\n            'username'<\/span> => $tenant->db_username,\n            'password'<\/span> => $tenant->db_password,\n            'charset'<\/span>  => 'utf8mb4'<\/span>,\n            'collation'<\/span>=> 'utf8mb4_unicode_ci'<\/span>,\n        ]);\n\n        DB::purge('tenant'<\/span>);\n        DB::reconnect('tenant'<\/span>);\n\n        return<\/span> $next($request);\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This middleware looks up the tenant record, injects its DB config into runtime configuration, purges any stale connection, and reconnects. All subsequent Eloquent calls against tenant<\/code> use the correct database.<\/p>\n\n\n\n
Register it in app\/Http\/Kernel.php<\/code>, then protect your tenant routes with it:<\/p>\n\n\n
\/\/ app\/Http\/Kernel.php (snippet)<\/span>\nprotected<\/span> $routeMiddleware = [\n    \/\/ ...<\/span>\n    'tenant'<\/span> => \\App\\Http\\Middleware\\IdentifyTenant::class,\n];<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This makes the middleware available as tenant<\/code> for route groups and controllers.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
4 – Per-Tenant Migrations<\/strong><\/h2>\n\n\n\n
Create a command to loop tenants and run migrate<\/code> (or migrate:fresh<\/code>) against the tenant<\/code> connection after configuring it (same logic as the middleware).<\/p>\n\n\n
\/\/ app\/Console\/Commands\/TenantsMigrate.php<\/span>\nnamespace<\/span> App<\/span>\\Console<\/span>\\Commands<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\Tenant<\/span>;\nuse<\/span> Illuminate<\/span>\\Console<\/span>\\Command<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Artisan<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Config<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\DB<\/span>;\n\nclass<\/span> TenantsMigrate<\/span> extends<\/span> Command<\/span>\n<\/span>{\n    protected<\/span> $signature = 'tenants:migrate {--fresh}'<\/span>;\n    protected<\/span> $description = 'Run migrations for all tenants'<\/span>;\n\n    public<\/span> function<\/span> handle<\/span>()<\/span>\n    <\/span>{\n        foreach<\/span> (Tenant::all() as<\/span> $tenant) {\n            $this<\/span>->info(\"Migrating: {$tenant->name}\"<\/span>);\n\n            Config::set('database.connections.tenant'<\/span>, [\n                'driver'<\/span> => 'mysql'<\/span>,\n                'host'<\/span> => $tenant->db_host,\n                'port'<\/span> => $tenant->db_port,\n                'database'<\/span> => $tenant->database,\n                'username'<\/span> => $tenant->db_username,\n                'password'<\/span> => $tenant->db_password,\n                'charset'<\/span> => 'utf8mb4'<\/span>,\n                'collation'<\/span> => 'utf8mb4_unicode_ci'<\/span>,\n            ]);\n            DB::purge('tenant'<\/span>);\n            DB::reconnect('tenant'<\/span>);\n\n            $cmd = $this<\/span>->option('fresh'<\/span>) ? 'migrate:fresh'<\/span> : 'migrate'<\/span>;\n            Artisan::call($cmd, ['--database'<\/span> => 'tenant'<\/span>, '--force'<\/span> => true<\/span>]);\n\n            $this<\/span>->line(Artisan::output());\n        }\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Running php artisan tenants:migrate<\/code> applies your tenant schema to every tenant DB. Use --fresh<\/code> to rebuild from scratch (only in safe environments).<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
5 – Seeders: Central Tenant + Per-Tenant Data<\/strong><\/h2>\n\n\n\n
Seed a demo tenant in the central DB, then loop over tenants to seed each tenant DB (users, demo content, etc.).<\/p>\n\n\n
\/\/ database\/seeders\/TenantSeeder.php  (CENTRAL DB)<\/span>\nnamespace<\/span> Database<\/span>\\Seeders<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\Tenant<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Seeder<\/span>;\n\nclass<\/span> TenantSeeder<\/span> extends<\/span> Seeder<\/span>\n<\/span>{\n    public<\/span> function<\/span> run<\/span>()<\/span>: void<\/span>\n    <\/span>{\n        Tenant::firstOrCreate(\n            ['domain'<\/span> => 'acme.local'<\/span>],\n            [\n                'name'<\/span>        => 'Acme Inc'<\/span>,\n                'database'<\/span>    => 'tenant_acme'<\/span>,\n                'db_host'<\/span>     => '127.0.0.1'<\/span>,\n                'db_port'<\/span>     => 3306<\/span>,\n                'db_username'<\/span> => 'root'<\/span>,\n                'db_password'<\/span> => ''<\/span>,\n            ]\n        );\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This creates a sample tenant row in the central database pointing to a tenant database named tenant_acme<\/code>. Create that database manually or via automation when provisioning.<\/p>\n\n\n
\/\/ database\/seeders\/TenantDatabaseSeeder.php  (RUNS INSIDE TENANT DB)<\/span>\nnamespace<\/span> Database<\/span>\\Seeders<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\TenantUser<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Seeder<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Hash<\/span>;\n\nclass<\/span> TenantDatabaseSeeder<\/span> extends<\/span> Seeder<\/span>\n<\/span>{\n    public<\/span> function<\/span> run<\/span>()<\/span>: void<\/span>\n    <\/span>{\n        TenantUser::firstOrCreate(\n            ['email'<\/span> => 'owner@acme.local'<\/span>],\n            ['name'<\/span> => 'Acme Owner'<\/span>, 'password'<\/span> => Hash::make('password'<\/span>)]\n        );\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This seeder targets the tenant DB and creates a default tenant user. It assumes the connection named tenant<\/code> is already configured before running.<\/p>\n\n\n
\/\/ app\/Console\/Commands\/TenantsSeed.php<\/span>\nnamespace<\/span> App<\/span>\\Console<\/span>\\Commands<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\Tenant<\/span>;\nuse<\/span> Illuminate<\/span>\\Console<\/span>\\Command<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Artisan<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Config<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\DB<\/span>;\n\nclass<\/span> TenantsSeed<\/span> extends<\/span> Command<\/span>\n<\/span>{\n    protected<\/span> $signature = 'tenants:seed'<\/span>;\n    protected<\/span> $description = 'Run seeders for all tenants'<\/span>;\n\n    public<\/span> function<\/span> handle<\/span>()<\/span>\n    <\/span>{\n        foreach<\/span> (Tenant::all() as<\/span> $tenant) {\n            $this<\/span>->info(\"Seeding: {$tenant->name}\"<\/span>);\n\n            Config::set('database.connections.tenant'<\/span>, [\n                'driver'<\/span> => 'mysql'<\/span>,\n                'host'<\/span> => $tenant->db_host,\n                'port'<\/span> => $tenant->db_port,\n                'database'<\/span> => $tenant->database,\n                'username'<\/span> => $tenant->db_username,\n                'password'<\/span> => $tenant->db_password,\n                'charset'<\/span> => 'utf8mb4'<\/span>,\n                'collation'<\/span> => 'utf8mb4_unicode_ci'<\/span>,\n            ]);\n            DB::purge('tenant'<\/span>);\n            DB::reconnect('tenant'<\/span>);\n\n            \/\/ Run the tenant-specific seeder class<\/span>\n            Artisan::call('db:seed'<\/span>, [\n                '--database'<\/span> => 'tenant'<\/span>,\n                '--class'<\/span>    => \\Database\\Seeders\\TenantDatabaseSeeder::class,\n                '--force'<\/span>    => true<\/span>,\n            ]);\n\n            $this<\/span>->line(Artisan::output());\n        }\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Run php artisan tenants:seed<\/code> after tenants:migrate<\/code> to populate each tenant DB. If you need different data per tenant, parameterize by $tenant<\/code> values or add factories.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
6 – Sample Controller That Uses the Tenant Database<\/strong><\/h2>\n\n\n\n
Protect tenant routes with the middleware so the tenant<\/code> connection is live. Then query tenant models as usual.<\/p>\n\n\n
\/\/ routes\/web.php (snippet)<\/span>\nuse<\/span> App<\/span>\\Http<\/span>\\Controllers<\/span>\\TenantDashboardController<\/span>;\n\nRoute::middleware('tenant'<\/span>)->group(function<\/span> ()<\/span> <\/span>{\n    Route::get('\/dashboard'<\/span>, [TenantDashboardController::class, 'index'<\/span>])\n        ->name('tenant.dashboard'<\/span>);\n});<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This route group ensures that requests pass through IdentifyTenant<\/code> first. Inside the controller, any Eloquent query against tenant<\/code> models will hit the tenant DB.<\/p>\n\n\n
\/\/ app\/Http\/Controllers\/TenantDashboardController.php<\/span>\nnamespace<\/span> App<\/span>\\Http<\/span>\\Controllers<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\TenantUser<\/span>;\nuse<\/span> Illuminate<\/span>\\Http<\/span>\\Request<\/span>;\n\nclass<\/span> TenantDashboardController<\/span> extends<\/span> Controller<\/span>\n<\/span>{\n    public<\/span> function<\/span> index<\/span>(Request $request)<\/span>\n    <\/span>{\n        $usersCount = TenantUser::count();\n        $latestUsers = TenantUser::orderBy('id'<\/span>,'desc'<\/span>)->limit(5<\/span>)->get();\n\n        return<\/span> view('tenant.dashboard'<\/span>, compact('usersCount'<\/span>,'latestUsers'<\/span>));\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This controller reads from the tenant database via TenantUser<\/code>. The middleware made sure the tenant<\/code> connection was configured before these queries run.<\/p>\n\n\n
<!-- resources\/views\/tenant\/dashboard.blade.php -->\n@extends('layouts.app'<\/span>)\n\n@section('content'<\/span>)\n<div class<\/span>=\"container<\/span>\">\n  <h1<\/span> class<\/span>=\"mb<\/span>-4\">Tenant<\/span> Dashboard<\/span><\/h1<\/span>>\n\n  <div<\/span> class<\/span>=\"card<\/span> mb<\/span>-3\">\n    <div<\/span> class<\/span>=\"card<\/span>-body<\/span>\">\n      <h5<\/span> class<\/span>=\"card<\/span>-title<\/span>\">Users<\/span><\/h5<\/span>>\n      <p<\/span> class<\/span>=\"card<\/span>-text<\/span> mb<\/span>-0\">Total<\/span> Users<\/span>: <\/span>{{ $usersCount }}<\/p>\n    <\/div>\n  <\/div>\n\n  <h5 class<\/span>=\"mt<\/span>-4 mb<\/span>-3\">Latest<\/span> Users<\/span><\/h5<\/span>>\n  @foreach<\/span>($latestUsers<\/span> as<\/span> $user<\/span>)\n    <div<\/span> class<\/span>=\"card<\/span> mb<\/span>-2\">\n      <div<\/span> class<\/span>=\"card<\/span>-body<\/span> d<\/span>-flex<\/span> justify<\/span>-content<\/span>-between<\/span>\">\n        <span<\/span>><\/span>{{ $user->name }} ({{ $user->email }})<\/span>\n        <a href=\"#\"<\/span> class<\/span>=\"btn<\/span> btn<\/span>-sm<\/span> btn<\/span>-theme<\/span> r<\/span>-04\">View<\/span><\/a<\/span>>\n      <\/div<\/span>>\n    <\/div<\/span>>\n  @endforeach<\/span>\n<\/div<\/span>>\n@endsection<\/span><\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The Blade UI shows basic stats and a recent users list from the tenant DB. You can expand this with charts, filters, or pagination as needed.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
7 – Admin UI for Provisioning Tenants (Central)<\/strong><\/h2>\n\n\n\n
Provide a minimal central admin to create tenants. After creating a row, create the DB, run tenant migrations, and optionally seed it.<\/p>\n\n\n
\/\/ app\/Http\/Controllers\/TenantAdminController.php<\/span>\nnamespace<\/span> App<\/span>\\Http<\/span>\\Controllers<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\Tenant<\/span>;\nuse<\/span> Illuminate<\/span>\\Http<\/span>\\Request<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Artisan<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Config<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\DB<\/span>;\n\nclass<\/span> TenantAdminController<\/span> extends<\/span> Controller<\/span>\n<\/span>{\n    public<\/span> function<\/span> index<\/span>()<\/span>\n    <\/span>{\n        return<\/span> view('tenants.index'<\/span>, ['tenants'<\/span> => Tenant::all()]);\n    }\n\n    public<\/span> function<\/span> store<\/span>(Request $request)<\/span>\n    <\/span>{\n        $tenant = Tenant::create($request->validate([\n            'name'<\/span>        => 'required|string|max:100'<\/span>,\n            'domain'<\/span>      => 'required|string|max:191|unique:tenants,domain'<\/span>,\n            'database'<\/span>    => 'required|string|max:191|unique:tenants,database'<\/span>,\n            'db_host'<\/span>     => 'required|string'<\/span>,\n            'db_port'<\/span>     => 'required|integer'<\/span>,\n            'db_username'<\/span> => 'required|string'<\/span>,\n            'db_password'<\/span> => 'nullable|string'<\/span>,\n        ]));\n\n        DB::statement(\"CREATE DATABASE `{$tenant->database}`\"<\/span>);\n\n        Config::set('database.connections.tenant'<\/span>, [\n            'driver'<\/span>   => 'mysql'<\/span>,\n            'host'<\/span>     => $tenant->db_host,\n            'port'<\/span>     => $tenant->db_port,\n            'database'<\/span> => $tenant->database,\n            'username'<\/span> => $tenant->db_username,\n            'password'<\/span> => $tenant->db_password,\n            'charset'<\/span>  => 'utf8mb4'<\/span>,\n            'collation'<\/span>=> 'utf8mb4_unicode_ci'<\/span>,\n        ]);\n        DB::purge('tenant'<\/span>);\n        DB::reconnect('tenant'<\/span>);\n\n        Artisan::call('migrate'<\/span>, ['--database'<\/span> => 'tenant'<\/span>, '--force'<\/span> => true<\/span>]);\n        Artisan::call('db:seed'<\/span>, [\n            '--database'<\/span> => 'tenant'<\/span>,\n            '--class'<\/span>    => \\Database\\Seeders\\TenantDatabaseSeeder::class,\n            '--force'<\/span>    => true<\/span>,\n        ]);\n\n        return<\/span> redirect()->back()->with('status'<\/span>,'Tenant created and initialized'<\/span>);\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
On submission, this creates the tenant DB, prepares the connection, migrates it, and seeds an initial user. Add authorization controls so only super-admins can access this endpoint.<\/p>\n\n\n
<!-- resources\/views\/tenants\/index.blade.php -->\n@extends('layouts.app'<\/span>)\n\n@section('content'<\/span>)\n<div class<\/span>=\"container<\/span>\">\n  <h1<\/span> class<\/span>=\"mb<\/span>-4\">Tenants<\/span><\/h1<\/span>>\n\n  @if<\/span>(session<\/span>('status<\/span>'))\n    <div<\/span> class<\/span>=\"alert<\/span> alert<\/span>-success<\/span>\"><\/span>{{ session('status'<\/span>) }}<\/div>\n  @endif<\/span>\n\n  @foreach<\/span>($tenants as<\/span> $tenant)\n    <div class<\/span>=\"card<\/span> mb<\/span>-2\">\n      <div<\/span> class<\/span>=\"card<\/span>-body<\/span>\">\n        <strong<\/span>><\/span>{{ $tenant->name }}<\/strong> \u2014 {{ $tenant->domain }}\n      <\/div>\n    <\/div>\n  @endforeach<\/span>\n\n  <h5 class<\/span>=\"mt<\/span>-4\">Create<\/span> Tenant<\/span><\/h5<\/span>>\n  <form<\/span> method<\/span>=\"POST<\/span>\" action<\/span>=\"<\/span>{{ route('tenants.store'<\/span>) }}\" class=\"<\/span>mt-2<\/span>\">\n    @csrf\n    <div class=\"<\/span>row g-2<\/span>\">\n      <div class=\"<\/span>col-md-4<\/span>\"><input name=\"<\/span>name\" class=\"<\/span>form-control\" placeholder=\"<\/span>Tenant Name\" required\/><\/div>\n      <div class=\"<\/span>col-md-4<\/span>\"><input name=\"<\/span>domain\" class=\"<\/span>form-control\" placeholder=\"<\/span>Domain (e.g. acme.local)\" required\/><\/div>\n      <div class=\"<\/span>col-md-4<\/span>\"><input name=\"<\/span>database\" class=\"<\/span>form-control\" placeholder=\"<\/span>DB Name (e.g. tenant_acme)\" required\/><\/div>\n      <div class=\"<\/span>col-md-3<\/span>\"><input name=\"<\/span>db_host\" class=\"<\/span>form-control\" value=\"<\/span>127.0<\/span>.0<\/span>.1<\/span>\" required\/><\/div>\n      <div class=\"<\/span>col-md-3<\/span>\"><input name=\"<\/span>db_port\" class=\"<\/span>form-control\" value=\"<\/span>3306<\/span>\" required\/>><\/div>\n      <div class=\"<\/span>col-md-3<\/span>\"><input name=\"<\/span>db_username\" class=\"<\/span>form-control\" value=\"<\/span>root\" required\/><\/div>\n      <div class=\"<\/span>col-md-3<\/span>\"><input name=\"<\/span>db_password\" type=\"<\/span>password\" class=\"<\/span>form-control\" placeholder=\"<\/span>DB Password\"\/><\/div>\n    <\/div>\n    <button class=\"<\/span>btn btn-theme mt-3<\/span>\">Create and Initialize<\/button>\n  <\/form>\n<\/div>\n@endsection<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This minimal UI lists existing tenants and provides a form that provisions a new tenant end-to-end. In production, apply authorization, rate limiting, and detailed error handling.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
Wrapping Up<\/strong><\/h2>\n\n\n\n
You built a multi-tenant system with strict data isolation by using a central database for tenant metadata and a separate database per tenant. You configured the tenant connection at request-time via middleware, created a base model to route queries to the tenant DB, added migration and seeding commands for all tenants, and implemented an admin UI that provisions, migrates, and seeds new tenant databases automatically. This pattern scales well for compliance and backups, and provides clear boundaries between customer data sets.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n
What\u2019s Next<\/strong><\/h2>\n\n\n\n