Can I test a migration before applying it to the database?

Yes, you can use the '--dry-run' flag with the migrate command to see the SQL that would be executed without actually modifying the database schema.

How do I generate a new migration file?

After modifying your Symfony entities, use the 'bin/console make:migration' command to automatically generate a PHP migration file containing the necessary SQL changes.

How do I handle migrations in a CI/CD pipeline?

Integrate 'bin/console doctrine:migrations:migrate --no-interaction --allow-no-migration' into your deployment script to automate database updates safely during deployment.

What is the safest way to rollback a migration?

You can use 'bin/console doctrine:migrations:migrate prev' to rollback to the immediately preceding version, or specify a specific version ID to return to a known stable state.

Doctrine Migrations for Symfony

Name: Doctrine Migrations for Symfony
Author: MakFly

byMakFly

•

Database Management

Manages database schema versioning and migrations within Symfony applications using Doctrine.

About

This skill provides Claude with specialized knowledge to manage the database lifecycle in Symfony projects. It covers everything from generating migrations based on entity changes and executing safe schema updates to handling complex data migrations and production deployment strategies. By following these patterns, developers can ensure database consistency, implement non-blocking updates for large tables, and integrate database versioning seamlessly into CI/CD pipelines.

Key Features

Advanced data migration patterns and conditional SQL execution
Schema validation and synchronization troubleshooting
Safe production deployment workflows with dry-run capabilities
21 GitHub stars
Automated migration generation from Doctrine entity changes
Comprehensive rollback and migration version control management

Use Cases

Syncing production database schemas with local entity modifications
Executing complex data transformations alongside structural SQL changes
Resolving migration conflicts in multi-developer team environments

About

Key Features

Advanced data migration patterns and conditional SQL execution
Schema validation and synchronization troubleshooting
Safe production deployment workflows with dry-run capabilities
21 GitHub stars
Automated migration generation from Doctrine entity changes
Comprehensive rollback and migration version control management

Use Cases

Syncing production database schemas with local entity modifications
Executing complex data transformations alongside structural SQL changes
Resolving migration conflicts in multi-developer team environments