Awesome MCPDatabases

benborla/mcp-server-mysql

⭐ 2119 TypeScript added to this list on 2025-05-06 repository created 2024-12-09

The project "mcp-server-mysql" is a Model Context Protocol (MCP) server designed to provide secure, read-only access to MySQL databases. It enables large language models (LLMs) to inspect database schemas and execute SQL queries efficiently. The server is built on Node.js and supports MySQL versions 5.7 and above, with a recommendation for MySQL 8.0 or higher. It requires a MySQL user with appropriate permissions, and for write operations, users must have INSERT, UPDATE, and/or DELETE privileges. Installation and configuration of the MCP server can be done through various methods including using Smithery, Cursor IDE, Claude Code, or running from a local repository. The project provides detailed instructions for each method, including environment variable configurations for database connection details and operation permissions. It supports multi-database mode and schema-specific permissions, allowing flexible and secure access control. The server supports advanced configurations such as connection pooling, query timeouts, caching, rate limiting, SSL connections, and logging. It also offers troubleshooting guidance for common issues like server connection problems, path issues, permission errors, and server startup failures. The project is well-documented with a comprehensive README that includes a demo, installation steps, configuration options, and usage examples. It integrates with tools like Claude Code and Smithery for streamlined management and deployment. The MCP server is designed to facilitate the interaction between LLMs and MySQL databases by providing a standardized protocol for querying and schema inspection, enhancing the capabilities of AI applications that require database access. Overall, "mcp-server-mysql" is a robust and flexible MCP server implementation tailored for MySQL databases, enabling secure and efficient database interactions for AI and LLM applications.

https://github.com/benborla/mcp-server-mysql

cachingclaude-codeclaude-desktopconfigurationconnection-poolingcursor-idedatabase-accessdatabase-schema-inspectiondeleteenvironment-variablesinsertinstallationintegrationlarge-language-modelsllmloggingmcp-getmcp-servermodel-context-protocolmulti-database-modemysqlnode.jsprepared-statementsquery-executionquery-statisticsquery-timeoutrate-limitingread-only-accessresult-paginationschema-inspectionschema-specific-permissionssecure-accesssecure-database-accesssmitherysql-queriesssltransaction-handlingtroubleshootingupdatewrite-operations

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.