SQL Terminal Tools
Structured Query Language (or SQL) is integral for managing databases and is also commonly used in terminal environments, offering direct, powerful data manipulation.
These terminal-based SQL tools provide streamlined database interaction, aiding in querying, updating, or structuring data efficiently.
Below are a list of terminal tools that work with SQL.
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.
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.
mycli
A rich MySQL terminal client with autocompletion, syntax highlighting, and dataframes.
A rich MySQL terminal client with autocompletion, syntax highlighting, and dataframes.
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.
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.
sqlmux
A tmux-style terminal database client for SQL and NoSQL databases.
A tmux-style terminal database client for SQL and NoSQL 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.
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.
zsv
A SIMD accelerated CLI for querying and exploring CSV data.
A SIMD accelerated CLI for querying and exploring CSV data.
Know any terminal tools that would be good for this list? Submit a Tool here!
