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?
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.113491564MITWhy 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?
Provides read-only SQL querying, schema inspection, row counting, and data profiling on DuckDB databases, with safety guardrails like statement allowlisting and row limits.
AlicenseAqualityBmaintenanceA unified Model Context Protocol server for data engineering and analytics that lets LLM clients query, profile, transform, and visualize data using DuckDB and PySpark, while keeping raw data out of the model's context through read-only, bounded, and audited operations.481MITWhy this server?
Provides SQL query execution and schema exploration capabilities for clinical datasets stored in DuckDB, including MIMIC-IV and eICU tabular data with tools for database schema inspection, table information retrieval, and SELECT query execution.
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.612Apache 2.0Why this server?
Provides read-only analytics over DuckDB databases, offering tools to list datasets, describe tables, profile columns, explain query plans, and run SELECT queries with row and time caps.
AlicenseAqualityCmaintenanceA read-only DuckDB MCP server offering context-efficient analytics tools (list_datasets, describe_table, profile_column, explain, query) with a semantic layer for business rules, security guards, and disclosed truncation to help LLMs produce correct answers while minimizing token usage.5MITWhy this server?
Provides SQL analytics capabilities for querying local DuckDB databases, in-memory databases, and cloud-stored databases using DuckDB's SQL dialect.
AlicenseBqualityDmaintenanceEnables AI assistants and IDEs to execute SQL queries on local DuckDB databases, in-memory databases, or cloud-stored databases with support for flexible connections and configurable result limits.11MITWhy this server?
Uses DuckDB as an embedded analytical database engine.
Why this server?
Connects to DuckDB databases for profiling and monitoring.