This project is heavily inspired by Lazygit, which I think is the best TUI client for Git.

I wanted to have a tool like that, but for SQL. I didn't find one that fits my needs, so I created one myself.

I live in the terminal, so if you are like me, this tool can become handy for you too.

This is my first Open Source project, also, this is my first Go project. I am not a brilliant programmer. I am just a typical JavaScript developer that wanted to learn a new language, I also wanted a TUI SQL Client, so white and bottled.

This project is in ALPHA stage, please feel free to complain about my spaghetti code.

I use Lazysql daily in my full-time job as a full-stack javascript developer in its current (buggy xD) state. So, the plan is to improve and fix my little boy as a side-project in my free time.

• Cross-platform (macOS, Windows, Linux)
• Vim Keybindings
• Can manage multiple connections (Backspace)
• Tabs
• SQL Editor (CTRL + e)

brew tap jorgerojas26/lazysql
brew install lazysql

go install github.com/jorgerojas26/lazysql@latest

For Windows, macOS or Linux, you can download a binary release here

Arch Linux users can install it from the AUR with:

paru -S lazysql

or

yay -S lazysql

or install it manual with:

git clone https://aur.archlinux.org/lazysql.git
cd lazysql
makepkg -si

(back to top)

$ lazysql

(back to top)

• MySQL
• PostgreSQL
• SQLite
• MSSQL
• MongoDB

Support for multiple RDBMS is a work in progress.

Specific editor for lazysql can be set by $SQL_EDITOR.

Specific terminal for opening editor can be set by $SQL_TERMINAL

postgres://user:pass@localhost/dbname
pg://user:pass@localhost/dbname?sslmode=disable
mysql://user:pass@localhost/dbname
mysql:/var/run/mysqld/mysqld.sock
sqlserver://user:pass@remote-host.com/dbname
mssql://user:pass@remote-host.com/instance/dbname
ms://user:pass@remote-host.com:port/instance/dbname?keepAlive=10
oracle://user:pass@somehost.com/sid
sap://user:pass@localhost/dbname
sqlite:/path/to/file.db
file:myfile.sqlite3?loc=auto
odbc+postgres://user:pass@localhost:port/dbname?option1=

• Support for NoSQL databases
• Columns and indexes creation through TUI
• Table tree input filter
• Custom keybindings
• Show keybindings on a modal
• Rewrite row create, update and delete logic

See the open issues for a full list of proposed features (and known issues).

(back to top)

Contributions, issues, and pull requests are welcome!

(back to top)

Distributed under the MIT License. See LICENSE.txt for more information.

(back to top)

Jorge Rojas - LinkedIn - jorgeluisrojasb@gmail.com

(back to top)

• Mitzasql
• Gobang

(back to top)