quarry — Claude Code MCP server: what it does, how to install
quarry is a Claude Code MCP server that connects assistants to databases with safe access limits. It runs queries read-only by default and blocks modifications without explicit authorization.
MIT ★ 5 updated 2026-11-13
claude mcp add quarry -- uvx quarry-dbWhat quarry does
The server interfaces agents with PostgreSQL, MySQL, SQLite, Redis, and experimental Neptune via a Rust core. When querying SQLite, it opens existing database files directly and avoids generating empty files if the provided path is incorrect.
Operations remain read-only out of the box. Changing data through MCP requires explicit permissions on both the server configuration and the individual query payload. Running tunnels relies on system ssh, PostgreSQL schema extraction requires psql and pg_dump, and running local helper containers expects Docker.
What it helps with
- query PostgreSQL, MySQL, SQLite, and Redis databases
- prevent accidental data modifications during assistant runs
- route database traffic through system SSH tunnels
- synchronize PostgreSQL schemas using external tools
Example prompts for the agent
- Fetch the latest records from the orders table in the shop database
- Connect to the SQLite database at
data/app.dband display its schema - Inspect active cached sessions stored in Redis
How to install quarry
Platform CLI
claude mcp add quarry -- uvx quarry-dbuvx runs the command named after the package; if the README names another one, use uvx --from quarry-db <command>
Platform CLI
codex mcp add quarry -- uvx quarry-dbuvx runs the command named after the package; if the README names another one, use uvx --from quarry-db <command>
Config file
{
"mcpServers": {
"quarry": {
"command": "uvx",
"args": [
"quarry-db"
]
}
}
}uvx runs the command named after the package; if the README names another one, use uvx --from quarry-db <command>
Config file
{
"servers": {
"quarry": {
"type": "stdio",
"command": "uvx",
"args": [
"quarry-db"
]
}
}
}uvx runs the command named after the package; if the README names another one, use uvx --from quarry-db <command>
Platform CLI
gemini mcp add quarry uvx quarry-dbuvx runs the command named after the package; if the README names another one, use uvx --from quarry-db <command>
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about quarry
How to install quarry in Claude Code?
Run claude mcp add quarry -- uvx quarry-db in your terminal.
What does quarry do?
It allows AI agents to inspect databases including Postgres, MySQL, SQLite, and Redis under read-only constraints.
What dependencies does quarry require?
It runs via uvx. Using SSH tunnels requires system ssh, syncing Postgres schemas needs psql and pg_dump, and local service features need Docker.