MotherDuck
Createdmotherduckdb
Enables SQL analytics capabilities for Claude by integrating MotherDuck and local DuckDB.
About
MotherDuck provides an MCP server that seamlessly integrates MotherDuck and local DuckDB, empowering Claude to perform SQL analytics. It allows users to query data from both cloud-based MotherDuck and local DuckDB instances, leveraging cloud storage integrations for accessing data stored in platforms like Amazon S3. The server boasts a serverless architecture, removing the need for instance or cluster configuration, and facilitates data sharing, enabling users to create and share databases effortlessly, all through writing SQL queries.
Key Features
- Hybrid execution: query data from both cloud-based MotherDuck and local DuckDB
- Data sharing: create and share databases
- Serverless architecture: run analytics without needing to configure instances or clusters
- Cloud storage integration: access data stored in Amazon S3 or other cloud storage thanks to MotherDuck's integrations
- SQL analytics: use DuckDB's SQL dialect to query any size of data directly from Claude
- 52 GitHub stars
Use Cases
- Query data from local CSV files
- Join data from local DuckDB databases with tables in MotherDuck
- Analyze data stored in Amazon S3