Favicon of lazysql

lazysql

Cross-platform TUI SQL client for SQLite, PostgreSQL, MySQL, and MSSQL. Execute queries, manage multiple connections, and explore databases with Vim-like keybindings—all without leaving the terminal.

lazysql is a terminal-based SQL client that brings database management directly to your command line. Built in Go, it provides a full-featured TUI interface for developers and database administrators who prefer working in the terminal.

Key capabilities include:

  • Multi-database support for SQLite, PostgreSQL, MySQL, and MSSQL
  • Multiple connections management with easy switching between databases
  • Tabbed interface for organizing your work across different queries and tables
  • Built-in SQL editor (Ctrl+E) for writing and executing queries with syntax support
  • Vim-like keybindings with customizable shortcuts for efficient navigation
  • Advanced filtering with WHERE clause support to quickly find specific rows
  • Data editing capabilities to insert, update, and modify records directly
  • CSV export functionality for sharing query results
  • Read-only mode option to protect production databases from accidental modifications
  • Configuration file support (TOML format) for saving connection profiles and application settings
  • Cross-platform compatibility on macOS, Windows, and Linux

The tool excels at rapid database exploration, making it ideal for testing, development, and quick data inspection. Features like JSON viewer integration, configurable page sizes, and sidebar customization adapt to your workflow. Whether you're a full-stack developer, database administrator, or student learning SQL, lazysql eliminates the need to switch between terminal and GUI database tools.

Install

Brew
$ brew install lazysql

Features

Config fileJSON outputRemote SSH supportScriptable

Media

Pros

4
  • Cross-platform TUI SQL client for multiple database types
  • Supports multiple connections and tabs
  • Vim-like keybindings for efficient navigation
  • SQL editor with syntax highlighting and query execution

Cons

1
  • Project is in ALPHA stage, may contain bugs

Related tools

Categories:

Share:

Auto-fetched .

Recent releases

Similar to lazysql

Favicon

 

  
 
Favicon

 

  
 
Favicon