duckdb-mcp-server

duckdb-mcp-server

3.3

If you are the rightful owner of duckdb-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

DuckDB MCP Server is a Model Context Protocol server that connects AI assistants to DuckDB for data analysis.

DuckDB MCP Server is a robust implementation of the Model Context Protocol (MCP) that facilitates interaction between AI assistants and DuckDB, a high-performance analytical database. This server allows AI models to perform complex data queries and analyses directly from various data sources such as CSV, Parquet, JSON, and cloud storage like S3. It simplifies the process of data analysis by providing seamless integration with DuckDB's SQL capabilities, enabling AI models to generate insights with contextual understanding. The server supports automatic connection management, smart credential handling, and offers comprehensive documentation resources for AI assistants to leverage DuckDB's full potential.

Features

  • SQL Query Tool: Execute any SQL query with DuckDB's powerful syntax.
  • Multiple Data Sources: Query directly from local files, S3 buckets, SQLite databases, and other DuckDB-supported sources.
  • Auto-Connection Management: Automatic database file creation and connection handling.
  • Smart Credential Handling: Seamless AWS/S3 credential management.
  • Documentation Resources: Built-in DuckDB SQL and data import reference for AI assistants.