dblab

dblab is a terminal-based interactive database client that provides a unified interface for connecting to and managing multiple database systems including PostgreSQL, MySQL, SQLite3, Oracle, and SQL Server. Built in Go, it compiles to zero-dependency binaries that run across Linux, macOS, and Windows platforms.

The tool supports various connection methods including direct connections, SSH tunnels, and Unix sockets. Users can connect via command-line flags, connection URLs, or configuration files. dblab includes SSL support for PostgreSQL with certificate-based authentication, and handles SSH tunnel connections using either passwords or private key files.

The application features a terminal UI that allows users to browse database schemas, execute queries, and view results interactively. It supports query result limiting, schema selection for PostgreSQL and Oracle databases, and configuration through YAML files to avoid repetitive flag entry. The tool targets database administrators, developers, and DevOps engineers who need a lightweight, portable database client that works consistently across different database systems and platforms.

Installation

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

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