Quarry 2

A native database workbench: one reusable Rust kernel, CLI, browser GUI and MCP. PostgreSQL, MySQL, SQLite, Redis and experimental Neptune; explicit query/write policies, SSH tunnels, saved queries, local Docker services and a SQL assistant.

Install

Version 2.0 is the native Rust stable release.

curl -fsSL https://yiminspace.github.io/quarry/install.sh | sh
qy --version
qy gui

Or download a native archive and SHA256SUMS from GitHub Releases. The native executable needs neither Python nor a Rust toolchain. Supported: macOS/Linux arm64/x86_64; Linux glibc 2.28+. See install and upgrade.

Or use pip (the same native executable):

pip install --upgrade --only-binary=:all: quarry-db==2.0.0

Related MCP server: sqlite-mcp

Use

qy --workspace /path/to/workspace connections
qy --workspace /path/to/workspace exec shop --env dev --sql 'SELECT 1'
qy --workspace /path/to/workspace mcp

Workspaces contain connections.toml and reusable SQL query files. Actual credentials remain local. GUI queries stay read-only; CLI writes require --write and production confirmation. MCP writes require both server and request authorization. SQLite opens existing files; it never invents a database when a connection path is wrong. Assistant proposals never execute themselves.

Ordinary queries use native database drivers. SSH needs system ssh; Local services need Docker, and PostgreSQL schema sync needs pg_dump/psql.

Rust and Python

Rust owns main and all 2.x distribution. quarry-core, quarry-runtime, quarry-local, quarry-assistant and quarry-service can be embedded directly in host applications. Architecture.

For a hosted workbench, the official Docker image serves the GUI, authentication, read-only API and execution from one configuration file. Use a built-in administrator or configure an existing platform's IAM; YiminLab consumes the same image. ylab automatically connects and saves personal records to computer SQLite. Standalone qy needs neither the hosted service nor platform sign-in. See the hosting guide for deployment, access grants and offline behavior. The Rust SDK remains available for advanced embedding.

Python 1.11.0 is preserved at its tag and the protected archive/python-1.x branch. Python import APIs do not ship in 2.x. The Python source retained in this checkout is a development/test baseline, not a runtime dependency or published Python implementation. Existing configuration, saved queries and histories are read by Rust. See upgrade instructions before changing installer ownership.

Build and verify

cd web && npm ci && npm run build && cd ..
cargo build --release --locked -p quarry-cli
cargo test --workspace --all-targets --locked

GUI feature matrix · Compatibility · Verification boundaries · 中文