squils v0.1.0

SQUILS (More like SQL Utils)

squils is a set of tools that aim to make working with sql databases easier

Supported databases

• Postgres
• SQLite
• MySQL

Features

• Migrations
• Visualize data
• Seeding
• Export data

Contributions are welcome :)

Installation

Download the cli using your favorite

pnpm install -g squils

Usage

Only the migration feature is working that the moment. I plan on adding a new feature every week.

Postgres - Migrations

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 <migrationversion><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