Supports configuration through environment variables in .env files, allowing database connection details to be securely stored and accessed.
Enables querying and managing MySQL databases with support for SELECT, INSERT, UPDATE, and DELETE operations, as well as schema management through table listing, creation, description, and column addition.
@enemyrr/mcp-mysql-server
A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.
Installation & Setup for Cursor IDE
Installing via Smithery
To install MySQL Database Server for Claude Desktop automatically via Smithery:
Installing Manually
Clone and build the project:
Add the server in Cursor IDE settings:
Open Command Palette (Cmd/Ctrl + Shift + P)
Search for "MCP: Add Server"
Fill in the fields:
Name:
mysql
Type:
command
Command:
node /absolute/path/to/mcp-mysql-server/build/index.js
Note: Replace
/absolute/path/to/
with the actual path where you cloned and built the project.
Database Configuration
You can configure the database connection in three ways:
Database URL in .env (Recommended):
Individual Parameters in .env:
Direct Connection via Tool:
Available Tools
1. connect_db
Connect to MySQL database using URL, workspace path, or direct credentials.
2. query
Execute SELECT queries with optional prepared statement parameters.
3. execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.
4. list_tables
List all tables in the connected database.
5. describe_table
Get the structure of a specific table.
6. create_table
Create a new table with specified fields and indexes.
7. add_column
Add a new column to an existing table.
Features
Multiple connection methods (URL, workspace, direct)
Secure connection handling with automatic cleanup
Prepared statement support for query parameters
Schema management tools
Comprehensive error handling and validation
TypeScript support
Automatic workspace detection
Security
Uses prepared statements to prevent SQL injection
Supports secure password handling through environment variables
Validates queries before execution
Automatically closes connections when done
Error Handling
The server provides detailed error messages for:
Connection failures
Invalid queries or parameters
Missing configuration
Database errors
Schema validation errors
Contributing
Contributions are welcome! Please feel free to submit a Pull Request to https://github.com/enemyrr/mcp-mysql-server
License
MIT
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
A 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.
Related MCP Servers
- AsecurityAlicenseAqualityA 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 -5283MIT License
- AsecurityAlicenseAqualityA Model Context Protocol server that enables AI models to interact with both MySQL and MongoDB databases through a standardized interface, supporting comprehensive database operations including queries, schema management, and CRUD operations.Last updated -146MIT License
- -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 -3
- AsecurityFlicenseAqualityA 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.Last updated -62887