The lazygit of SQL databases. Connect to Postgres, MySQL, SQL Server, SQLite, Turso, and more from your terminal in seconds.

A lightweight TUI for people who just want to run some queries fast.

• Connection manager UI - Save connections, switch between databases without CLI args
• Just run sqlit - No CLI config needed, pick a connection and go
• Multi-database out of the box - SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, Oracle, DuckDB, CockroachDB, Turso - no adapters to install
• SSH tunnels built-in - Connect to remote databases securely with password or key auth
• Vim-style editing - Modal editing for terminal purists
• Query history - Automatically saves queries per connection, searchable and sortable
• Context-aware help (no need to memorize keybindings)
• Browse databases, tables, views, and stored procedures
• SQL autocomplete for tables, columns, and procedures
• Multiple auth methods (Windows, SQL Server, Entra ID)
• CLI mode for scripting and AI agents
• Themes (Tokyo Night, Nord, and more)
• Auto-detects and installs ODBC drivers (SQL Server)

I usually do my work in the terminal, but I found myself either having to boot up massively bloated GUI's like SSMS or Vscode for the simple task of merely browsing my databases and doing some queries toward them. For the vast majority of my use cases, I never used any of the advanced features for inspection and debugging that SSMS and other feature-rich clients provide.

I had the unfortunate situation where doing queries became a pain-point due to the massive operation it is to open SSMS and it's lack of intuitive keyboard only navigation.

The problem got severely worse when I switched to Linux and had to rely on VS CODE's SQL extension to access my database. Something was not right.

I tried to use some existing TUI's for SQL, but they were not intuitive for me and I missed the immediate ease of use that other TUI's such as Lazygit provides.

sqlit is a lightweight database TUI that is easy to use and beautiful to look at, just connect and query. It's for you that just wants to run queries toward your database without launching applications that eats your ram and takes time to load up. Sqlit supports SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, Oracle, DuckDB, CockroachDB, and Turso, and is designed to make it easy and enjoyable to access your data, not painful.

pip install sqlit-tui

If you are missing Python packages for your database provider, sqlit will help you install them when you attempt to connect. If you want to pre-install requirements, see Adapter Requirements.

sqlit

The keybindings are shown at the bottom of the screen.

# Run a query
sqlit query -c "MyConnection" -q "SELECT * FROM Users"

# Output as CSV or JSON
sqlit query -c "MyConnection" -q "SELECT * FROM Users" --format csv
sqlit query -c "MyConnection" -f "script.sql" --format json

# Create connections for different databases
sqlit connection create --name "MySqlServer" --db-type mssql --server "localhost" --auth-type sql
sqlit connection create --name "MyPostgres" --db-type postgresql --server "localhost" --username "user" --password "pass"
sqlit connection create --name "MyMySQL" --db-type mysql --server "localhost" --username "user" --password "pass"
sqlit connection create --name "MyCockroach" --db-type cockroachdb --server "localhost" --port "26257" --database "defaultdb" --username "root"
sqlit connection create --name "MyLocalDB" --db-type sqlite --file-path "/path/to/database.db"
sqlit connection create --name "MyTurso" --db-type turso --server "libsql://your-db.turso.io" --password "your-auth-token"

# Connect via SSH tunnel
sqlit connection create --name "RemoteDB" --db-type postgresql --server "db-host" --username "dbuser" --password "dbpass" \
  --ssh-enabled --ssh-host "ssh.example.com" --ssh-username "sshuser" --ssh-auth-type password --ssh-password "sshpass"

# Manage connections
sqlit connection list
sqlit connection delete "MyConnection"

Autocomplete triggers automatically in INSERT mode. Use Tab to accept.

You can also receive autocompletion on columns by typing the table name and hitting "."

Connections and settings are stored in ~/.sqlit/.

Credentials are stored in plain text in a protected directory (~/.sqlit/) with restricted file permissions (700/600).

sqlit is inspired by lazygit - you can just jump in and there's no need for external documentation. The keybindings are shown at the bottom of the screen and the UI is designed to be intuitive without memorizing shortcuts.

Key differences:

• No need for external documentation - Sqlit embrace the "lazy" approach in that a user should be able to jump in and use it right away intuitively. There should be no setup instructions. If python packages are required for certain adapters, sqlit will help you install them as you need them.
• No CLI config required - Just run sqlit and pick a connection from the UI
• Lightweight - While Lazysql or Harlequin offer more features, I experienced that for the vast majority of cases, all I needed was a simple and fast way to connect and run queries. Sqlit is focused on doing a limited amount of things really well.

sqlit is built with Textual and inspired by:

• lazygit - Simple TUI for git
• lazysql - Terminal-based SQL client with connection manager

See CONTRIBUTING.md for development setup, testing, CI, and CockroachDB quickstart steps.

Each database provider requires specific Python packages. sqlit will prompt you to install these when needed, but you can also pre-install them:

Note: SQL Server also requires the ODBC driver. On first connection attempt, sqlit will detect if it's missing and help you install it.

MIT