MySQL MCP Server
Provides tools for connecting to MySQL databases, executing SQL queries with prepared statements, listing databases and tables, inspecting table schemas, and managing database connections with connection pooling support.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MySQL MCP Server show me the schema for the users table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MySQL MCP Server
A Model Context Protocol (MCP) server for MySQL database integration with Cursor IDE. This server provides tools to connect to, query, and manage MySQL databases directly from Cursor.
Features
π Easy Connection: Connect to MySQL databases with simple configuration
π Query Execution: Run SQL queries and get structured results
π Database Management: List databases, tables, and table schemas
π‘οΈ Secure: Supports SSL connections and prepared statements
β‘ Performance: Connection pooling for optimal performance
π― TypeScript: Fully typed for better development experience
Related MCP server: MySQL MCP
Installation
From npm (recommended)
npm install -g @ashenud/mcp-mysql-serverFrom source
git clone https://github.com/ashenud/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build
npm linkUsage
Cursor IDE Configuration
Add the following to your Cursor MCP settings:
{
"mcpServers": {
"mysql": {
"command": "@ashenud/mcp-mysql-server",
"args": [],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "your_username",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "your_database"
}
}
}
}Available Tools
1. mysql_connect
Connect to a MySQL database.
Parameters:
host(string, optional): MySQL host (default: "localhost")port(number, optional): MySQL port (default: 3306)user(string, required): MySQL usernamepassword(string, required): MySQL passworddatabase(string, optional): Database namessl(boolean, optional): Use SSL connection (default: false)connectionLimit(number, optional): Connection pool limit (default: 10)
Example:
{
"name": "mysql_connect",
"arguments": {
"host": "localhost",
"port": 3306,
"user": "myuser",
"password": "mypassword",
"database": "mydb",
"ssl": false
}
}2. mysql_query
Execute a SQL query.
Parameters:
query(string, required): SQL query to executeparams(array, optional): Query parameters for prepared statements
Example:
{
"name": "mysql_query",
"arguments": {
"query": "SELECT * FROM users WHERE age > ?",
"params": ["25"]
}
}3. mysql_list_databases
List all available databases.
Example:
{
"name": "mysql_list_databases",
"arguments": {}
}4. mysql_list_tables
List tables in a database.
Parameters:
database(string, optional): Database name (uses current if not provided)
Example:
{
"name": "mysql_list_tables",
"arguments": {
"database": "mydb"
}
}5. mysql_describe_table
Get table structure and schema information.
Parameters:
table(string, required): Table namedatabase(string, optional): Database name (uses current if not provided)
Example:
{
"name": "mysql_describe_table",
"arguments": {
"table": "users",
"database": "mydb"
}
}6. mysql_disconnect
Close the MySQL connection.
Example:
{
"name": "mysql_disconnect",
"arguments": {}
}Development
Prerequisites
Node.js 18.0.0 or higher
npm or yarn
Setup
Clone the repository:
git clone https://github.com/ashenud/mcp-mysql-server.git
cd mcp-mysql-serverInstall dependencies:
npm installBuild the project:
npm run buildRun in development mode:
npm run devTesting
Run the test suite:
npm testConfiguration
The server can be configured through environment variables or by passing parameters to the mysql_connect tool:
MYSQL_HOST: Default MySQL hostMYSQL_PORT: Default MySQL portMYSQL_USER: Default MySQL usernameMYSQL_PASSWORD: Default MySQL passwordMYSQL_DATABASE: Default database nameMYSQL_SSL: Use SSL connection (true/false)
Security Considerations
Always use strong passwords for database connections
Enable SSL for production environments
Use connection pooling to limit concurrent connections
Validate and sanitize all user inputs before executing queries
Consider using read-only database users for MCP connections
Error Handling
The server provides detailed error messages for common issues:
Connection failures
Invalid SQL queries
Authentication errors
Database access permissions
Network timeouts
Contributing
Fork the repository
Create a feature branch:
git checkout -b feature-nameMake your changes and add tests
Commit your changes:
git commit -am 'Add some feature'Push to the branch:
git push origin feature-nameSubmit a pull request
License
MIT License - see LICENSE file for details.
Support
π§ Email: udithamal.lk@gmail.com
π Issues: GitHub Issues
π Documentation: GitHub Wiki
Changelog
1.0.0
Initial release
Basic MySQL connection and query functionality
Database and table listing
Table schema inspection
Connection pooling support
SSL connection support
Available Tools
8 toolsmysql_connectC
Connect to a MySQL database
Inputs: user (required), password (required), host, port, +3 more.
mysql_describe_tableB
Get table structure and schema information
Inputs: table (required), database.
mysql_disconnectB
Close the MySQL connection
Inputs: no named parameters.
mysql_list_databasesB
List all available databases
Inputs: no named parameters.
mysql_list_tablesC
List tables in the current database
Inputs: database.
mysql_queryC
Execute a MySQL query
Inputs: query (required), params.
mysql_setup_persistentC
Set up persistent connection with default credentials
Inputs: user (required), password (required), host, port, +3 more.
mysql_statusB
Check connection status and database info
Inputs: no named parameters.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
TDQS
Scored across 8 tools
Each tool has a clearly distinct purpose with no overlap: connection management (connect, disconnect, status, setup_persistent), metadata listing (databases, tables, describe_table), and query execution (query). The descriptions make it easy to tell them apart, with no ambiguity in their functions.
All tool names follow a consistent 'mysql_verb_noun' pattern (e.g., mysql_connect, mysql_describe_table, mysql_list_databases). This predictable naming scheme makes it easy for agents to understand and navigate the tool set without confusion.
With 8 tools, this server is well-scoped for MySQL database operations. It covers essential functions like connection handling, metadata exploration, and query execution, with each tool earning its place without feeling bloated or insufficient.
The tool set provides solid coverage for core MySQL workflows: connection lifecycle, database/table listing, schema inspection, and query execution. A minor gap is the lack of tools for more advanced operations like transaction management or user administration, but agents can work around this using the query tool.
Maintenance
Related MCP Connectors
Connect to PlanetScale databases, branches, schema, query insights, and execute SQL
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view detβ¦
Query Postgres, MySQL, SQL Server, Oracle, BigQuery, ClickHouse and Redshift from your AI client.
Query, explore, and manage your databases through natural conversation.
Related MCP Servers
- FlicenseAqualityDmaintenanceA tool that provides simple API to execute SQL queries and manage MySQL databases, designed to integrate with Cursor IDE for AI assistants to directly perform database operations.83-
- FlicenseNot gradedqualityDmaintenanceEnables management and querying of multiple MySQL databases through natural language, allowing AI assistants to list databases, execute SQL queries, and explore database schemas.1-
- FlicenseNot gradedqualityNot gradedmaintenanceEnables direct interaction with MySQL databases through SQL queries, table exploration, and schema inspection with support for prepared statements and connection pooling.-
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to interact with MySQL databases by executing SQL queries, describing table schemas, and listing tables. It provides seamless database integration for tools like Cursor through the Model Context Protocol.798 npmMIT