Awesome MCPDatabases

motherduckdb/mcp-server-motherduck

⭐ 521 Python added to this list on 2025-05-14 repository created 2024-12-12

MotherDuck's DuckDB MCP Server is an implementation of the Model Context Protocol (MCP) server that facilitates SQL analytics on DuckDB and MotherDuck databases. It enables seamless querying of data directly from AI Assistants and Integrated Development Environments (IDEs) by leveraging the Model Context Protocol. The server supports hybrid execution, allowing queries to be run on local DuckDB databases or cloud-based MotherDuck databases. It integrates with cloud storage solutions such as Amazon S3, enabling access to data stored remotely. Users can create and share databases, and perform SQL analytics using DuckDB's SQL dialect on datasets of any size. The server operates with a serverless architecture, eliminating the need for configuring instances or clusters, thus simplifying deployment and scaling. The MCP server provides a prompt to initialize connections to DuckDB or MotherDuck and a tool to execute SQL queries on these databases. All interactions are conducted through SQL queries, ensuring flexibility and power in data manipulation and retrieval. The server supports various command-line parameters to customize its operation, including transport type (stdio, sse, stream), port configuration, database path, access tokens for MotherDuck, read-only mode, home directory settings, SaaS mode for enhanced security, and JSON response formatting. The project includes detailed usage instructions for connecting to local DuckDB files or MotherDuck cloud databases, with prerequisites such as installing the 'uv' tool and obtaining MotherDuck access tokens. It also provides integration guides for popular clients like Cursor and Visual Studio Code, facilitating easy adoption and use in different development environments. Overall, MotherDuck's DuckDB MCP Server is a powerful tool for enabling advanced SQL analytics through the Model Context Protocol, bridging local and cloud database environments, and enhancing data accessibility for AI and developer tools.

https://github.com/motherduckdb/mcp-server-motherduck

access-tokenaiai-assistantsamazon-s3claude-desktopcloud-storage-integrationcommand-line-parameterscursorcursor-integrationdata-queryingdata-sharingdatabase-connectionduckdbhybrid-executionidesin-memory-databaselocal-duckdbmcp-servermodel-context-protocolmotherduckpromptsquery-toolread-scaling-tokenremote-object-storagesaas-modeserverless-architecturesql-analyticssql-queriesuv-toolvisual-studio-codevisual-studio-code-integration

Also in Databases

dolthub/dolt

Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.

t8y2/dbx

DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.

Canner/WrenAI

Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.

googleapis/mcp-toolbox

MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...

makenotion/notion-mcp-server

The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.

bytebase/dbhub

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.

crystaldba/postgres-mcp

Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.

supabase-community/supabase-mcp

Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.