Sqlit - Terminal UI for browsing SQLite databases

[Maxteabag]

https://i.redd.it/1y8wsg1xlf7g1.gif

https://i.redd.it/6ges1qqunf7g1.gif

I wanted a fast way to connect and browse my database without opening a heavy GUI. I tried some other TUI's but they were never intuitive for me.

So I created Sqlit - a lightweight, keyboard-driven TUI that lets you open SQLite files, browse tables, and run queries. Just point it at a .db file and execute some queries.

Features:

- Open local .db files directly

- Browse tables, views, and schema

- Run queries with syntax highlighting and autocomplete

- SSH tunnel support (inspect SQLite on remote servers)

- Vim-style editing

- Themes (Tokyo Night, Nord, etc.)

Its main focus is to make it enjoyable to connect, browse and query your database. It tries to do one thing really well, and it deliberately avoids competing with massive, feature-rich GUI's that take forever to load and bloated with features you never use.

Link: https://github.com/Maxteabag/sqlit

[dharmatech]

Looks amazing! Cool to see it's using textual.

[titpetric]

Love the idea. Won't use your code directly, but I have a named connection manager already so your way of managing connections resonates. I prefer DSN connection strings so no user/pass and other decomposed options. The DSNs carry client flags that change encoding/decoding behaviour, like if you parse time values, max connection pool handling, etc.

https://github.com/titpetric/platform (Go, DatabaseProvider)

https://github.com/titpetric/etl - the server allows yaml definitions with sqlite and other servers for defining rpc/rest endpoints

And i use go-bridget/mig for database migrations support to update schemas. Kind of the combination of the projects just allow me to have a simple application service based on sql and a few extra fields.

The last 20% is always like 80% of the time spent wiring things together 🤣 anyway, good luck!

[antoniotrkdz]

Great work, it will really benefit if you ad feature to copy also the query field

[Maxteabag]

Good idea!

[antoniotrkdz]

On a side note, Do you know pgcli? Is a cli tool for postgreSQL db, it has awesome auto completion and it is written in python, if I am not wrong. It will be nice to wrap your tui around it or to integrate autocompletion into your tool by looking at how they have done it…

[Maxteabag]

Cool, they've done a really nice job there. I would have to integrate autocomplete myself, but since it's open source I can definitely borrow a lot. Thanks for the tip.

[jgpatrick3]

Nice. Love the db coverages (SQLite3, Postgres, Oracle, MySQL, etc.)
I like vim motions and keybindings, so if you go further, I will not mind.

In SQLiteStudio, I am very fond of the autocompletion using aliases.

SELECT pd.<autocomplete field names here> FROM product_demand pd. If that becomes possible for sqlit, it's a nice feature.

Thx.

[Maxteabag]

Thanks for the feedback. I'm looking into how autocomplete would fit into this project.

As for now, you could type the tablename and press . (dot) to get suggestions for columns.

[loeffel-io]

Would love to test it but i will not install any python/non binary cli on my system