SELECT * FROM db WHERE...

gosqlit

Terminal SQL Client

Multi-database SQL exploration with security and simplicity. Built with Go for developers who live in the terminal.

git clone https://github.com/imran-vz/gosqlit.git

See it in Action

Demo GIF

Features

🗄️ Multi-Database Support

PostgreSQL ready, MySQL and SQLite coming soon

🔒 Encrypted Credentials

AES-256-GCM encryption for secure connection storage

🌳 Schema Browser

Tree view of schemas and tables with easy navigation

✏️ Query Editor

Multi-line editor with paginated results (1000 rows, 50/page)

⚡ Query Control

Execute and cancel running queries instantly

🔄 Connection Management

Save, edit, and manage multiple database connections

Installation

# Requirements: Go 1.21+
git clone https://github.com/imran-vz/gosqlit.git
cd gosqlit
go build -o gosqlit
./gosqlit

Quick Start

  1. 1. Set master password on first run
  2. 2. Add database connection (press n)
  3. 3. Browse schemas in the tree view
  4. 4. Click a table to auto-generate SELECT query
  5. 5. Execute query with Ctrl+Enter

Keyboard Shortcuts

New connection n
Edit connection e
Delete connection d
Cycle focus Tab
Execute query Ctrl+Enter
Cancel query Ctrl+K
Refresh schemas F5
Quit q

Built with Go and Bubble Tea

View on GitHub