←back to thread

Show HN: Sqlit – A lazygit-style TUI for SQL databases

(github.com)
190 points MaxTeabag | 2 comments | 15 Dec 25 15:47 UTC | HN request time: 0s | source

I work mostly in the terminal but found myself constantly switching to bloated GUIs like SSMS only for the simple task of browsing tables and run queries. And I didn't find Existing SQL TUIs intuitive, having to read documentation to learn keybindings and CLI flags to connect. Given I had recently switched to linux, I found myself using vs code's sql database extension. Something was awfully wrong.

I wanted something like lazygit for databases – run it, connect, and query and frankly just make it enjoyable to access data.

  Sqlit is a keyboard-driven SQL TUI with:

  - Context-based keybindings (always visible)
  - Neovim-like interface with normal and insert mode for query editing
  - Browse databases, tables, views, stored procedures
  - Adapters for SQL Server, SQLite, PostgreSQL, Turso & more
  - SSH tunneling support
  - Themes (Tokyo Night, Nord, Gruvbox etc.)

  Inspired by lazygit, neovim and lazysql. Built with Python/Textual.
Feedback welcome – especially on which adapters to prioritize next. My vision of sqlit is to make a tool that makes it easy to connect and query data, and to do that, and that thing only, really well.

https://github.com/Maxteabag/sqlit

1. vinshoo ◴[17 Dec 25 12:10 UTC] No.46301072[source]▶
Looks great! It seems that sqlit still relies on arrow keys for getting around. Would it be possible to add options for more vim style on these places?

- Browse explorer tree with jk

- Next/Prev autocomplete suggestion with ^+j,^+k

- Browse Results with hjkl

Some other suggestions:

- Filter tables (f.e. press / and start typing to filter down tables)

- Ability to edit cell value

Otherwise it feels great, thanks for it :) UI looks much nicer than on lazysql and toggleable sidebar is great.

replies(1): >>46304498 #
2. MaxTeabag ◴[17 Dec 25 19:42 UTC] No.46304498[source]▶
Thanks! Those are really good suggestions, the next release is going to have more vim keys :)