A
licenseA
qualityA
maintenanceAn MCP server for MotherDuck and local DuckDB.
10
5
526
MIT
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?
Integrates with local DuckDB to provide SQL analytics capabilities and allow querying data from local databases
Why 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?
Runs read-only SQL against DuckDB, querying CSV, Parquet and JSON files or an existing .duckdb database, describing columns/types/row counts and samples, and writing query results out to .csv, .tsv, .parquet or .json/.ndjson files (never overwriting an existing file unless overwrite=True).
faraztools-mcpofficial
AlicenseAqualityCmaintenanceEnables AI clients to call small utility tools like echo and Markdown-to-PDF conversion, running locally over stdio.2MITWhy this server?
Enables querying of geographic data stored in parquet files via DuckDB's HTTP filesystem support.
AlicenseAqualityBmaintenanceRemote MCP server for geographic data. Free and x402 paid packs all normalized for cross domain joins. Start with get_catalog, then get_pack for details.2132MITWhy 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.271,128 PyPI1Apache 2.0Why 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.28209 PyPI2AGPL 3.0Why this server?
Enables DuckDB as an in-process analytical sink for HKEx filings, with idempotent upserts.
AlicenseAqualityAmaintenanceA read-only MCP server so AI agents can query the corpus or the live site.212275 PyPI16MITWhy this server?
Uses DuckDB as the backend database for storing knowledge graph data, leveraging its fast query processing, SQL interface, and transaction support for efficient storage and retrieval of entities, observations, and relations.
AlicenseBqualityCmaintenanceA memory server for Claude that stores and retrieves knowledge graph data in DuckDB, enhancing performance and query capabilities for conversations with persistent user information.89 npm59MITWhy this server?
Enables SQL queries against blockchain data through DuckDB, supporting data exploration, schema inspection, and complex analytics on downloaded blockchain datasets with various filtering and aggregation capabilities.
AlicenseAqualityDmaintenanceAn API server that implements the Model Completion Protocol (MCP) for Cryo blockchain data extraction, allowing users to query Ethereum blockchain data through any MCP-compatible client.1091MIT
