michael7736_mysql-mcp-server
0
The MySQL MCP Server is designed to facilitate SQL query execution against a MySQL database through a Model Context Protocol. It supports a range of SQL operations including read, create, update, and delete functionalities, providing results in JSON format and configurable connection settings.
MySQL MCP Server
This is a Model Context Protocol (MCP) server for MySQL databases, enabling agents to execute SQL queries. Key features include:
- Executing SQL queries (SELECT, CREATE TABLE, INSERT INTO, UPDATE, DELETE)
- Returning query results in JSON format
- Configurable database connection settings
- Transaction logging with unique IDs
Prerequisites
- Node.js (v14 or higher)
- MySQL server
- MCP SDK
Usage
After setup, use the MCP server to execute queries in conversations.
Available Tools
run_sql_query
Executes read-only SQL queries (SELECT statements).
create_table
Creates new tables in the database.
insert_data
Inserts data into tables.
update_data
Updates data in tables.
delete_data
Deletes data from tables.