🤠 Rowdy

A fast, modern, and rowdy Terminal User Interface (TUI) database management tool written in Rust.

Rowdy is designed for developers, DBAs, and terminal enthusiasts who want to inspect, query, and manage their databases without ever leaving their terminal or touching a mouse. Built on ratatui and sqlx, it compiles into a single standalone binary with no runtime dependencies.

✨ Features

🚀 Quick Start

Build from source

git clone https://github.com/TSODev/rowdy.git
cd rowdy
cargo build --release
./target/release/rowdy-db

Install from crates.io

cargo install rowdy-db

⚙️ Configuration

Create ~/.config/rowdy/config.toml to save connection profiles:

[[connections]]
name = "Local Postgres"
type = "postgres"
url = "postgres://user:password@localhost:5432/my_db"

[[connections]]
name = "Dev SQLite"
type = "sqlite"
url = "sqlite:///home/user/dev.db"

[[connections]]
name = "Turso Cloud"
type = "libsql"
url = "libsql://your-db-org.turso.io?authToken=eyJ..."

[[connections]]
name = "Cache Redis"
type = "redis"
url = "redis://127.0.0.1:6379"

[[connections]]
name = "MySQL Local"
type = "mysql"
url = "mysql://root:password@localhost:3306/my_db"

Profiles appear in the left panel of the connection screen at startup.

You can also add optional pre-connect and post-disconnect shell scripts per profile (useful for SSH tunnels, VPN, etc.):

[[connections]]
name = "VPS Postgres (SSH tunnel)"
type = "postgres"
url = "postgres://user:password@localhost:5432/mydb"
pre_connect = "ssh -f -N -L 5432:localhost:5432 user@remote-host"
post_disconnect = "pkill -f 'ssh -L 5432:localhost:5432'"

The pre_connect script runs before the database connection is established; post_disconnect runs when you disconnect or quit the app.

To connect in read-only mode (blocks all writes — safe for production), append ?readonly=true to any URL:

[[connections]]
name = "Production (read-only)"
type = "postgres"
url = "postgres://user:pass@prod-host/mydb?sslmode=require&readonly=true"

A red READ-ONLY badge appears in the status bar. Enter (edit record) and all DML statements in the SQL editor are disabled. Filters, pagination, and export still work normally.

⌨️ Keyboard shortcuts

Connection screen

Table list

Data Grid

Edit Record

MongoDB nested editor — when drilling into [obj] or [arr] fields, the title shows the breadcrumb (collection › field › subfield). Press Esc at any nested level to confirm that level's edits and return to the parent. Ctrl+S is only available at the root level.

Array editor — additional keys when editing an array field:

ERD graph view (r)

The ERD view displays a star layout: the selected table in the center (yellow box), tables with incoming FK on the left (cyan), and tables referenced by outgoing FK on the right (cyan). Arrows are routed from the exact FK column line. No additional queries are made — the schema is reused from the panel loaded on connect.

SQL Editor

SELECT, WITH, EXPLAIN, SHOW, PRAGMA → returns rows.
INSERT, UPDATE, DELETE, CREATE, … → shows rows affected.

Ctrl-C quits from anywhere.

🗄️ Supported databases

MongoDB requires building with the optional feature flag:

cargo build --release --features mongodb
cargo install rowdy-db --features mongodb

📖 Full documentation

See USAGE.md for the complete user guide including connection URL formats, all keyboard shortcuts, and feature details.

🔨 Development

cargo run      # run in dev mode
cargo build    # debug build
cargo test     # run tests
cargo clippy   # lint

📜 License

Licensed under either of MIT or Apache 2.0 at your option.