Best DuckDB MCP Servers
DuckDB is an in-process SQL OLAP database management system designed for analytical queries with a simple, embeddable architecture that supports various programming languages and platforms.
Why this server?
Allows the server to connect to DuckDB warehouses (including Iceberg on S3) for schema inference and semantic layer generation.
AlicenseBqualityBmaintenanceServes an automatically inferred semantic layer from your warehouse over MCP, enabling AI agents to query with correct business context, joins, and filters.2421439 PyPI4Functional Source , Version 1.1, ALv2 FutureWhy this server?
Enables dbprint to connect to and profile DuckDB databases, capturing table DDL, joins, and per-column statistics for offline agent context.
AlicenseAqualityBmaintenanceGives an AI agent a database's tables, columns, value lists, null shares and joins from a dbprint snapshot committed to your repo, with no database connection or credentials. Tools list and search tables and columns, render prompt-ready context for a table, resolve a filter value to its stored spelling, and report what changed since the last snapshot.47281 PyPI4Apache 2.0Why this server?
Integrates with local DuckDB to provide SQL analytics capabilities and allow querying data from local databases
AlicenseAqualityBmaintenanceAn MCP server for MotherDuck and local DuckDB.5540MITWhy this server?
Provides spatial SQL execution using DuckDB's dialect, including ST_* functions and file reading via read_parquet/ST_Read, enabling SQL-based geoprocessing and materialization of results as GeoParquet with provenance.

MapSmithofficial
AlicenseAqualityBmaintenanceEnables AI agents to perform professional-grade geoprocessing tasks such as buffers, overlays, reprojections, and terrain analysis with deterministic tools and verifiable provenance.29273 PyPI2AGPL 3.0Why this server?
Enables asking natural-language questions against DuckDB data, with FactQL running verified SQL queries and returning the query, result rows, and lineage.

factql-mcpofficial
AlicenseAqualityBmaintenanceFactQL is the harness around the model: ask a question about your data and it runs the query, checks the result before you see an answer, and declines instead of guessing when it can't verify. Every answer ships with the query that ran, the rows it returned and the lineage behind it.2MITWhy this server?
Allows running data quality validation rules against a DuckDB database, including completeness, uniqueness, and statistical checks.
AlicenseBqualityDmaintenanceAgentic data quality MCP server — runs structured validation rules against warehouses (DuckDB, BigQuery, Athena, Databricks, Postgres), diagnoses failures with LLM root cause analysis, and proposes SQL remediations. Full audit trail of every AI decision.633 PyPI6Apache 2.0Why this server?
Uses DuckDB as an embedded analytical database engine.
Why this server?
Provides DuckDB as the built-in local warehouse for Semantic Rails, supporting semantic queries, validation, and execution without additional connectors.
AlicenseBqualityBmaintenanceEnables agents to interact with a governed semantic layer for querying and authoring metrics, providing tools for discovery, planning, validation, and execution of analytics queries.301,359 PyPI3Apache 2.0Why this server?
Provides agent access to saved DuckDB connections for querying analytical data, browsing tables, and inspecting schemas under configured access permissions.

platypus-dbofficial
AlicenseAqualityBmaintenanceThe MCP server of PlatypusDB, an open source desktop SQL client: agents use the database connections saved in the app (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, DuckDB, Snowflake and more) with the access set for each one, read-only by default, and every change waits for approval in the app.249AGPL 3.0