A
security-
licenseA
qualityThis server enables AI models to interact with MySQL databases through a standardized interface.
Last updated -
283
114
MIT License
Uses .ENV files for configuration of MySQL connection details including host, username, password, and database name
Provides direct access to MySQL databases, allowing execution of SQL queries, table management, and storage of notes with title and content in a MySQL database
Runs on Node.js runtime (version 18 or higher) as the execution environment for the MCP server
MySQL MCP Server
A powerful MCP server that provides direct access to MySQL databases. This server enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.
Features
Resources
Access notes stored in the database via
note:///{id}URIsEach note has a title and content
Plain text mime type for simple content access
Tools
create_note- Create new text notes in the databaseTakes title and content as required parameters
Stores note in the MySQL database
list_tables- List all tables in the connected databasecount_tables- Get the total number of tables in the databasesearch_tables- Search for tables using LIKE patterndescribe_table- Get the structure of a specific tableexecute_sql- Execute custom SQL queries
Prerequisites
Node.js 18 or higher
MySQL server installed and running
A database with appropriate permissions
Setup
Clone this repository:
git clone git@github.com:LeonMelamud/mysql-mcp.git cd mysql-mcpInstall dependencies:
npm installCreate a
.envfile in the root directory with your MySQL connection details:MYSQL_HOST=localhost MYSQL_USER=your_username MYSQL_PASSWORD=your_password MYSQL_DATABASE=your_databaseBuild the server:
npm run build
Installation
For Claude Desktop
Add the server config to your Claude Desktop configuration file:
On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"mysql": {
"command": "node",
"args": ["/path/to/mysql-server/build/index.js"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "your_username",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "your_database"
}
}
}
}
For Cline
Add the server config to your Cline MCP settings file:
On MacOS: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json
On Windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json
{
"mcpServers": {
"mysql": {
"command": "node",
"args": ["/path/to/mysql-server/build/index.js"],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "your_username",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "your_database"
},
"disabled": false,
"autoApprove": []
}
}
}
Usage Examples
Once installed, you can use the MySQL MCP server in your conversations with Claude:
List all tables in the database
Please list all the tables in my MySQL database.
Execute a SQL query
Run this SQL query: SELECT * FROM users LIMIT 5
Create a note
Create a note titled "Meeting Notes" with the content "Discussed project timeline and assigned tasks."
Development
For development with auto-rebuild:
npm run watch
Debugging
Use the MCP Inspector to debug the server:
npm run inspector
The Inspector will provide a URL to access debugging tools in your browser.
License
MIT
This server cannot be installed
Related Resources
Related MCP Servers
- Asecurity-licenseAqualityEnables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.Last updated -73627
- -security-license-qualityA server that enables AI models to interact with MySQL databases through a Model Control Protocol, providing tools for table creation, schema inspection, query execution, and data retrieval.Last updated -28MIT License
- -security-license-qualityEnables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.Last updated -
Appeared in Searches
- A tool for comparing design documents and source code, and accumulating business knowledge
- Exploring MySQL Database Information
- Information about MySQL database management system
- An open-source relational database management system
- Connect to MySQL server, edit database structure, and run manual migrations