dblab
An open-source terminal UI client for browsing and querying PostgreSQL, MySQL, SQLite and other databases.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
About dblab
dblab is a database client that runs in the terminal, pitched at people who prefer the command line to a graphical tool. It connects to PostgreSQL, MySQL, SQLite and other databases, lets you browse tables and run queries in a text-based interface, and can read connection settings from a .dblab.yaml configuration file.
The project is written in Go, has around 3,200 stars on GitHub, and ships documentation and screenshots in its repository.
Strengths
- Works entirely in the terminal
- Supports several major SQL databases
- Connection settings can be saved in a config file
Limitations
- Text interface is less discoverable than a graphical client
- Maintained by a small team
Details
- Pricing
- FreeFree and open source.
- License
- Open source, license not stated
- Developer
- Daniel Vergara
- Platforms
- Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Command-line users who want to browse a database without leaving the terminal
- Categories
- CLI tools, Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to dblab
Compare allSoftware that can replace dblab for an important use case, and what changes if you switch.
Harlequin
A SQL IDE that runs in the terminal, with adapters for DuckDB, SQLite, Postgres and more.
Harlequin is a full terminal SQL IDE installed through Python, with adapters for DuckDB, SQLite, Postgres and more, plus an hsql companion for scripts.
LazySQL
Browse and query databases through a terminal interface.
LazySQL is an MIT-licensed cross-platform terminal interface for browsing and querying databases, but the project describes itself as alpha software.
rainfrog
Query databases through a terminal editor with history and favorites.
rainfrog is an MIT-licensed terminal query editor that adds query history, favorites and table inspection, though its database drivers vary in support and stability.
usql
Use one command-line interface for many database systems.
usql gives one consistent command-line interface across many database engines, but as a shell rather than a browsing UI, and driver features vary by database.
pgcli
A command-line PostgreSQL client with auto-completion and syntax highlighting.
pgcli is a command-line client only for PostgreSQL, adding context-aware auto-completion and syntax highlighting while using standard libpq connection environment variables.
mycli
A command-line MySQL client with auto-completion, syntax highlighting and fuzzy history search.
mycli is a command-line client for MySQL, MariaDB, Percona, TiDB and Apache Doris with auto-completion and fzf history search, and it does not cover PostgreSQL or SQLite.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
LiteCLI is a command-line client limited to SQLite with auto-completion and syntax highlighting, installed through pip or Homebrew, and it has no graphical table browser.
Similar software
Related functionality, not necessarily a direct replacement.
sq
An open-source command-line tool to inspect, query, join, import and export data across databases and files.
VisiData
An interactive terminal multitool for exploring, cleaning and converting tabular data in many formats.
trdsql
Query structured files with SQL from the command line.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
