Database Terminal Tools
A database stores and organizes the data behind an application, whether that is a relational engine such as PostgreSQL or MySQL, a key value store such as Redis, or an embedded file such as SQLite.
Terminal clients connect to those engines to browse schemas, run SQL, edit rows and export results, all inside an SSH session with no desktop application involved. The category also holds TUI browsers for exploring an unfamiliar schema, migration runners, and query engines that treat a local CSV or JSON file as a table.
Below is a list of terminal tools that work with databases.
chdig
Dig into ClickHouse with TUI interface.
Dig into ClickHouse with TUI interface.
datui
Data Exploration in the Terminal.
Data Exploration in the Terminal.
dblab
The database client designed for command line specialists.
The database client designed for command line specialists.
ddv
A TUI to view Amazon DynamoDB in the terminal.
A TUI to view Amazon DynamoDB in the terminal.
dolphie
Realtime MySQL health monitoring in the terminal.
Realtime MySQL health monitoring in the terminal.
gobang
A cross platform TUI database management tool written in Rust
A cross platform TUI database management tool written in Rust
goose
A database migration tool written in Go.
A database migration tool written in Go.
harlequin
The SQL IDE for Your Terminal.
The SQL IDE for Your Terminal.
lazysql
A cross-platform TUI database management tool.
A cross-platform TUI database management tool.
memtui
A TUI to visualize and manage Memcached.
A TUI to visualize and manage Memcached.
octosql
A CLI tool which lets you query a plethora of databases.
A CLI tool which lets you query a plethora of databases.
pgcli
A postgres CLI with autocompletion and syntax highlighting.
A postgres CLI with autocompletion and syntax highlighting.
pspg
A UNIX pager optimized for tabular data.
A UNIX pager optimized for tabular data.
qo
An interactive minimalist TUI to query JSON, CSV, and TSV using SQL.
An interactive minimalist TUI to query JSON, CSV, and TSV using SQL.
rainfrog
A database management TUI for postgres.
A database management TUI for postgres.
sabiql
A fast, driverless, vim-first TUI for PostgreSQL, MySQL, and SQLite.
A fast, driverless, vim-first TUI for PostgreSQL, MySQL, and SQLite.
sq
The missing swiss-army knife tool for wrangling data.
The missing swiss-army knife tool for wrangling data.
sqlit
A user friendly TUI for SQL databases.
A user friendly TUI for SQL databases.
sqly
Easily execute SQL against CSV/TSV/LTSV/JSON and Excel with shell.
Easily execute SQL against CSV/TSV/LTSV/JSON and Excel with shell.
squall
A TUI SQLite viewer and editor.
A TUI SQLite viewer and editor.
squix
A minimal CLI tool for managing and executing SQL queries with a TUI.
A minimal CLI tool for managing and executing SQL queries with a TUI.
tabiew
A lightweight TUI application to view and query tabular data files.
A lightweight TUI application to view and query tabular data files.
termdbms
A terminal UI for editing database files
A terminal UI for editing database files
textql
Execute SQL against structured text like CSV or TSV
Execute SQL against structured text like CSV or TSV
tornado
A terminal SQLite explorer with Vim key-bindings.
A terminal SQLite explorer with Vim key-bindings.
tredis
A modern TUI for managing Redis servers.
A modern TUI for managing Redis servers.
vi-mongo
A TUI for managing MongoDB databases.
A TUI for managing MongoDB databases.
visidata
A terminal spreadsheet multitool for discovering and arranging data.
A terminal spreadsheet multitool for discovering and arranging data.
vi-sql
A terminal SQL client with Vim controls and schema tools.
A terminal SQL client with Vim controls and schema tools.
xql
An SQL REPL for SharePoint Lists and CSV files.
An SQL REPL for SharePoint Lists and CSV files.
Know any terminal tools that would be good for this list? Post a Tool here!
