io.github.motherduckdb/mcp-server-motherduck
SQL analytics and data engineering for AI Assistants and IDEs
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
],
"env": {
"motherduck_token": "<your-motherduck_token>",
"MOTHERDUCK_TOKEN": "<your-motherduck_token>",
"HOME": "<home>",
"AWS_ACCESS_KEY_ID": "<your-aws_access_key_id>",
"AWS_SECRET_ACCESS_KEY": "<your-aws_secret_access_key>",
"AWS_SESSION_TOKEN": "<your-aws_session_token>",
"AWS_DEFAULT_REGION": "<aws_default_region>",
"AWS_ENDPOINT": "<aws_endpoint>"
}
}
}
}motherduck_tokenAccess token for MotherDuck connections (alternative to --motherduck-token)
MOTHERDUCK_TOKENAccess token for MotherDuck connections (alternative to --motherduck-token)
HOMEUsed by DuckDB for extensions and config. Override with --home-dir if not set.
AWS_ACCESS_KEY_IDAWS access key for S3 database connections
AWS_SECRET_ACCESS_KEYAWS secret access key for S3 database connections
AWS_SESSION_TOKENAWS session token for temporary credentials
AWS_DEFAULT_REGIONAWS region for S3 database connections
AWS_ENDPOINTAWS endpoint for S3 database connections
Manage your projects, debug deployment, and check analytics for any MCP server you host with Alpic
Strava MCP tools for AI: athletes, activities, segments, clubs, routes. Powered by HAPI MCP server.
Analytics for business data: upload CSV or connect GA4/GSC, run ML/stats, get HTML reports.