Skip to main content
Glama

MySQL MCP Server

MySQL MCP Server

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

Authentication

The server supports MySQL authentication through the database URL. The URL format is:

mysql://username:password@host:port/database

Examples:

  • DB: mysql://user:pass@localhost:3306/mydb

Note: Always ensure your credentials are properly secured and not exposed in public configurations.

Components

Tools

  • query
    • Execute read-only SQL queries against the connected database
    • Input: sql (string): The SQL query to execute
    • All queries are executed within a READ ONLY transaction
    • Authentication is handled automatically using the provided credentials

Resources

The server provides schema information for each table in the database:

  • Table Schemas (mysql://<host>/<table>/schema)
    • JSON schema information for each table
    • Includes column names and data types
    • Automatically discovered from database metadata
    • Access is authenticated using the provided credentials

Installation

  1. Clone the repository:
git clone https://github.com/yourusername/mysql-mcp-server.git cd mysql-mcp-server
  1. Prepare and install dependencies:
npm run prepare npm install
  1. Create a global link:
npm link

Now you can use the mysql-mcp-server command from anywhere in your terminal:

mysql-mcp-server mysql://user:password@localhost:3306/mydb

Usage with Cursor

Configuring MCP in Cursor

  1. Open Cursor's settings:
    • Click on the gear icon (⚙️) in the bottom left corner of Cursor
    • Or press Shift + Cmd + J on macOS
  2. Configure MCP Server:
    • Click on "MCP" in the left sidebar
    • Click on "Add Global MCP Server"
    • Add the following configuration:
{ "mcpServers": { "mysql": { "command": "mysql-mcp-server", "args": ["mysql://user:password@localhost:3306/mydb"] } } }
  1. Save the configuration:
    • Click "Save" or press Cmd + S
    • Restart Cursor for the changes to take effect

How to use it on Cursor?

Open the Agentic chat on Cursor and start asking questions related to our DB and it will have all the context ezgif-3bb869e455a41b

Security Best Practices

  1. Use environment variables for sensitive credentials:
    { "mcpServers": { "mysql": { "command": "mysql-mcp-server", "args": ["mysql://${MYSQL_USER}:${MYSQL_PASSWORD}@host:3306/mydb"] } } }
  2. Ensure the MySQL user has minimal required permissions (READ-ONLY access)
  3. Use strong passwords and follow security best practices
  4. Avoid committing configuration files with credentials to version control

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.

-
security - not tested
F
license - not found
-
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 providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

  1. Authentication
    1. Components
      1. Tools
      2. Resources
    2. Installation
      1. Usage with Cursor
        1. Configuring MCP in Cursor
        2. How to use it on Cursor?
        3. Security Best Practices
      2. License

        Related MCP Servers

        • -
          security
          F
          license
          -
          quality
          A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
          Last updated 5 months ago
          JavaScript
        • -
          security
          A
          license
          -
          quality
          A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
          Last updated 9 days ago
          7,107
          657
          JavaScript
          MIT License
          • Linux
          • Apple
        • -
          security
          A
          license
          -
          quality
          A Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
          Last updated 4 months ago
          2
          1
          TypeScript
          MIT License
          • Linux
          • Apple
        • -
          security
          A
          license
          -
          quality
          A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
          Last updated 5 months ago
          7,107
          MIT License

        View all related MCP servers

        MCP directory API

        We provide all the information about MCP servers via our MCP API.

        curl -X GET 'https://glama.ai/api/mcp/v1/servers/shreyansh-ghl/mysql-mcp-server'

        If you have feedback or need assistance with the MCP directory API, please join our Discord server