MCP (Model Context Protocol) server for DuckDB — auth and friendly SQL support out of the box
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add duckdb-server-mustafahasankhan -- python -m venv .venv '&&' source .venv/bin/activate~/.codex/config.toml
[mcp_servers.duckdb-server-mustafahasankhan]
command = "python"
args = ["-m", "venv", ".venv", "&&", "source", ".venv/bin/activate"]
# codex mcp add duckdb-server-mustafahasankhan -- python -m venv .venv '&&' source .venv/bin/activate~/.cursor/mcp.json
{
"mcpServers": {
"duckdb-server-mustafahasankhan": {
"command": "python",
"args": [
"-m",
"venv",
".venv",
"&&",
"source",
".venv/bin/activate"
]
}
}
}.vscode/mcp.json
{
"servers": {
"duckdb-server-mustafahasankhan": {
"type": "stdio",
"command": "python",
"args": [
"-m",
"venv",
".venv",
"&&",
"source",
".venv/bin/activate"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"duckdb-server-mustafahasankhan": {
"command": "python",
"args": [
"-m",
"venv",
".venv",
"&&",
"source",
".venv/bin/activate"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"duckdb-server-mustafahasankhan": {
"command": "python",
"args": [
"-m",
"venv",
".venv",
"&&",
"source",
".venv/bin/activate"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"duckdb-server-mustafahasankhan": {
"command": "python",
"args": [
"-m",
"venv",
".venv",
"&&",
"source",
".venv/bin/activate"
]
}
}
}