dblab

dblab is a terminal-based interactive database client written in Go that supports PostgreSQL, MySQL, SQLite3, Oracle, and SQL Server. It provides a TUI interface for database operations and query execution across multiple database systems through a single binary application.

The tool features a Vim-style query editor with normal and insert modes, supporting line-oriented editing commands. It includes cross-platform support for macOS, Linux, and Windows, distributed as a zero-dependency binary. dblab supports both direct database connections and SSH tunneling for remote database access, with SSL connection options for PostgreSQL.

Connection methods include command-line flags for individual parameters or URL schemes for different database types. The tool supports Unix socket connections for MySQL/MariaDB and PostgreSQL, and includes configuration file support to avoid entering connection details repeatedly. Users can specify result set limits, database schemas, and various SSL parameters for secure connections.

Installation

# via Homebrew
brew install --cask danvergara/tools/dblab

# via Shell script
curl https://raw.githubusercontent.com/danvergara/dblab/master/scripts/install_update_linux.sh | bash