What can you do with this server?

The MCP-MySQL Server allows AI models to interact with MySQL databases through a standardized interface. You can: * Connect to MySQL databases using URLs, workspace paths (via .env files), or direct credentials * Execute SELECT queries with support for prepared statement parameters * Perform INSERT, UPDATE, or DELETE operations with prepared statement support * List all tables in the connected database * Describe table structures to view columns, types, and other details * Create new tables with specified fields and indexes * Add new columns to existing tables * Prevent SQL injection through prepared statements and secure connection handling * Manage database schema efficiently

How do I use MCP-MySQL Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MCP-MySQL Server list all tables in the database" 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.

@enemyrr/mcp-mysql-server

Q: Which integrations are available for this server?

The MCP server supports reading database configuration from .env files to manage database connection parameters Allows AI models to interact with MySQL databases through a standardized interface, providing operations like querying, executing updates, listing tables, describing table structure, and creating tables

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:

npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claude

Installing Manually

Clone and build the project:

git clone https://github.com/enemyrr/mcp-mysql-server.git cd mcp-mysql-server npm install npm run build

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.

Related MCP server: MySql MCP Server

Database Configuration

You can configure the database connection in three ways:

Database URL in .env (Recommended):

DATABASE_URL=mysql://user:password@host:3306/database

Individual Parameters in .env:

DB_HOST=localhost DB_USER=your_user DB_PASSWORD=your_password DB_DATABASE=your_database

Direct Connection via Tool:

use_mcp_tool({ server_name: "mysql", tool_name: "connect_db", arguments: { url: "mysql://user:password@host:3306/database" // OR workspace: "/path/to/your/project" // Will use project's .env // OR host: "localhost", user: "your_user", password: "your_password", database: "your_database" } });

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.

use_mcp_tool({ server_name: "mysql", tool_name: "query", arguments: { sql: "SELECT * FROM users WHERE id = ?", params: [1] } });

3. execute

Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.

use_mcp_tool({ server_name: "mysql", tool_name: "execute", arguments: { sql: "INSERT INTO users (name, email) VALUES (?, ?)", params: ["John Doe", "john@example.com"] } });

4. list_tables

List all tables in the connected database.

use_mcp_tool({ server_name: "mysql", tool_name: "list_tables" });

5. describe_table

Get the structure of a specific table.

use_mcp_tool({ server_name: "mysql", tool_name: "describe_table", arguments: { table: "users" } });

6. create_table

Create a new table with specified fields and indexes.

use_mcp_tool({ server_name: "mysql", tool_name: "create_table", arguments: { table: "users", fields: [ { name: "id", type: "int", autoIncrement: true, primary: true }, { name: "email", type: "varchar", length: 255, nullable: false } ], indexes: [ { name: "email_idx", columns: ["email"], unique: true } ] } });

7. add_column

Add a new column to an existing table.

use_mcp_tool({ server_name: "mysql", tool_name: "add_column", arguments: { table: "users", field: { name: "phone", type: "varchar", length: 20, nullable: true } } });

8. alter_column

Modify an existing column (type, nullable, default, or rename).

use_mcp_tool({ server_name: "mysql", tool_name: "alter_column", arguments: { table: "users", column: "phone", type: "varchar", length: 50, nullable: false, newName: "phone_number" // optional: rename column } });

9. drop_column

Remove a column from a table.

use_mcp_tool({ server_name: "mysql", tool_name: "drop_column", arguments: { table: "users", column: "phone_number" } });

10. drop_table

Delete a table (requires confirmation).

use_mcp_tool({ server_name: "mysql", tool_name: "drop_table", arguments: { table: "old_table", confirm: true } });

11. truncate_table

Remove all rows from a table (requires confirmation).

use_mcp_tool({ server_name: "mysql", tool_name: "truncate_table", arguments: { table: "logs", confirm: true } });

12. list_databases

List all accessible databases on the server.

13. get_indexes

List all indexes on a table.

use_mcp_tool({ server_name: "mysql", tool_name: "get_indexes", arguments: { table: "users" } });

14. get_foreign_keys

List all foreign key relationships for a table.

use_mcp_tool({ server_name: "mysql", tool_name: "get_foreign_keys", arguments: { table: "orders" } });

MCP Resources

Browse database schema as resources:

URI	Description
`mysql://schema`	Database overview (table count, size)
`mysql://tables`	List all tables with metadata
`mysql://tables/{name}`	Table details (columns, indexes, FKs)
`mysql://tables/{name}/columns`	Column definitions
`mysql://tables/{name}/indexes`	Index definitions
`mysql://tables/{name}/sample`	Sample 5 rows from table

MCP Prompts

Pre-built prompts for common operations:

Prompt	Description
`generate-select`	Build SELECT query for a table
`generate-insert`	Generate INSERT template
`generate-update`	Generate UPDATE template
`explain-schema`	Natural language schema explanation
`suggest-indexes`	Index recommendations for a table

Features

14 database tools for queries, schema management, and more
MCP Resources for browsing database schema
MCP Prompts for generating SQL queries
Multiple connection methods (URL, workspace, direct)
Secure connection handling with automatic cleanup
Prepared statement support for query parameters
Comprehensive error handling and validation
TypeScript support

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

Install Server

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

Resources

Need Help?

Report Issue

Reddit Discussion

Related Servers

MCP-MySQL Server