mcp-server-motherduck

This server allows users to connect to various types of databases including local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. It supports executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections seamlessly. The server is designed for data analytics and engineering specifically tailored for AI assistants and IDEs. With the local MCP server, users can query across local and remote databases, ingest data from, and export data to the local filesystem. It runs in read-only mode by default for security, with options to enable write access. This flexibility makes it suitable for a variety of data engineering tasks.

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "args": [
        "mcp-server-motherduck"
      ],
      "command": "uvx"
    }
  }
}