Show HN: Sqlit – A lazygit-style TUI for SQL databases (opens in new tab)

That's a really good point.

I am going to implement the option to leave the password blank, so you'll get prompted for a password on connection every time, so nothing will get stored.

In the next release I am going to use Keyring to store credentials on the operating system's credential store. Stay tuned :)

Agree, the ability to define an in-memory only connection seems super useful.

Thanks! Those are really good suggestions, the next release is going to have more vim keys :)

It looks like rainfrog has branched out from just postgres, but still doesn't cover the range that sqlit does.

> These commands worked for me, to get Postgresql and MariaDB database plugins:

I haven't tried this, but I'm familiar with pipx. It provides a higher-level interface, so something like this should work:

  pipx install sqlit-tui
  sudo apt-get install -y libmariadb-dev
  pipx inject sqlit-tui psycopg2 mariadb

Ref.: https://pipx.pypa.io/stable/#inject-a-package

> I don't know if that would have worked just as well with pipx or not.

I don't actually see anything in the GitHub instructions about system-wide installation? But yes, since version 1.5 (https://pipx.pypa.io/stable/changelog/#150-2024-03-29) Pipx can do a `--global` install that by default puts the managed venv in /opt and executable symlink in /usr/local/bin.

Great UX feedback, that's going to be sorted out in the next release.

Also the pipx comment made me decide to put much more thought into how sqlit helps with package installation on runtime, and I'm going to suggest pipx by default and it's also going to give the correct commands for every popular package manager.

Thanks!

Using uv you can do

uvx --with psycopg2-binary --from sqlit-tui sqlit

That's not the same package. You should try sqlit-tui

Admins don’t ever close the tool, it’s always open on some RDP. Devs have different usage patterns.

SSMS is super duper nice if you’re an admin or a power SQL server user/dev. Nothing I’ve seen in Postgres world is comparable.

That's a great suggestion, thanks! I'll be updating the CLI in the next release.

It will be added in the next release :)

You need to install psycopg2, or perhaps more likely psycopg2-binary to access postgres databases. After hiichbindermax and mrbump helped me out upthread, I was able to get it working via:

    uvx --from sqlit-tui --with psycopg2-binary sqlit

If you're not using uv, then you'll need to install psycopg2-binary in whatever environment you're using (probably via `pip install psycopg2-binary`).

Thanks! I'm glad you liked it.

I asked the same thing on Discord where he also showcased it. He answered the question with this.

> I wanted to make something that makes intuitive sense to me, and I wanted to make a sql version of what lazygit does, namely you can just jump in and there's no need for external documentation. To navigate the harlequin with keyboard only you have to learn the keybindings. Also I though it was quite hard to connect to databases via the cli and install adapters (again, documentation necessary). I wanted to have a tool that you can just run and its intuitive. There's definitely more features in harlequin and I went with more lightweight, though sqlit has SSH tunnels, which harlequin lacks.

When I linked lazysql[0], he replied with this

> That was my original inspiration. Same problem with harlequin, I didn't feel like it was intutive and to follow the "lazy" mindset of lazydocker and lazygit, it should just be easy and not require looking up keybindings. Lazysql ended up with too many features for my taste to the point it was difficult to use

[0]: https://github.com/jorgerojas26/lazysql

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.

I know that licecap(https://www.cockos.com/licecap/) can be used to accomplish that.

Not sure if this is what is being used here though.

asciinema should do the job. It has GIF generation support via its 'agg' tool: https://docs.asciinema.org/manual/agg/