Migrations

QUESTPIE provides CLI commands for database schema management.

Development: Push

During development, use push to sync schema directly:

bunx questpie push

This applies schema changes without creating migration files.

For production, use migration files for auditable schema changes:

bunx questpie migrate:generate

Creates a migration file in your configured directory.

bunx questpie migrate:up

bunx questpie migrate:down

Drop everything and re-run all migrations:

bunx questpie migrate:fresh

Destroys all data. Development only.

Reset migration tracking state:

bunx questpie migrate:reset

questpie.config.ts

export default runtimeConfig({
	cli: {
		migrations: {
			directory: "./src/migrations",
		},
	},
});

Populate the database with initial data:

bunx questpie seed:run

Seed files go in the configured seeds directory:

questpie.config.ts

cli: {
  seeds: {
    directory: "./src/seeds",
  },
}