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?
Enables querying the code search index and knowledge graph as SQL tables via HTTP API, allowing correlation with other data sources in DuckDB.
AlicenseAqualityAmaintenanceA 100% local MCP server for semantic and lexical search over your code, library docs, and PDFs, featuring hybrid BM25 and dense retrieval, syntax aware chunking, and an optional code knowledge graph. It also ships a Coral integration, so you can expose your code search as SQL and join it with live data, all without anything leaving your machine.8169Apache 2.0Why this server?
Integrates with local DuckDB to provide SQL analytics capabilities and allow querying data from local databases
AlicenseAqualityAmaintenanceAn MCP server for MotherDuck and local DuckDB.5522MITWhy 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
AlicenseAqualityAmaintenanceEnables AI agents to perform professional-grade geoprocessing tasks such as buffers, overlays, reprojections, and terrain analysis with deterministic tools and verifiable provenance.281AGPL 3.0Why this server?
Provides DuckDB as the built-in local warehouse for Semantic Rails, supporting semantic queries, validation, and execution without additional connectors.
AlicenseBqualityAmaintenanceEnables agents to interact with a governed semantic layer for querying and authoring metrics, providing tools for discovery, planning, validation, and execution of analytics queries.16Apache 2.0Why 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.64Apache 2.0Why this server?
Uses DuckDB as the backend database for fast and efficient querying of health data, enabling complex SQL queries on exported Apple Health information.
AlicenseAqualityAmaintenanceAn MCP server that allows users to query and analyze their Apple Health data using SQL and natural language, utilizing DuckDB for fast and efficient health data analysis.2371 npm567MITWhy this server?
Allows querying financial evidence from money markets, bank risk, market liquidity, and China economy data through DuckDB using HTTP-backed views.
AlicenseAqualityAmaintenanceEnables MCP clients to list research topics, route queries across money-market, capital-market, bank-risk, market-liquidity, and China-economy domains, and fetch read-only structured results from bounded public evidence without requiring an account or API key.3MITWhy this server?
Supports working with DuckDB as a database backend for dbt projects, as shown in the profiles.yml example.
AlicenseAqualityDmaintenanceA Model Context Protocol (MCP) server that wraps the dbt CLI tool, enabling AI coding agents to interact with dbt projects through standardized MCP tools. Developed by Mammoth Growth.918MITWhy this server?
Connects to DuckDB databases to run SQL queries and generate insights from the data