Official AntV MCP server that turns a description of your data into a rendered chart — 26 visualization types from bar and line to sankey, mind-map, fishbone and geographic maps.
MotherDuck / DuckDBMCP Server
Summary
Run DuckDB analytics locally or in MotherDuck's cloud — query files and warehouses with the same SQL.
Features
- Analytical SQL over local DuckDB files or MotherDuck cloud
- Query Parquet, CSV, and JSON directly without loading
- Read-only mode for safe exploration
Installation
Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.
Description
The MotherDuck MCP server gives an assistant a full analytical SQL engine, working against local DuckDB databases, MotherDuck's cloud warehouse, or files on disk and in object storage.
What makes DuckDB a good fit here
You can query a Parquet, CSV, or JSON file directly — no import step, no schema definition. That means an assistant can answer questions about a data file the moment it exists, which removes most of the friction from ad-hoc analysis.
Capabilities
- SQL execution with DuckDB's full analytical feature set — window functions, CTEs, complex joins
- File querying across local paths and S3 and other object stores
- MotherDuck cloud for shared, persistent warehouses
- Hybrid execution, combining local files with cloud tables in one query
- Read-only mode for exploration you do not want writing anything
Setup
uvx mcp-server-motherduck --db-path md: for the cloud service with a MotherDuck token, or a local file path for pure DuckDB use.
Related MCP Servers
Turso's hosted MCP server — manage Turso Cloud databases, branch them point-in-time and run SQL from a coding agent, authorised over OAuth with no API token to paste.
Google's official Firebase MCP server — 70+ tools across Firestore, Auth, Crashlytics, Cloud Functions, Storage, Messaging and Remote Config, shipped inside the Firebase CLI.
InfluxData's official MCP server for InfluxDB 3 — schema discovery, bounded SQL and InfluxQL queries, line-protocol writes and token administration across Core, Enterprise and Cloud.
