Migrash a language-agnostic simple SQL migration tool. It is designed to be simple and easy to use. Developed in Go, it seamlessly integrates into CI/CD pipelines for effortless deployment.
- PostgreSQL
- MySQL/MariaDB
- SQLite
The following commands are available:
migrash init- Create config file for migrash.migrash create- Create a new migration file and a directory if it does not exist.migrash up- Apply all migrations that have not yet been applied.migrash down- Rollback the last migration.migrash redo- Rollback the last migration and then apply it again.migrash reset- Rollback all migrations.migrash status- Show status check if there are pending or executed migrations.
Soon...
Migrash utilizes the DATABASE_URL for establishing a connection to the database, where the DATABASE_URL environment variable or config field represents a URL format specifying the database connection as dialect://user:password@host:port/database?param1=value1¶m2=value2.
The configuration file is located in the root directory of the project and is called .migrashrc. The configuration file is a text file that used before each command.
Example configuration file can be found in the root directory of the project. or here.
Migration files are located in the migrations directory by default. The name of the migration dir will be in the format YYYYMMDDHHMMSS-name, inside the directory there will be two files up.sql and down.sql. The up.sql file contains the SQL query to apply the migration, and the down.sql file contains the SQL query to rollback the migration.
This project is licensed under the terms of the WTFPL license.