Skip to content
DuckDB logo

DuckDB MCP server

Run SQL queries on an in-memory DuckDB database.

DuckDB is not a separate install. One Activepieces MCP server exposes it alongside 760+ other apps, behind a single URL.

Tools
1
Works with
Any MCP client
License
MIT, open source
Updated
September 2026

About the DuckDB MCP server

Connect DuckDB once in Activepieces and every action it ships becomes a tool your assistant can call, behind the same server URL as the rest of your apps. Your agent reaches DuckDB and 760+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

DuckDB tools your AI can run

Once connected, your assistant can call any of these DuckDB actions by asking in plain language.

  • Create and Query DB

    Create DB from data and run query

    4 fields

Give your assistant DuckDB

Connect DuckDB once and every tool above is callable from Claude, Cursor or any MCP client, behind the same server URL as 760+ other apps. Free to start.

DuckDB MCP, answered.

No. That is the point of it. One Activepieces server exposes DuckDB alongside every other piece you connect, so your client keeps a single connection.

Yes. Activepieces is open source and free to start, and the MCP server is included on every plan, from the free cloud tier to any self-hosted deployment.

Connect DuckDB in Activepieces, enable the server under Settings → MCP Server, then paste your server URL into your client config. It authenticates over OAuth on first use.

It can call 1 tool, including Create and Query DB, and chain them with steps in other apps inside the same run.

Connections use OAuth2 with limited scopes and are stored under 256-bit encryption, with no API to read them back, so an agent gets scoped access rather than your keys.