←back to thread

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

(github.com)
190 points MaxTeabag | 3 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

Show context
oulipo2 ◴[16 Dec 25 23:31 UTC] No.46296205[source]▶
What would be the main differences with Harlequin?
replies(2): >>46299354 #>>46299611 #
jbstack ◴[17 Dec 25 08:42 UTC] No.46299611[source]▶
I've recently been trying to find a good SQL TUI client, and one of the ones I tried was Harlequin. The main disadvantage, which every other SQL TUI I tried also suffers from, is that they don't comprehensively show every type of database object in the browser pane (e.g. tables, views, indexes, procedures). For example Harlequin only shows tables. This means that when you want to view one of the missing ones, you have to run a query. This means that you have to already know that the object you are looking for exists: there's no way to get a good overview of what you have in the database just by glancing at the browser. For me this sort of defeats the point of having a TUI in the first place.

It seems like the OP's offering has the same problem, although it does offer more objects than Harlequin. I'll be bookmarking it to see how it develops.

replies(1): >>46304759 #
1. MaxTeabag ◴[17 Dec 25 20:02 UTC] No.46304759[source]▶
Appreciate that take!

I'm looking into indexes/triggers/sequences. That will be added in a near-future release, I hope you can benefit from it once I release it :)

replies(1): >>46310836 #
2. jbstack ◴[18 Dec 25 10:05 UTC] No.46310836[source]▶
Great. If you added those this would probably become my go-to SQL client.
replies(1): >>46335978 #
3. MaxTeabag ◴[20 Dec 25 13:18 UTC] No.46335978[source]▶
Hi,

I've added this now: https://github.com/Maxteabag/sqlit/releases/tag/v1.1

Thank you for the suggestion.