A cross-platform TUI database management tool.
Lazysql is a cross-platform TUI (Text User Interface) database management tool written in Go, heavily inspired by the popular Git client Lazygit. It provides a terminal-based interface for managing multiple database connections and performing SQL operations without leaving the command line. The tool supports major database systems including MySQL, PostgreSQL, SQLite, and MSSQL, making it versatile for various development environments.
Key features include Vim keybindings for efficient navigation, multiple connection management, tabbed interface, and a built-in SQL editor with syntax highlighting. Users can easily browse database schemas, execute queries, filter and sort data, insert and edit rows, and export results to CSV format. The tool also supports advanced features like read-only mode for production databases, custom commands for connecting through SSH tunnels or bastions, and environment variable integration for secure credential management.
Lazysql is ideal for developers, database administrators, and anyone who prefers working in the terminal environment. It's particularly useful for full-stack developers who need quick database access during development, DevOps engineers managing multiple database environments, and teams working with remote or containerized databases that require SSH tunneling or port forwarding.
# via Homebrew
brew install lazysql
# via Go install
go install github.com/jorgerojas26/lazysql@latest
# via Arch Linux (AUR)
paru -S lazysql