squils is a set of tools that aim to make working with sql databases easier
- Postgres
- SQLite
- MySQL
- Migrations
- Visualize data
- Seeding
- Export data
Contributions are welcome :)
Download the cli using your favorite
pnpm install -g squils
Only the migration feature is working that the moment. I plan on adding a new feature every week.
First of all you will need to create a folder named 'migrations' and you will create your sql files in that folder. Make sure to follow the naming convention for the files which is the following <migration_version>_<migration_name>.sql Once done, create a .env file and add your database url inside of it.
DB_URL="postgres://username:password@host/database"Your folder structure should look like this
migrations/
00001_create_users.sql
00001_create_indexes.sql
.env
Now run the squils migrate command and you're good to go. Report any errors you encounter here