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?
Supports querying DuckDB and MotherDuck instances, providing agents with access to analytical data processing.
Why this server?
Provides reusable modules for data storage integration with DuckDB, enabling database operations and analytics capabilities
Why this server?
Provides data storage integration with examples for database operations and analytics workloads
Why this server?
Enables querying Markdown frontmatter data using DuckDB SQL, including support for complex queries with type casting, JSON array operations, and semantic search with vector embeddings.
Why 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?
Provides SQL analytics capabilities for querying local DuckDB databases, in-memory databases, and cloud-stored databases using DuckDB's SQL dialect.
Why this server?
Supports working with DuckDB as a database backend for dbt projects, as shown in the profiles.yml example.
Why this server?
Uses DuckDB to query provider-level Medicaid claims data from local Parquet files, enabling high-performance analysis of HCPCS codes, NPI-specific spending, and service summaries.
Why this server?
Connects to DuckDB databases to run SQL queries and generate insights from the data