Tenant CLI Commands Reference

The Symfony Multi-Tenancy Bundle ships with a suite of tenant:* console commands to manage tenants dbs. These commands decorate the existing Doctrine commands providing the same flags, options, and behavior while adding tenant database, migration, and fixture management.

Below is a consolidated reference with detailed examples and optional flags for each command.

Tenant Database Create (tenant:database:create)

Command: tenant:database:create

Create one or more tenant databases (if they don’t exist) and run initial migrations.

# Create a single tenant DB by ID
php bin/console tenant:database:create --dbid=5

# Create all tenants defined in the main registry
php bin/console tenant:database:create --all

Options & Flags:

• --dbid=<id> ✔️ Create or migrate only the tenant with the given ID.
• --all ✔️ Loop through and process all registered tenants.
• --force ⚠️ Skip confirmation prompts when running in interactive mode.
• --dry-run 🔍 Show SQL and actions without executing.

Schema Diff Generation (tenant:migration:diff)

Command: tenant:migration:diff

Generate a Doctrine schema diff for tenant entities, placing new migration files under migrations/Tenant.

# Generate diff for tenant #3
php bin/console tenant:migration:diff --dbid=3

# Generate diffs for all tenants
php bin/console tenant:migration:diff --all

Options & Flags:

• --dbid=<id> Generate diff for a specific tenant.
• --all Generate diffs for every tenant in the registry.
• --formatted Apply coding standards (PHP-CS-Fixer) to the generated file.
• --dry-run Output SQL without writing files.

Schema Migration (tenant:migration:migrate)

Command: tenant:migration:migrate

Apply schema migrations to tenant databases. Supports initializing new DBs or updating existing ones.

# Initialize migrations on a new tenant DB
php bin/console tenant:migration:migrate init --dbid=4

# Update existing tenants to the latest version
php bin/console tenant:migration:migrate update --all

Subcommand	Description
init	Run pending migrations on newly created DBs
update	Upgrade all existing DBs to latest schema

Options & Flags:

• --dbid=<id> Apply only to the specified tenant.
• --all Apply to every tenant.
• --step=<n> Limit to the next n migration versions.
• --dry-run Show SQL without making changes.

Fixture Loading (tenant:fixtures:load)

Command: tenant:fixtures:load

Load Doctrine fixtures into tenant databases. Only classes annotated with #[TenantFixture] will be executed.

# Load fixtures for tenant #7, appending to existing data
php bin/console tenant:fixtures:load --dbid=7 --append

# Purge with TRUNCATE, then load for all tenants
php bin/console tenant:fixtures:load --all --purge-with-truncate

Options & Flags:

• --dbid=<id> Target a specific tenant.
• --all Run for every tenant in the system.
• --append Do not purge existing data; append only.
• --purge-with-truncate Purge tables by TRUNCATE instead of DELETE.
• --group=<name> Load only fixtures in the specified group.
• --no-interaction Run in non-interactive mode, skipping confirmations.

With these commands and flags, you can fully automate tenant provisioning, schema evolution, and test data loading from the Symfony console or your CI/CD pipelines.