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 running data quality validation rules against a DuckDB database, including completeness, uniqueness, and statistical checks.
AlicenseBqualityCmaintenanceAgentic 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 an embedded analytical database engine.
Why this server?
Allows querying DuckDB databases as a data source via read-only SQL.
AlicenseAqualityAmaintenanceRead-only, PII-masked MCP server for querying data federated through DuckDB — list sources/tables, inspect schemas, and run SQL across Postgres, MySQL, SQLite, Snowflake, BigQuery, Excel, and files, governed per source/table/column by a charter.yaml contract. Snowflake, BigQuery, Excel, and files, governed per source/table/column by a charter.yaml contract.447Apache 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.93412557MITWhy this server?
Provides a rebuildable index using DuckDB for hybrid retrieval (vector search, BM25 full-text search, and graph traversal) over the vault's notes.
AlicenseBqualityAmaintenanceagentcairn is a local-first memory MCP server: your agent's memories live as Markdown in an Obsidian vault you own — the source of truth — with a rebuildable DuckDB index providing fast hybrid BM25 + vector + graph recall. It exposes tools to capture, recall, and manage those memories (non-lossy, with secret redaction) and works the same across Claude Code, Codex, Cursor, and any MCP host.532Apache 2.0Why 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.8757MITWhy this server?
Provides tools for querying and analyzing a local DuckDB warehouse containing NFL play-by-play data, player/team stats, rosters, injuries, officials, draft history, and betting lines, enabling AI agents to answer football questions via SQL.
AlicenseAqualityCmaintenanceEnables natural-language querying of a local DuckDB warehouse of NFL play-by-play data, converting questions into SQL and returning results.19MITWhy this server?
The server implementation was inspired by and incorporates code from mcp-server-duckdb, suggesting potential DuckDB database connectivity capabilities.
AlicenseBqualityDmaintenanceA Model Context Protocol server that enables AI assistants to securely interact with ClickHouse databases, supporting table exploration and SQL query execution through a controlled interface.18Apache 2.0Why 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.68Apache 2.0