Skip to main content
Glama
Sign In
enesjakozh

MCP MySQL Server

by kevinbin
GitHub
JavaScript
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

@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:

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

Installing Manually

  1. Clone and build the project:
git clone https://github.com/enemyrr/mcp-mysql-server.git cd mcp-mysql-server npm install npm run build
  1. 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:

  1. Database URL in .env (Recommended):
DATABASE_URL=mysql://user:password@host:3306/database
  1. Individual Parameters in .env:
DB_HOST=localhost DB_USER=your_user DB_PASSWORD=your_password DB_DATABASE=your_database
  1. 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 } } });

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

This server cannot be installed

-
security - not tested
-
license - not tested
-
quality - not tested

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.

  1. Installation & Setup for Cursor IDE
    1. Installing via Smithery
    2. Installing Manually
  2. Database Configuration
    1. Available Tools
      1. 1. connect_db
      2. 2. query
      3. 3. execute
      4. 4. list_tables
      5. 5. describe_table
      6. 6. create_table
      7. 7. add_column
    2. Features
      1. Security
        1. Error Handling
          1. Contributing
            1. License

              Related MCP Servers

              • MCP MySQL Server

                Atomzzm
                -
                security
                -
                license
                -
                quality
                A 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

              • MCP-MongoDB-MySQL-Server

                yaoxiaolinglong
                -
                security
                -
                license
                -
                quality
                A 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 -
                6
                JavaScript
                MIT License

              • MySQL MCP Server

                caicongyang
                -
                security
                F
                license
                -
                quality
                A 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 -
                1
                Python
                • Linux
                • Apple

              • MySQL MCP Server

                michael7736
                A
                security
                F
                license
                A
                quality
                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.
                Last updated -
                6
                695
                1
                JavaScript
                • Apple

              View all related MCP servers

              New MCP Servers

              ID: 797h9pqb5m