The MySQL MCP Server allows execution of various SQL operations on a MySQL database:
- Execute read-only queries (SELECT) to retrieve data
- Create new tables using CREATE TABLE statements
- Insert data into existing tables
- Update data in tables
- Delete data from tables
- Execute non-SELECT SQL statements (e.g., ALTER TABLE, DROP)
- Return query results in JSON format for easy processing
- Configure database connections using environment variables
- Log transactions with unique IDs for auditing purposes
MySQL MCP Server
This is a Model Context Protocol (MCP) server that provides access to a MySQL database. It allows agent to execute SQL queries against a MySQL database.
Features
- Execute SQL queries against a MySQL database:
- Read data (SELECT statements)
- Create tables (CREATE TABLE statements)
- Insert data (INSERT INTO statements)
- Update data (UPDATE statements)
- Delete data (DELETE FROM statements)
- Returns query results in JSON format
- Configurable database connection settings
- Transaction logging with unique IDs
Prerequisites
- Node.js (v14 or higher)
- MySQL server
- MCP SDK
Installation
- Clone or download this repository
- Install dependencies:
- Build the server:
Configuration
The MySQL MCP server uses the following environment variables for configuration:
MYSQL_HOST
: MySQL server hostname (default: 'localhost')MYSQL_PORT
: MySQL server port (default: 3306)MYSQL_USER
: MySQL username (default: 'mcp101')MYSQL_PASSWORD
: MySQL password (default: '123qwe')MYSQL_DATABASE
: MySQL database name (default: 'mcpdb')
Database Setup
- Create a MySQL database:
- Create a MySQL user with access to the database:
- Create a test table with sample data:
MCP Configuration
Add the MySQL MCP server to your MCP settings file:
VSCode (Claude Extension)
File: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json
Change the args according your MySQL configuruation
Claude Desktop App
File: ~/Library/Application Support/Claude/claude_desktop_config.json
Usage
Once configured, you can use the MySQL MCP server in your conversations with Claude. For example:
"Can you show me all the users in the test_users table?"
Claude will use the run_sql_query
tool to execute:
Available Tools
run_sql_query
Executes a read-only SQL query (SELECT statements only) against the MySQL database.
Parameters:
query
: The SQL SELECT query to execute.
Example:
create_table
Creates a new table in the MySQL database.
Parameters:
query
: The SQL CREATE TABLE query to execute.
Example:
insert_data
Inserts data into a table in the MySQL database.
Parameters:
query
: The SQL INSERT INTO query to execute.
Example:
update_data
Updates data in a table in the MySQL database.
Parameters:
query
: The SQL UPDATE query to execute.
Example:
delete_data
Deletes data from a table in the MySQL database.
Parameters:
query
: The SQL DELETE FROM query to execute.
Example:
Security Considerations
- Use a dedicated MySQL user with appropriate privileges for the MCP server
- Consider using read-only privileges if you only need to query data
- Store sensitive information like database credentials securely
- All operations are logged with unique transaction IDs for auditing
You must be authenticated.
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
A Model Context Protocol server that allows AI agents to execute SQL queries against a MySQL database, supporting operations like reading data, creating tables, inserting, updating, and deleting records.
Related MCP Servers
- -securityAlicense-qualityA Model Context Protocol (MCP) server that enables AI assistants to interact with MySQL databases by executing SQL queries and checking database connectivity.Last updated -TypeScriptMIT License
- -security-license-qualityA Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.Last updated -MIT License
- -security-license-qualityA Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.Last updated -JavaScript
- -securityFlicense-qualityA Model Context Protocol server that enables AI models to interact with MySQL databases through natural language, supporting SQL queries, table creation, and schema exploration.Last updated -1Python