michael7736/mysql-mcp-server

3.3

If you are the rightful owner of mysql-mcp-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.

The MySQL MCP Server is a Model Context Protocol server that facilitates interaction with a MySQL database, allowing agents to execute SQL queries.

Tools

Functions exposed to the LLM to take actions

run_sql_query

Executes a read-only SQL query (SELECT statements only) against the MySQL database.

create_table

Creates a new table in the MySQL database.

insert_data

Inserts data into a table in the MySQL database.

update_data

Updates data in a table in the MySQL database.

delete_data

Deletes data from a table in the MySQL database.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

michael7736

Claim Ownership

Verify you have write access to the repository

Repository

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

GitHub Stars

Last publish date

2025-04-10

Last update date

2025-09-02

Server configs

in vscode

{
  "mcpServers": {
    "mysql-mcp-server": {
      "autoApprove": [],
      "disabled": false,
      "timeout": 60,
      "command": "node",
      "args": [
        "/path/to/mysql-mcp-server/build/index.js"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "mcp101",
        "MYSQL_PASSWORD": "123qwe",
        "MYSQL_DATABASE": "mcpdb"
      },
      "transportType": "stdio"
    }
  }
}

in claude desktop

{
  "mcpServers": {
    "mysql-mcp-server": {
      "autoApprove": [],
      "disabled": false,
      "timeout": 60,
      "command": "node",
      "args": [
        "/path/to/mysql-mcp-server/build/index.js"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "mcp101",
        "MYSQL_PASSWORD": "123qwe",
        "MYSQL_DATABASE": "mcpdb"
      },
      "transportType": "stdio"
    }
  }
}

Top Comments

Related MCP Servers

View all databases servers →

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-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-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-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

notion-mcp-server

4.2

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

ai_chatbot

supabase-mcp

4.2

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

databases

prisma

4.1

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

databases

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

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

db-mcp-server

3.9

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

databases

supabase-mcp

3.9

by coleam00

A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.

databases

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

airtable-mcp

3.8

by felores

A Model Context Protocol server for interacting with Airtable's API, enabling programmatic management of Airtable bases, tables, fields, and records.

databases

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

mcp-server-mysql

3.7

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

databases

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-server-elasticsearch

3.7

by elastic

This server connects agents to your Elasticsearch data using the Model Context Protocol, allowing interaction with Elasticsearch indices through natural language conversations.

databases

openehr-mcp-server

3.7

by deak-ai

An MCP server designed to interface with openEHR REST APIs, specifically the EHRbase implementation.

databases

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

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

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

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-mongo-server

3.6

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

databases

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

mcp-snowflake-server

3.6

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.

databases

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

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