LazyDB
Keyboard-first terminal workspace to browse databases and write SQL with MCP support.
Tested on LinuxKnown vulnerabilities
Use it
Before you install: known vulnerabilities
pickfit found 8 known high or critical vulnerabilities in the packages a fresh install brings (OSV.dev, 3 Nov 2026). Weigh this before you install it.
crates:zip 6.0.0zip: Critical Parser Differential & Security Control Bypass via Dual-Header Inconsistencies (Zip Cloaking) Leading to Arbitrary File Overwrite & RCE (GHSA-m665-v7pm-7grj, critical, fixed in 9.0.5)crates:quinn-proto 0.11.17Peer minimum ACK delay can panic quinn-proto when ACK_FREQUENCY transmission is enabled (RUSTSEC-2026-0340, high, fixed in 0.11.18)
See 6 more
crates:zip 6.0.0— RUSTSEC-2026-0369 (critical), fixed in 9.0.0crates:quinn-proto 0.11.17— RUSTSEC-2026-0343 (high), fixed in 0.11.18crates:rustls-webpki 0.101.7— GHSA-82j2-j2ch-gfr8 (high), fixed in 0.103.13crates:zip 6.0.0— GHSA-9hj8-73fh-9963 (high), fixed in 9.0.0crates:zip 6.0.0— GHSA-q7v9-x93c-xqv3 (high), fixed in 9.0.0crates:zip 6.0.0— RUSTSEC-2026-0367 (high), fixed in 9.0.0
Linux x86_64
You need first
- System packages:
Oracle Instant Client,DuckDB optional C API runtime
download install script
curl -fsSL https://lazydb.yelog.org/install.sh -o /tmp/lazydb-install.sh && wc -c /tmp/lazydb-install.sh && head -c 2000 /tmp/lazydb-install.shinstall lazydb via script
sh /tmp/lazydb-install.sh --mcp-setup skip
Where the README and reality differ
- README: lazydb connections add --help lists options without --url
What worked: connections add requires --url e.g. sqlite:///tmp/lazydb-test.db though --help text does not list --url
Check that it works
lazydb --versionThe output should contain “lazydb 0.2.3”.
First thing to try
python3 - <<'PY'
import sqlite3
c=sqlite3.connect('/tmp/lazydb-test.db')
c.execute('DROP TABLE IF EXISTS users')
c.execute('CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT)')
c.execute("INSERT INTO users(id,name) VALUES (1,'alice'),(2,'bob')")
c.commit()
print(list(c.execute('SELECT * FROM users')))
PYlazydb connections add --name demo --url 'sqlite:///tmp/lazydb-test.db' --json && lazydb agent query --connection demo --sql 'SELECT * FROM users ORDER BY id'Run lazydb in a terminal to open the workspace.
What it does
- Browse schemas, table data and documentsTested
How to use it
- Add a connection with
lazydb connections add --name <name> --url 'sqlite:///<file>' --json. - Query it with
lazydb agent query --connection <name> --sql '<your SQL>'.
- Add a connection with
- Write SQL with Vim-style editing and completionNot shown working
- Use it with Neovim, coding agents and MCPNot shown working
How far pickfit got
Linux x86_64
- Installs
- Starts
- 1 of 3 features work
- Works offline
macOS and Windows: the project says it runs there; pickfit hasn’t tried it.
Good for
- browse schemas, table data, and Redis keys
- inspect MongoDB documents
- write SQL with Vim-style editing and completion
- give coding agents database access via local MCP server
How pickfit tested it
Each run starts from a clean machine and follows the steps above. How pickfit verifies
Linux x86_64
Its main function works
- Replayed from scratch
- Works offline
- Checked on 30 Oct 2026
- Version 0.2.3
Differences the test machine hit
- README: curl -fsSL https://lazydb.yelog.org/install.sh | sh
In the test: download to /tmp/lazydb-install.sh, read it, then run sh /tmp/lazydb-install.sh --mcp-setup skip