MotherDuck MCP server

by MotherDuck

Query and explore MotherDuck and DuckDB data with SQL.

One-click authData & analytics

What it can do

  • Run SQL queries
  • List databases
  • Explore schemas
  • Create Dives

Through MCP1, every tool call is checked against your groups and rules, and recorded in the audit log.

How it connects

Authenticate with MotherDuck and approve MCP1. No token to copy; MCP1 keeps the connection sealed and refreshes it.

Endpoint
https://api.motherduck.com/mcp
Transport
Streamable HTTP

With MCP1

MotherDuck for the whole team, behind one URL

  1. 01

    Install it once

    An admin adds MotherDuck from the MCP1 catalog. Its authentication or token stays sealed in MCP1, never on a laptop.

  2. 02

    Decide who gets what

    Open it to groups, fully or read-only, and set rules per tool. Destructive tools can need an admin.

  3. 03

    Connect any client

    Claude, Cursor, ChatGPT, Codex and the rest connect one gateway URL and sign in with their own account.

More for data & analytics

See all data & analytics servers
  • SupabaseEngineering

    Manage Postgres projects, run SQL, migrations and edge functions.

    One-click auth
  • NeonEngineering

    Serverless Postgres: projects, branches, queries and migrations.

    One-click auth
  • Create and manage Prisma Postgres databases and backups.

    One-click auth
  • AppwriteEngineering

    Manage Appwrite projects, databases, auth, storage and sites.

    One-click auth
  • UpstashEngineering

    Upstash Redis, QStash, Vector and Workflow resources.

    One-click auth
  • AxiomEngineering

    Query Axiom datasets with APL, plus dashboards and monitors.

    One-click auth