Repolode
Submit
Maxteabag

Maxteabag/sqlit

A keyboard-driven terminal UI (TUI) for connecting to and querying many SQL databases, inspired by lazygit.

Open-source alternative to:DBeaverDataGripTablePlus

View on GitHub
Stars
4,909
Forks
174
Open issues
25
Last commit
21 days ago

What is it?

sqlit is a terminal user interface for SQL databases, written in Python and built on Textual. It lets you save connections, browse tables, views and other schema objects, write queries with syntax highlighting and autocomplete, and inspect results without launching a heavy desktop GUI.

It supports a wide range of engines, including PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, DuckDB, Snowflake, BigQuery and Trino. Connections can go through SSH tunnels, passwords are kept in the OS keyring, and running database containers can be discovered through Docker. Missing Python drivers are installed on demand.

Beyond the interactive interface, a CLI mode executes SQL from the command line and outputs CSV or JSON, which makes it usable in scripts.

Key features

  • 01Connection manager for saving and switching between databases
  • 02Syntax highlighting, query history and autocomplete in the editor
  • 03Vim-style modal editing and motions in the query editor
  • 04Browse tables, views, procedures, indexes, triggers and sequences
  • 05Fuzzy filter over query results
  • 06SSH tunnel support with password or key authentication
  • 07Command-line mode with CSV and JSON output

Use cases

  • Quickly querying a PostgreSQL or MySQL database over SSH from a remote server
  • Inspecting a local SQLite or DuckDB file without installing a desktop client
  • Running SQL scripts from the shell and exporting results as JSON or CSV
  • Exploring databases running in local Docker containers

Topics

#sql#tui#terminal#database-client#python#postgresql#mysql#sqlite#cockroachdb#command-line-tool

FAQ

What is sqlit?
A keyboard-driven terminal UI (TUI) for connecting to and querying many SQL databases, inspired by lazygit. sqlit is a terminal user interface for SQL databases, written in Python and built on Textual. It lets you save connections, browse tables, views and other schema objects, write queries with syntax highlighting and autocomplete, and inspect results without launching a heavy desktop GUI.
Is sqlit free to use? What license does it have?
sqlit is open source under the MIT license. Check the license terms before using it in commercial products.
Is sqlit still maintained?
Actively maintained. The last commit to sqlit was on Sep 28, 2026.
What can I use sqlit for?
Quickly querying a PostgreSQL or MySQL database over SSH from a remote server Inspecting a local SQLite or DuckDB file without installing a desktop client Running SQL scripts from the shell and exporting results as JSON or CSV Exploring databases running in local Docker containers
Where can I get sqlit?
The source code and installation instructions are on GitHub: https://github.com/Maxteabag/sqlit

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects