pickfit

BrowseDeveloper CLIs

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.0 zip: 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.17 Peer 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

Linux x86_64

You need first

  • System packages: Oracle Instant Client, DuckDB optional C API runtime
  1. 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.sh
  2. install 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 --version

The 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')))
PY
lazydb 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 documents
    How to use it
    1. Add a connection with lazydb connections add --name <name> --url 'sqlite:///<file>' --json.
    2. Query it with lazydb agent query --connection <name> --sql '<your SQL>'.
    Tested
  • Write SQL with Vim-style editing and completion
    Not shown working
  • Use it with Neovim, coding agents and MCP
    Not shown working

How far pickfit got

Linux x86_64

  1. Installs
  2. Starts
  3. 1 of 3 features work
  4. 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

How to read a tool card

Stitching
pickfit installed this tool itself. Everything under the stitches comes from that run. A tool pickfit has not run never gets stitches.
Verified on your OS
The install steps ran on the system you chose. “Ran on Linux only” means it has not been run on yours yet.
macOS, Linux and WindowsWhere it ran
Green OS marks: pickfit ran the install steps there. Grey ones: the README says it runs there, and pickfit has not tried.
How far the run got
Installs and starts, its main function works, its service answers, it produces model output. A window means a desktop app opened; a plug, an MCP client used it. The mark sits beside the run’s result, under “Why it fits and how we know” and in “How pickfit tested it”.
Visual check
pickfit looked at screenshots of the app. Green: it looks right. Amber with a number: things that look wrong; open it to see them. Grey and dashed: not checked yet.
Known vulnerabilities
Known high or critical vulnerabilities (OSV.dev) in what it installs. Green: none known. Red with a number: how many; open it for the list, and read it before you install. Grey and dashed: not checked, which does not mean safe.
About the run
The day it ran, and the version that ran.
Source of a reason
Every reason a pick fits rests on one profile field. Open the reason to see the field and the value it relies on.
Hidden gem
High quality, little known.
Quality and popularity
Two scores out of 100. Quality: how well it installed and worked when pickfit tried it, and how good its install docs and upkeep are. Popularity: from stars, downloads and Hacker News.
Features checked
Of the main features the README advertises, how many the run actually exercised (green), and how many failed (red). Grey ones were not checked, and the card says why.
Not verified
A well-known tool Fitz mentions from general knowledge. No run record, no steps, no score.