Sqlit – A lazygit-style TUI for SQL databases
It supports all the major databases: SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, FirebirdSQL, Oracle, DuckDB, CockroachDB, ClickHouse, Snowflake, Databricks, Supabase, Cloudflare D1, Turso, Athena, BigQuery, Spanner, Redshift, IBM Db2, SAP HANA, Teradata, Trino, Presto, Apache Flight SQL, Apache Impala, SurrealDB, and osquery.
A few things that come built in:
- Keyboard focus: Context aware keybindings always visible
- Docker integration: auto-detects and connect to running database containers
- Vim-style query editor with customizable keybindings.
- Fuzzy filter in results window.
- SSH tunnels, OS-keyring credential storage, password manager integration.
- Autocomplete for tables, columns, and procedures.
- Cloud CLI integration (browse external DBs via Azure / AWS / GCP CLIs).
- Themes (Rose Pine, Tokyo Night, Nord, Gruvbox).
Install: `pipx install sqlit-tui` (also works with `uv tool install` and `pip`).
Built with Python and Textual. First shared here in December (https://news.ycombinator.com/item?id=46276002) - a lot has shipped since.
Repo: https://github.com/Maxteabag/sqlit
Feedback welcome, especially on what's still missing for daily-driver use.
My goal is to make an aesthetic tool that makes it easy and enjoyable to connect and query data, and do that one thing only, really well.