@motherduckdb
基本信息
Local MCP server for DuckDB and MotherDuck
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"DuckDB (in-memory, r/w)": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--db-path",
":memory:",
"--read-write",
"--allow-switch-databases"
]
}
}
}Execute SQL query (DuckDB dialect)
List all databases (useful for MotherDuck or multiple attached DBs)
List tables and views
List columns of a table/view
An MCP server that connects AI assistants and IDEs to DuckDB's analytical SQL engine. It supports local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Users can execute SQL queries, browse database catalogs, and switch between connections at runtime.
Install uv via pip install uv or brew install uv, then add a JSON configuration to your MCP client’s config file. Use the command uvx mcp-server-motherduck with args like --db-path :memory: for in-memory, --db-path /path/to/file.duckdb for local files, or --db-path md: for MotherDuck. Additional flags control read-write access, database switching, and security.
--allow-switch-databases).The local server runs on your machine and requires installation; the remote server is hosted by MotherDuck with zero setup. Both support read-write, but only the local server can access the local filesystem.
Add the `--read-write` flag. Without it, the server runs in read-only mode by default.
The default `--db-path` is `:memory:` (in-memory). The server starts in read-only mode unless `--read-write` is set.
Set `--db-path md:` and provide a MotherDuck token via the `motherduck_token` environment variable or `--motherduck-token` flag. Use a read-scaling token for read-only access.
Read-only mode is not sufficient when giving third parties access. Consider using MotherDuck Remote MCP, or self-host with service accounts, read-scaling tokens, SaaS mode (`--motherduck-saas-mode`), and `--init-sql` to apply security settings.
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.
A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
评论