{"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":41,"stars":523,"forks":86,"downloads_week":null,"last_push_at":"2026-09-19T02:19:11.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.0.8","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.8","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":[{"name":"execute_query","description":"Execute a SQL query on the DuckDB or MotherDuck database. Unqualified table names resolve to current_database() and current_schema() automatically. Fully qualified names (database.schema.table) are only needed when multiple DuckDB databases are attached or when connected to MotherDuck.","write_action":true,"price_micros":0,"input_schema":null},{"name":"list_columns","description":"List all columns of a table or view with their types and comments. If database/schema are not specified, uses the current database/schema.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_databases","description":"List all databases available in the connection. Useful when multiple DuckDB databases are attached or when connected to MotherDuck.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"List all tables and views in a database with their comments. If database is not specified, uses the current database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"switch_database_connection","description":"Switch to a different database connection. For local files, use absolute paths only. The new connection respects the server's read-only/read-write mode. For local files, the file must exist unless create_if_not_exists=True (requires read-write mode).","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":85,"grade":"A","scanned_at":"2026-09-22T17:10:45.365Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-22T17:10:45.293Z","components":{"code":{"score":25,"max":25,"notes":["15 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 4 days ago"]},"identity":{"score":9,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcp-server-motherduck","version":"1.0.8","found":true,"dependencyCount":8,"publishedAt":"2026-08-19T17:02:04.930270Z"}],"repo":{"found":true,"owner":"motherduckdb","repo":"mcp-server-motherduck","archived":false,"pushedAt":"2026-09-19T02:19:11Z","stars":523,"forks":86,"openIssues":7,"ownerType":"Organization","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/106357348?v=4","ownerCreatedAt":"2022-05-27T00:00:47Z","license":"MIT"},"icon":{"url":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","source":"registry"},"presence":{"stars":523,"forks":86,"downloadsWeek":null,"license":"MIT","lastPushAt":"2026-09-19T02:19:11.000Z","score":41}}}},"grade_history":[],"reviews":[]}