Top AI Repos — open-source AI, indexed and scored
Top AI Repos tracks AI repositories on GitHub and answers two different questions about each one: is it moving right now, and would you bet a product on it.
Top AI Repos tracks AI repositories on GitHub and answers two different questions about each one: is it moving right now, and would you bet a product on it.
Local MCP server for DuckDB and MotherDuck
| Date | Stars |
|---|---|
| 2026-08-03 | 506 |
| 2026-08-06 | 506 |
| 2026-08-12 | 504 |
| 2026-08-18 | 506 |
| 2026-08-19 | 507 |
| 2026-08-20 | 508 |
| 2026-08-22 | 509 |
| 2026-08-24 | 510 |
| 2026-08-25 | 510 |
| 2026-08-27 | 511 |
| 2026-08-29 | 512 |
| 2026-08-31 | 513 |
| 2026-09-01 | 515 |
| 2026-09-02 | 517 |
| 2026-09-03 | 517 |
| 2026-09-05 | 518 |
| 2026-09-06 | 519 |
| 2026-09-10 | 520 |
| 2026-09-12 | 521 |
| 2026-09-15 | 521 |
| 2026-09-17 | 522 |
| 2026-09-19 | 523 |
| 2026-09-25 | 524 |
| 2026-09-29 | 525 |
| 2026-10-01 | 524 |
| 2026-10-03 | 525 |
| 2026-10-04 | 526 |
| 2026-10-08 | 526 |
| 2026-10-09 | 527 |
| 2026-10-14 | 528 |
| 2026-10-15 | 527 |
| 2026-10-16 | 530 |
| 2026-10-17 | 530 |
| 2026-10-18 | 532 |
| 2026-10-20 | 532 |
| 2026-10-21 | 533 |
| 2026-10-23 | 534 |
| 2026-10-27 | 535 |
| 2026-10-28 | 536 |
| 2026-11-02 | 538 |
| 2026-11-03 | 539 |
| 2026-11-04 | 539 |
Today
— stars today
This week
+3 stars this week
This month
+13 stars this month
Momentum
38.0
growth rate 0.56%/day
<p align="center">
<img src="src/mcp_server_motherduck/assets/duck_feet_square.png" alt="MotherDuck / DuckDB Local MCP Server" width="120">
</p>
<h1 align="center">DuckDB / MotherDuck Local MCP Server</h1>
<p align="center">
SQL analytics and data engineering for AI Assistants and IDEs.
</p>
---
Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly.
**Looking for a fully-managed remote MCP server for MotherDuck?** → [Go to the MotherDuck Remote MCP docs](https://motherduck.com/docs/sql-reference/mcp/)
### Remote vs Local MCP
| | **[Remote MCP](https://motherduck.com/docs/sql-reference/mcp/)** | **Local MCP** (this repo) |
|---|---|---|
| **Hosting** | Hosted by MotherDuck | Runs locally/self-hosted |
| **Setup** | Zero-setup | Requires local installation |
| **Access** | Read-write supported | Read-write supported |
| **Local filesystem** | - | Query across local and remote databases, ingest data from / export data to local filesystem |
## Quick Start
**Prerequisites**: Install `uv` via `pip install uv` or `brew install uv`
### Connecting to In-Memory DuckDB (Dev Mode)
```json
{
"mcpServers": {
"DuckDB (in-memory, r/w)": {
"command": "uvx",
"args": ["mcp-server-motherduck", "--db-path", ":memory:", "--read-write", "--allow-switch-databases"]
}
}
}
```
Full flexibility with no guardrails — read-write access and the ability to switch to any database (local files, S3, or MotherDuck) at runtime.
### Connecting to a Local DuckDB File in Read-Only Mode
```json
{
"mcpServers": {
"DuckDB (read-only)": {
"command": "uvx",
"args": ["mcp-server-motherduck", "--db-path", "/absolute/path/to/your.duckdb"]
}
}
}
```
Connects to a specific DuckDB file in read-only mode. Won't hold on to the file lock, so convenient to use alongside a write connection to the same DuckDB file. You can also connect to remote DuckDB files on S3 using `s3://bucket/path.duckdb` — see [Environment Variables](#environment-variables) for S3 authentication. If you're considering third-party access to the MCP, see [Securing for Production](#securing-for-production).
### Connecting to MotherDuck in Read-Write Mode
```json
{
"mcpServers": {
"MotherDuck (local, r/w)": {
"command": "uvx",
"args": ["mcp-server-motherduck", "--db-path", "md:", "--read-write"],
"env": {
"motherduck_token": "<YOUR_MOTHERDUCK_TOKEN>"
}
}
}
}
```
See [Command Line Parameters](#command-line-parameters) for more options, [Securing for Production](#securing-for-production) for deployment guidance, and [Troubleshooting](#troubleshooting) if you encounter issues.
## Client Setup
| Client | Config Location | One-Click Install |
|--------|-----------------|-------------------|
| **Claude Desktop** | Settings → Developer → Edit Config | [.mcpb (MCP Bundle)](https://github.com/motherduckdb/mcp-server-motherduck/releases/latest/download/mcp-server-motherduck.mcpb) |
| **Claude Code** | Use CLI commands below | - |
| **Codex CLI** | Use CLI commands below or `~/.codex/config.toml` | - |
| **Gemini CLI** | Use CLI commands below or `~/.gemini/settings.json` | - |
| **Cursor** | Settings → MCP → Add new global MCP server | [<img src="https://cursor.com/deeplink/mcp-install-dark.svg" alt="Install in Cursor" height="20">](https://cursor.com/en/install-mcp?name=DuckDB&config=eyJjb21tYW5kIjoidXZ4IG1jcC1zZXJ2ZXItbW90aGVyZHVjayAtLWRiLXBhdGggOm1lbW9yeTogLS1yZWFkLXdyaXRlIC0tYWxsb3ctc3dpdGNoLWRhdGFiYXNlcyIsImVudiI6e319) |
| **VS Code** | `Ctrl+Shift+P` → "Preferences: Open User Settings (JSON)" | [](https://insiders.vscode.dev/redirect/mcp/instExcerpt of 13,055 characters
Read on GitHub
138
Adithya Krishnan · Netherlands
33
19
11
7
4
4
3
3
2
1
1
1
1
1
1
1
1
Would you bet a product on this? Bounded 0–100 and slow moving.
matched fp:82b19b94e80c1a23, name:mcp server, desc:mcp server