Database Migrations

Festi plugins ship SQL migration files that are applied with the festi-migrate CLI tool from the festi-team/festi-framework-cli package.

Basic Concepts

• Each plugin has an install/ directory with install.{engine}.sql (full schema for fresh installs) and update.{engine}.sql (incremental migrations for upgrades).
• The host project keeps its own dumps/updatesN.sql files that the CLI applies in filename sort order.
• Every schema change must be added to all engine files (PostgreSQL, MySQL, MSSQL) at once and must be safe to re-apply.

Read More

For the full guide — file layout, idempotency rules, multi-engine patterns, transaction wrapping, and the plugin-vs-project migration split — see Festi CLI Migrations documentation.