3 ms·
Sqlit – A lazygit-style TUI for SQL databases
sqlit is a lazygit-style TUI for SQL. Connect and query your database from the terminal in seconds, no config files or documentation to read first.
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.
- deleted 6mo ago[deleted]
- etxrnl_dxs 6mo ago[dead]
- cesarmanzocode 6mo agoVery nice UX direction. One thing I’ve consistently missed in terminal DB tools is schema-aware query history/search across multiple databases. Feels like that would fit this aesthetic really well.
- MaxTeabag 6mo agoThanks. Yeah, it's actually already possible with a feature I call "telescope". Try it with <space> <space>. let me know what you think
- volume_tech 6mo ago[flagged]
- teejmya 6mo agoWhy is this in Ask HN? Shouldn't it be in Show HN?
- MaxTeabag 6mo agoDon't know. I'm a HN noob :)
- qsera 6mo agoLooks amazing. But before I can commit to trying it, I would like to know how much LLM involvement was there.