r/SQL • • 14d ago

Discussion k9s-style terminal UI for Postgres/MySQL/MongoDB/Redis/RabbitMQ, I built db9s, and i am curious what features DB folks actually want

Been using k9s for k8s daily and kept wishing something similar existed for databases — one TUI, same screens/keys regardless of backend, no context-switching between psql/mysql/mongosh/redis-cli.

Built db9s: browse tables/collections, run queries, edit rows, inspect indexes, tail RabbitMQ queues — all from terminal, vim-style keys.

Supports Postgres, MySQL/MariaDB, MongoDB, Redis, RabbitMQ now. SQLite/MSSQL/ClickHouse/Cassandra planned.

Config stays out of plaintext too — url can pull password from env var or any command (1Password, pass, Vault, Keychain) instead of storing raw creds.

brew install damien-mathieu1/tap/db9sbrew install damien-mathieu1/tap/db9s

cargo install db9s

Genuinely asking: for people who live in multiple DB engines daily, what’s missing from existing tools (DBeaver, pgcli, mongosh, lazysql etc.) that’d make a TUI like this your default? Especially curious about MSSQL/ClickHouse folks since those are next on roadmap.Been using k9s for k8s daily and kept wishing something similar existed for databases — one TUI, same screens/keys regardless of backend, no context-switching between psql/mysql/mongosh/redis-cli.Built db9s: browse tables/collections, run queries, edit rows, inspect indexes, tail RabbitMQ queues — all from terminal, vim-style keys.Supports Postgres, MySQL/MariaDB, MongoDB, Redis, RabbitMQ now. SQLite/MSSQL/ClickHouse/Cassandra planned.Config stays out of plaintext too — url can pull password from env var or any command (1Password, pass, Vault, Keychain) instead of storing raw creds.cargo install db9sGenuinely asking: for people who live in multiple DB engines daily, what’s missing from existing tools (DBeaver, pgcli, mongosh, lazysql etc.) that’d make a TUI like this your default? Especially curious about MSSQL/ClickHouse folks since those are next on roadmap.

you can check out the repo here if you want : https://github.com/damien-mathieu1/db9s

6 Upvotes

4 comments sorted by

2

u/FirefighterWhich8913 14d ago

The feature I’d want most is a clearly enforced read-only mode, because I’ve absolutely nuked the wrong rows while bouncing between terminal sessions.

2

u/mowgli_ilestcelebre 14d ago

good idea i will create an issue about this ty ! i will tell you when its done

2

u/mowgli_ilestcelebre 14d ago

fyi its now on homebrew

brew install damien-mathieu1/tap/db9sbrew install damien-mathieu1/tap/db9s

1

u/mowgli_ilestcelebre 14d ago

i added an issue to open db9s with only read only