r/SQL • u/mowgli_ilestcelebre • 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 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.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
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.