db-migrations

To run database migrations for Madoc TypeScript, execute the src/migrate.ts or migrate.cjs entrypoints from the services/madoc-ts directory with the appropriate DATABASE_* environment variables set to apply pending SQL files to the target database.

You need to configure appropriate DATABASE_* environment variables to execute Madoc database migrations. These variables provide the connection details required by the Slonik migrator to apply SQL files to your target database during development or deployment.

The correct file layout for Madoc TypeScript database migrations places SQL migration files in services/madoc-ts/migrations, with execution entrypoints located in services/madoc-ts/src/migrate.ts and migrate.cjs to ensure the migrator finds and applies schema changes properly.

TypeScript database migrations may fail to apply during deployment due to common pitfalls like incorrect filename formats, mismatched migration paths in services/madoc-ts, or missing DATABASE_* environment variables required by the Slonik migrator entrypoints.

Yes, you can use CommonJS to run Madoc database migrations by utilizing the migrate.cjs entrypoint alongside the TypeScript runner, allowing flexible integration within different development and deployment workflows while applying pending SQL files.

Yes, you can use CommonJS to run Madoc database migrations by utilizing the migrate.cjs entrypoint alongside the TypeScript runner, allowing flexible integration within different development and deployment workflows while applying pending SQL files.