{"repo":"gigagrug/schema","free":true,"listed":false,"github":"https://github.com/gigagrug/schema","clone":"git clone https://github.com/gigagrug/schema.git","description":"All in one CLI tool for the database | Migration, Studio, LSP","language":"Go","stars":220,"topics":["mysql","postgres","sqlite","sql","cli","studio","database-migrations","mariadb","database-schema","bubbletea"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Schema All in one CLI tool for the database SQLite, libSQL, Turso, PostgreSQL, MySQL, MariaDB Installation Install/upgrade latest version Install specific version Get Started Step 1 Init project (default: db=sqlite url=./schema/dev.db) Init project using another db and url Init project with different root directory Step 2 Nessesary if using existing database Migrations Step 1 Create a SQL file Step 2 Go to ./schema/migrations/1 initschema.sql (This SQL is for sqlite) Step 3 Migrates all the sql files not migrated Migrates specific sql file Rollback Rollbacks last migrated file Remove Removes if file not migrated Insert Dummy Data Step 1 Doesn't save in schema migrations table if not in migrations dir so they can be reused Step 2 Insert based on the SQL schema above. Step 3 Select query and prints table in console TUI SQL Studio LSP Headless If you don't want to use .env and schema.db Example: Subcommands version , v : Shows current and latest version init , i : Initializes project pull : Pulls database schema migrate : Migrates pending migrations rollback : Rollbacks last migration studio : Launch SQL TUI Studio lsp : Connect to your editor rollback \"[filename]\" Rollback a specific migration migrate \"[filename under migrations/]\" Run a specific migration sql \"[filename or sql query]\" Run SQL directly or from a file create \"[filename]\" : Create a new migration file remove \"[filename]\" , rm : Remove an unmigrated file from disk and db config : Edit config files for db type and ","default_branch":null,"files":null,"tree":[],"storefront":"/r/gigagrug","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gigagrug/schema/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}