{"name":"io.github.motherduckdb/mcp-server-motherduck","slug":"motherduckdb-mcp-server-motherduck","title":null,"description":"SQL analytics and data engineering for AI Assistants and IDEs","url":"https://mcp.market/server/motherduckdb-mcp-server-motherduck","rating":null,"grade":"A","score":85,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":59,"stars":539,"forks":90,"downloads_week":4594,"last_push_at":"2026-10-30T23:56:17.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/motherduckdb/mcp-server-motherduck","website":null,"version":"1.1.1","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.1.1","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server. Use 'http' for HTTP Streamable transport.","default":"stdio","choices":["stdio","http","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for HTTP transport","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Host to bind the MCP server","default":"127.0.0.1","type":"named","name":"--host"},{"description":"Database path: ':memory:' for in-memory, 'md:' for MotherDuck, or file/S3 path","default":":memory:","type":"named","name":"--db-path"},{"description":"Access token for MotherDuck connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Enable write access (server runs in read-only mode by default)","type":"named","name":"--read-write"},{"description":"Enable the switch_database_connection tool to change databases at runtime","type":"named","name":"--allow-switch-databases"},{"description":"Enable SaaS mode for MotherDuck (disables local filesystem access)","type":"named","name":"--motherduck-saas-mode"},{"description":"SQL file path or SQL string to execute on startup","type":"named","name":"--init-sql"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Maximum number of rows to return from queries","format":"number","default":"1024","type":"named","name":"--max-rows"},{"description":"Maximum number of characters in query results","format":"number","default":"50000","type":"named","name":"--max-chars"},{"description":"Query execution timeout in seconds (-1 to disable)","format":"number","default":"-1","type":"named","name":"--query-timeout"},{"description":"Use temporary connections for read-only local DuckDB files (default: true)","type":"named","name":"--ephemeral-connections"}],"environmentVariables":[{"description":"Access token for MotherDuck connections (alternative to --motherduck-token)","isSecret":true,"name":"motherduck_token"},{"description":"Access token for MotherDuck connections (alternative to --motherduck-token)","isSecret":true,"name":"MOTHERDUCK_TOKEN"},{"description":"Used by DuckDB for extensions and config. Override with --home-dir if not set.","name":"HOME"},{"description":"AWS access key for S3 database connections","isSecret":true,"name":"AWS_ACCESS_KEY_ID"},{"description":"AWS secret access key for S3 database connections","isSecret":true,"name":"AWS_SECRET_ACCESS_KEY"},{"description":"AWS session token for temporary credentials","isSecret":true,"name":"AWS_SESSION_TOKEN"},{"description":"AWS region for S3 database connections","name":"AWS_DEFAULT_REGION"},{"description":"AWS endpoint for S3 database connections","name":"AWS_ENDPOINT"}]}],"tools":[],"scan":null,"grade_history":[],"reviews":[]}