LazyDB

A keyboard-first database workspace for your terminal, built in Rust.

Quickstart · Databases · Documentation · Releases

More screenshots: table data, monitoring, mouse support, MCP, and Neovim

Table Data	Monitoring Dashboard
Mouse Support	MCP and Neovim
Neovim SQL Completion and Syntax Highlighting

• Explore databases — browse schemas, table data, Redis/Valkey keys, and MongoDB documents.
• Write SQL — use Vim-style editing, catalog-aware completion, and multiple consoles with query results and transaction controls where supported.
• Work in your tools — integrate with Neovim, coding agents, MCP, and a JSON CLI.
• Reach private databases — attach managed SSH tunnels with system OpenSSH, agent/key/config authentication, strict host checks, and ProxyJump.

LazyDB is in beta. Feature availability varies by database; see the capability reference and current limitations.

Quickstart

macOS / Linux

curl -fsSL https://lazydb.yelog.org/install.sh | sh

Windows (PowerShell, x86_64)

powershell.exe -NoProfile -ExecutionPolicy Bypass -Command "irm https://lazydb.yelog.org/install.ps1.txt -ErrorAction Stop | iex"

Homebrew (macOS)

brew install yelog/tap/lazydb

Follow the installer's shell instructions or open a new terminal, then start LazyDB:

lazydb

1. In Explorer, select No profiles and press Enter to create your first connection. Choose a driver, enter its connection details, then save and connect.
2. Open a table to inspect its data, or press F6 to open the SQL console manager.
3. Press F2 to search commands and objects. F1 opens help; the footer and help view show contextual controls for the active pane and mode.

Use Ctrl-c to quit from the workspace.

SQL consoles also work offline: write, format, and save SQL before connecting. See the Omni Bar guide and keyboard reference for navigation and execution controls. If icons render incorrectly, start with lazydb --icons unicode or lazydb --icons ascii.

For release channels, Linux requirements, manual downloads, source builds, updates, and removal, see the installation guide.

Supported Databases

Type	Databases
Server SQL	PostgreSQL, CockroachDB, MySQL, MariaDB, TiDB, Oracle, SQL Server, ClickHouse, Snowflake, Google BigQuery
Embedded SQL	SQLite, DuckDB
Key-value and document	Redis, Valkey, MongoDB
Search	Elasticsearch, OpenSearch

Oracle requires Oracle Instant Client. DuckDB requires an optional C API runtime that is not bundled; see runtime setup. Redis and Valkey use a key/value browser; MongoDB uses a document explorer and bounded JSON console. See the MongoDB guide for its scope. Snowflake uses the HTTPS SQL API with a stored access token; see the Snowflake guide for authentication and current limits. Google BigQuery uses refreshable ADC and GoogleSQL jobs with per-profile billing limits; see the BigQuery guide. Elasticsearch provides index and mapping discovery, document previews, and a native REST/JSON console; see the Elasticsearch guide. OpenSearch has its own driver with Basic/None authentication and shares the REST browser/console; see OpenSearch setup and verification limits.

Saved profiles for supported drivers can connect through a managed bastion tunnel without replacing the database host with a loopback port. This requires an OpenSSH client and non-interactive authentication; see SSH tunnels.

Browse the database capability matrix for server versions, editing, transactions, monitoring, and driver-specific limits.

Integrations

Coding Agents and MCP

Give Claude Code, Codex, or OpenCode access to the current project's database profiles through a local MCP server. From the target project, run:

lazydb mcp setup

The wizard offers user-level and project-level configuration. MCP database writes are denied by default; database grants remain the authorization boundary. See coding-agent access for setup, permissions, the JSON CLI, and troubleshooting.

Neovim and SQL Language Server

Use yelog/lazydb.nvim to run LazyDB in a floating terminal. The standalone language server provides SQL/MyBatis syntax diagnostics and completion, with catalog completion when a profile is available. See Neovim setup and the SQL language server.

Documentation

Task	Guide
Install, update, or uninstall	Installation
Configure connections, credentials, themes, or clipboard behavior	Configuration
Connect through a bastion or an existing SSH tunnel	SSH tunnels
Learn navigation and keyboard controls	Keyboard reference
Check database support and limitations	Database capabilities
Find database guides, integrations, and development docs	Documentation index

Contributing

Bug reports and focused pull requests are welcome. Read Contributing for local checks and development rules, and use the issue tracker to report problems. See the changelog for version-specific changes.

License

Licensed under MIT or Apache-2.0, at your option.