MCP Atlas
github
Atlas/Browse/Databases/DuckDB
Databases

DuckDB

mcp-duckdb·by ktanaka101·v0.2.0

Run analytical SQL against local Parquet, CSV, and Arrow datasets via DuckDB.

ProvenanceWhere Atlas found this server. Each entry links back to the original listing.
officialregistry.modelcontextprotocol.io/postgresIndexed 28 Apr · Listed as reference serversmitherysmithery.ai/server/postgresIndexed 28 Apr · 47 installs · last weekglamaglama.ai/mcp/servers/postgresIndexed 27 Apr · Verified by maintainerpulsemcppulsemcp.com/servers/postgresIndexed 27 Apr · Listed under Databasescommunity—— · Not found in this source

§ Install

Add to Claude Desktop

Edit your claude_desktop_config.json and add the following entry under mcpServers:

"duckdb": {
  "command": "npx",
  "args": [
    "-y",
    "mcp-duckdb",
    "postgresql://localhost/mydb"
  ]
}
Cline / Continue config →Docker setup →Environment variables →

§ Tools exposed

What this server gives your model

query()Run a read-only SQL SELECT against the configured database. Parameterized values supported.
list_tables()Return all user tables across the database, with schema and row count estimates.
describe_table()Return columns, types, defaults, and indexes for a given table.
list_schemas()Return all schemas the configured user can read.

§ Compatibility

Works with

Claude DesktopVerified
ClineVerified
ContinueReported working
CursorVerified
ZedReported working
Custom clientstdio compatible

§ Security notes

What this server can do

Reads from your databaseThe configured user's read permissions apply. Use a dedicated read-only role.
Returns query results to your modelSensitive rows in returned data become part of the model context.
No write or DDL operationsINSERT, UPDATE, DELETE, and schema changes are rejected.
Connection string contains credentialsAvoid committing config files. Prefer environment variables.