mcp-server-motherduck
164
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