mcp-server-motherduck

164
databasescloud_storage

MotherDuck's DuckDB MCP Server is a comprehensive solution aimed at enhanced SQL analytics, offering seamless integration with both local and cloud-based databases. It supports AI Assistants and IDEs, allowing for hybrid execution and cloud storage integration.

MotherDuck's DuckDB MCP Server

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

Features

  • Hybrid execution: query data from local DuckDB or/and cloud-based MotherDuck databases
  • Cloud storage integration: access data stored in Amazon S3 or other cloud storage thanks to MotherDuck's integrations
  • Data sharing: create and share databases
  • SQL analytics: use DuckDB's SQL dialect to query any size of data directly from your AI Assistant or IDE
  • Serverless architecture: run analytics without needing to configure instances or clusters

Components

Prompts

  • duckdb-motherduck-initial-prompt: A prompt to initialize a connection to DuckDB or MotherDuck and start working with it

Tools

  • query: Execute a SQL query on the DuckDB or MotherDuck database