{"servers":[{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-09-29/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"Fast analytics and data processing with DuckDB and MotherDuck","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"0.6.4","packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"0.6.4","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server","default":"stdio","choices":["stdio","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for sse and stream transport mode","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Path to local DuckDB database file or MotherDuck database","default":"md:","type":"named","name":"--db-path"},{"description":"Access token to use for MotherDuck database connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Flag for connecting to DuckDB or MotherDuck in read-only mode","type":"named","name":"--read-only"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)","type":"named","name":"--saas-mode"},{"description":"Enable JSON responses for HTTP stream (only supported for stream transport)","type":"named","name":"--json-response"}],"environmentVariables":[{"description":"Access token to use for MotherDuck database connections","isSecret":true,"name":"motherduck_token"},{"description":"Home directory for DuckDB (used as default if --home-dir not specified)","name":"HOME"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2025-09-10T15:38:28.952825Z","publishedAt":"2025-09-10T15:38:28.952825Z","updatedAt":"2025-09-10T15:38:28.952825Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-09-29/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"Fast analytics and data processing with DuckDB and MotherDuck","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"0.7.0","packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"0.7.0","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server","default":"stdio","choices":["stdio","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for sse and stream transport mode","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Path to local DuckDB database file or MotherDuck database","default":"md:","type":"named","name":"--db-path"},{"description":"Access token to use for MotherDuck database connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Flag for connecting to DuckDB or MotherDuck in read-only mode","type":"named","name":"--read-only"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)","type":"named","name":"--saas-mode"},{"description":"Enable JSON responses for HTTP stream (only supported for stream transport)","type":"named","name":"--json-response"}],"environmentVariables":[{"description":"Access token to use for MotherDuck database connections","isSecret":true,"name":"motherduck_token"},{"description":"Home directory for DuckDB (used as default if --home-dir not specified)","name":"HOME"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2025-09-30T20:27:29.780756Z","publishedAt":"2025-09-30T20:27:29.780756Z","updatedAt":"2025-09-30T20:27:29.780756Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-09-29/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"Fast analytics and data processing with DuckDB and MotherDuck","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"0.7.1","packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"0.7.1","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server","default":"stdio","choices":["stdio","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for sse and stream transport mode","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Path to local DuckDB database file or MotherDuck database","default":"md:","type":"named","name":"--db-path"},{"description":"Access token to use for MotherDuck database connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Flag for connecting to DuckDB or MotherDuck in read-only mode","type":"named","name":"--read-only"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)","type":"named","name":"--saas-mode"},{"description":"Enable JSON responses for HTTP stream (only supported for stream transport)","type":"named","name":"--json-response"}],"environmentVariables":[{"description":"Access token to use for MotherDuck database connections","isSecret":true,"name":"motherduck_token"},{"description":"Home directory for DuckDB (used as default if --home-dir not specified)","name":"HOME"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2025-10-12T15:30:59.715076Z","publishedAt":"2025-10-12T15:30:59.715076Z","updatedAt":"2025-10-12T15:30:59.715076Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-09-29/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"Fast analytics and data processing with DuckDB and MotherDuck","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"0.7.2","packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"0.7.2","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server","default":"stdio","choices":["stdio","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for sse and stream transport mode","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Path to local DuckDB database file or MotherDuck database","default":"md:","type":"named","name":"--db-path"},{"description":"Access token to use for MotherDuck database connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Flag for connecting to DuckDB or MotherDuck in read-only mode","type":"named","name":"--read-only"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)","type":"named","name":"--saas-mode"},{"description":"Enable JSON responses for HTTP stream (only supported for stream transport)","type":"named","name":"--json-response"}],"environmentVariables":[{"description":"Access token to use for MotherDuck database connections","isSecret":true,"name":"motherduck_token"},{"description":"Home directory for DuckDB (used as default if --home-dir not specified)","name":"HOME"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2025-10-13T23:32:14.916459Z","publishedAt":"2025-10-13T23:32:14.916459Z","updatedAt":"2025-10-13T23:32:14.916459Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-10-17/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"Fast analytics and data processing with DuckDB and MotherDuck","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"0.8.0","packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"0.8.0","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server","default":"stdio","choices":["stdio","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for sse and stream transport mode","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Host to bind the MCP server for sse and stream transport mode","default":"127.0.0.1","type":"named","name":"--host"},{"description":"Path to local DuckDB database file or MotherDuck database","default":"md:","type":"named","name":"--db-path"},{"description":"Access token to use for MotherDuck database connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Flag for connecting to DuckDB or MotherDuck in read-only mode","type":"named","name":"--read-only"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)","type":"named","name":"--saas-mode"},{"description":"Enable JSON responses for HTTP stream (only supported for stream transport)","type":"named","name":"--json-response"},{"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. Set to -1 to disable timeout","format":"number","default":"-1","type":"named","name":"--query-timeout"}],"environmentVariables":[{"description":"Access token to use for MotherDuck database connections","isSecret":true,"name":"motherduck_token"},{"description":"Home directory for DuckDB (used as default if --home-dir not specified)","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 (IAM roles, AWS SSO, EC2 instance profiles)","isSecret":true,"name":"AWS_SESSION_TOKEN"},{"description":"AWS region for S3 database connections","name":"AWS_DEFAULT_REGION"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2025-11-11T03:01:45.572967Z","publishedAt":"2025-11-11T03:01:45.572967Z","updatedAt":"2025-11-11T03:01:45.572967Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"Fast analytics and data processing with DuckDB and MotherDuck","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"0.8.1","packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"0.8.1","transport":{"type":"stdio"},"packageArguments":[{"description":"Transport type for MCP server","default":"stdio","choices":["stdio","sse","stream"],"type":"named","name":"--transport"},{"description":"Port to listen on for sse and stream transport mode","format":"number","default":"8000","type":"named","name":"--port"},{"description":"Host to bind the MCP server for sse and stream transport mode","default":"127.0.0.1","type":"named","name":"--host"},{"description":"Path to local DuckDB database file or MotherDuck database","default":"md:","type":"named","name":"--db-path"},{"description":"Access token to use for MotherDuck database connections","isSecret":true,"type":"named","name":"--motherduck-token"},{"description":"Flag for connecting to DuckDB or MotherDuck in read-only mode","type":"named","name":"--read-only"},{"description":"Home directory for DuckDB","type":"named","name":"--home-dir"},{"description":"Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)","type":"named","name":"--saas-mode"},{"description":"Enable JSON responses for HTTP stream (only supported for stream transport)","type":"named","name":"--json-response"},{"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. Set to -1 to disable timeout","format":"number","default":"-1","type":"named","name":"--query-timeout"}],"environmentVariables":[{"description":"Access token to use for MotherDuck database connections","isSecret":true,"name":"motherduck_token"},{"description":"Home directory for DuckDB (used as default if --home-dir not specified)","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 (IAM roles, AWS SSO, EC2 instance profiles)","isSecret":true,"name":"AWS_SESSION_TOKEN"},{"description":"AWS region for S3 database connections","name":"AWS_DEFAULT_REGION"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-01-26T11:17:34.08322Z","publishedAt":"2026-01-26T11:17:34.08322Z","updatedAt":"2026-01-26T11:17:34.08322Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.0","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.0","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-02-02T17:14:47.537983Z","publishedAt":"2026-02-02T17:14:47.537983Z","updatedAt":"2026-02-02T17:14:47.537983Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.1","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-02-12T15:30:05.595656Z","publishedAt":"2026-02-12T15:30:05.595656Z","updatedAt":"2026-02-12T15:30:05.595656Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.2","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.2","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-03-03T09:07:46.732494Z","publishedAt":"2026-03-03T09:07:46.732494Z","updatedAt":"2026-03-03T09:07:46.732494Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.3","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.3","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-03-04T14:37:18.457321Z","publishedAt":"2026-03-04T14:37:18.457321Z","updatedAt":"2026-03-04T14:37:18.457321Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.4","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.4","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-03-30T18:36:18.1323Z","publishedAt":"2026-03-30T18:36:18.1323Z","updatedAt":"2026-03-30T18:36:18.1323Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.5","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.5","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-04-28T10:54:34.277977Z","publishedAt":"2026-04-28T10:54:34.277977Z","updatedAt":"2026-04-28T10:54:34.277977Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.6","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.6","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-04-29T10:43:36.647328Z","publishedAt":"2026-04-29T10:43:36.647328Z","updatedAt":"2026-04-29T10:43:36.647328Z","isLatest":false}}},{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.motherduckdb/mcp-server-motherduck","description":"SQL analytics and data engineering for AI Assistants and IDEs","repository":{"url":"https://github.com/motherduckdb/mcp-server-motherduck","source":"github"},"version":"1.0.7","icons":[{"src":"https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64","mimeType":"image/png","sizes":["64x64"]}],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-server-motherduck","version":"1.0.7","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-06-09T12:56:38.524877Z","publishedAt":"2026-06-09T12:56:38.524877Z","updatedAt":"2026-06-09T12:56:38.524877Z","isLatest":true}}}],"metadata":{"count":14}}