mcp-mysql-server

actstorms/mcp-mysql-server

3.1
databases

If you are the rightful owner of mcp-mysql-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server for interacting with a MySQL database, allowing MCP clients to query and modify data.

Tools

Functions exposed to the LLM to take actions

query

Executes a read-only SQL query (SELECT, SHOW, DESCRIBE) against the configured database.

insert

Executes an INSERT SQL statement. Requires MYSQL_ALLOW_WRITE_OPS to be set to true.

update

Executes an UPDATE SQL statement. Requires MYSQL_ALLOW_WRITE_OPS to be set to true.

delete

Executes a DELETE SQL statement. Requires MYSQL_ALLOW_WRITE_OPS to be set to true.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Related MCP Servers

View all databases servers →
dbhub

dbhub

4.5

by bytebase

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface.

databases
mysql_mcp_server

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

databases
mcp-notion-server

mcp-notion-server

4.4

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

databases
mcp-pinecone

mcp-pinecone

4.4

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

databases
mcp-alchemy

mcp-alchemy

4.4

by runekaagaard

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

databases
mcp-clickhouse

mcp-clickhouse

4.3

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

databases
mcp-server-duckdb

mcp-server-duckdb

4.2

by ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.

databases
mcp-server-qdrant

mcp-server-qdrant

4.0

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory
mcp-memory-libsql

mcp-memory-libsql

4.0

by spences10

A high-performance, persistent memory system for the Model Context Protocol (MCP) powered by libSQL, providing vector search capabilities and efficient knowledge storage.

knowledge_and_memory
supabase-mcp-server

supabase-mcp-server

4.0

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
doris-mcp-server

doris-mcp-server

3.9

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases
mcp-server-neon

mcp-server-neon

3.9

by neondatabase

The Neon MCP Server is an open-source tool that facilitates natural language interaction with Neon Postgres databases.

databases
postgres-mcp

postgres-mcp

3.8

by crystaldba

Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.

databases
azure-mcp

azure-mcp

3.8

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
mcp-server-motherduck

mcp-server-motherduck

3.7

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases
mcp-redis

mcp-redis

3.6

by redis

The Redis MCP Server is a natural language interface designed for agentic applications to efficiently manage and search data in Redis.

databases
mcp-server-milvus

mcp-server-milvus

3.6

by zilliztech

The MCP Server for Milvus enables seamless integration between LLM applications and the Milvus vector database, providing a standardized way to connect LLMs with the context they need.

databases
prometheus-mcp-server

prometheus-mcp-server

3.6

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

databases
xiyan_mcp_server

xiyan_mcp_server

3.6

by XGenerationLab

XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

databases
mcp-server-splunk

mcp-server-splunk

3.6

by jkosik

A Go implementation of the MCP server for Splunk, supporting STDIO and SSE (Server-Sent Events HTTP API) using the github.com/mark3labs/mcp-go SDK.

cloud_platforms
mcp-database-server

mcp-database-server

3.6

by executeautomation

The MCP Database Server provides database access capabilities to Claude, supporting SQLite, SQL Server, and PostgreSQL databases.

databases
mongo-mcp

mongo-mcp

3.6

by QuantGeekDev

A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.

databases
mssql_mcp_server

mssql_mcp_server

3.6

by RichardHan

A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.

databases
mcp-server-starrocks

mcp-server-starrocks

3.6

by StarRocks

The StarRocks Official MCP Server facilitates seamless interaction between AI assistants and StarRocks databases, enabling SQL execution, data exploration, and visualization.

databases
elasticsearch-mcp-server

elasticsearch-mcp-server

3.6

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

databases