Make Migration

Each database engine (dialect) has its own schema, so you need to specify the engine when creating a migration.

Example database engines: mysql, sqlite, mariadb, postgresql, clickhouse, redshift.

JetShift supports all SQLAlchemy’s Dialects. For ClickHouse, the dialect name is clickhouse-sqlalchemy. You can simply use clickhouse instead of the full dialect name. Ensure you use the same name when running migrations or creating seeders.

To create a new migration for a table, use the following command:

jetshift make migration table-name -e database-engine

Example

jetshift make migration blogs # default engine is mysql
jetshift make migration blogs -e mysql