A modern, keyboard-first PostgreSQL and MongoDB CLI with a TUI interface.

If you like this crate show some support by following fcoury (me) on X

Join us on Discord

• Full-screen TUI - Split-pane interface with query editor and results grid
• Vim-style keybindings - Navigate and edit with familiar modal commands
• Syntax highlighting - SQL and JSON highlighting powered by tree-sitter
• Smart completion - Schema-aware autocomplete for tables, columns, and keywords
• Results grid - Scrollable, searchable data grid with column resizing, multi-row selection, and flexible yank (TSV/CSV/JSON/Markdown)
• Inline editing - Edit cells directly in the grid with automatic SQL generation
• JSON support - Detect, format, and edit JSON/JSONB columns with syntax highlighting
• Postgres + MongoDB - Connect with postgres://... or mongodb://... URLs
• Schema commands - psql-style commands plus Mongo helpers (:show dbs, :show collections, :describe)
• Query history - Persistent history with fuzzy search, pinning, and deletion
• External editor - Open the current query in $VISUAL / $EDITOR with vv
• 1Password integration - Store an op:// secret reference per connection instead of a plain password
• Update checks - Notify of new versions with install-method specific upgrade hints, plus optional in-app apply for standalone installs when updates.mode = "auto"
• Configurable - Customize keybindings and appearance via config file

brew tap fcoury/tap
brew install tsql

cargo install tsql

Download pre-built binaries from the GitHub Releases page.

# Connect with a connection URL
tsql postgres://user:password@localhost:5432/mydb
tsql mongodb://user:password@localhost:27017/mydb

# Or set DATABASE_URL environment variable
export DATABASE_URL=postgres://user:password@localhost:5432/mydb
tsql

# Or configure a default connection in ~/.tsql/config.toml
tsql

Once connected:

1. Type a SQL query in the editor pane
2. Press Enter to execute
3. Use Tab to switch between editor and results grid
4. Press ? for help with all keybindings (type / inside the help popup to filter)

Yank commands operate on all selected rows when a selection is active, or the cursor row otherwise.

If a key combo isn't working in your terminal, you can inspect what tsql is actually receiving:

tsql --debug-keys

To also print mouse events:

tsql --debug-keys --mouse

:update apply is only available in updates.mode = "auto" and only for standalone binary installs.

tsql looks for configuration at ~/.tsql/config.toml by default. On Linux/macOS startup, legacy config folders are auto-migrated to ~/.tsql.

[connection]
# Default connection URL (can be overridden by CLI arg or DATABASE_URL)
default_url = "postgres://localhost/mydb"
# Enable 1Password CLI support for `password_onepassword` refs
enable_onepassword = false

[updates]
# Update checks + optional in-app apply for standalone installs
enabled = true
check_on_startup = true
channel = "stable"
mode = "auto"
interval_hours = 24
allow_apply_for_standalone = true
github_repo = "fcoury/tsql"

[keymap]
# Custom keymap overrides (see config.example.toml for options)

See config.example.toml for all available options.

1Password support is currently gated behind connection.enable_onepassword = true in your config.

Connection entries support an optional 1Password ref field (op://vault/item/field). When enabled, tsql calls op read at connect time to resolve the password, inheriting your shell's PATH and active op session token. Configure it via the connection manager (Ctrl+Shift+C or gm).

Requires the 1Password CLI (op) to be installed and an active authenticated session (for example via op signin).

• PostgreSQL 12 or later, or MongoDB 6.0+
• Terminal with 256-color support recommended

Contributions are welcome! Please see CONTRIBUTING.md for guidelines.

This project is licensed under the MIT License - see the LICENSE file for details.