Awesome MCPDatabases

f4ww4z/mcp-mysql-server

⭐ 168 JavaScript added to this list on 2025-05-06 repository created 2024-12-13

A Model Context Protocol server that exposes MySQL database operations to AI models through a standardised tool interface, published on npm as @f4ww4z/mcp-mysql-server. It provides five tools. connect_db opens a connection using host, user, password and database name. query runs SELECT statements and accepts an optional array of parameters bound through prepared statements. execute runs INSERT, UPDATE and DELETE statements with the same parameter binding. list_tables returns every table in the connected database. describe_table returns the column structure of a named table. Connection details can be supplied in two ways: as a single MySQL connection URL passed as a command argument, which the README marks as the recommended form, or as the MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD and MYSQL_DATABASE environment variables in the MCP client settings. Installation is either an automated Smithery install for Claude Desktop or a direct npx invocation, and the README shows configuration for both MCP client JSON settings and the Codex config.toml on macOS and Windows. The stated design goals are safety and simplicity: prepared statements guard against SQL injection, passwords stay in environment variables rather than in prompts, queries are validated before execution, and connections are opened and closed automatically so nothing is left dangling. Error handling reports connection failures, invalid queries, missing parameters and database errors with specific messages. The project is written with TypeScript support and includes an evals setup based on mcp-eval that loads an MCP client against the source entry point, so tests run without a rebuild. It is MIT licensed. The audience is developers who want an assistant to inspect a schema and run ad hoc reads and writes against a MySQL instance during development or support work.

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

mysqldatabasesqlmcp-serverjavascriptprepared-statements

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.