Skip to content

joseph0x45/squils

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

38 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Releases

No releases published

Packages

No packages published