MCP cover image
See in Github
2025-03-26

镜像://github.com/shreyansh-ghl/mysql-mcp-server

0

Github Watches

1

Github Forks

0

Github Stars

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.

相关推荐

  • NiKole Maxwell
  • I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

  • Bora Yalcin
  • Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.

  • Yusuf Emre Yeşilyurt
  • I find academic articles and books for research and literature reviews.

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • https://maiplestudio.com
  • Find Exhibitors, Speakers and more

  • Carlos Ferrin
  • Encuentra películas y series en plataformas de streaming.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • Alexandru Strujac
  • Efficient thumbnail creator for YouTube videos

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • lumpenspace
  • Take an adjectivised noun, and create images making it progressively more adjective!

  • apappascs
  • 发现市场上最全面,最新的MCP服务器集合。该存储库充当集中式枢纽,提供了广泛的开源和专有MCP服务器目录,并提供功能,文档链接和贡献者。

  • ShrimpingIt
  • MCP系列GPIO Expander的基于Micropython I2C的操作,源自ADAFRUIT_MCP230XX

  • modelcontextprotocol
  • 模型上下文协议服务器

  • Mintplex-Labs
  • 带有内置抹布,AI代理,无代理构建器,MCP兼容性等的多合一桌面和Docker AI应用程序。

    Reviews

    1 (1)
    Avatar
    user_UiSR2U90
    2025-04-16

    I've been using shreyansh-ghl_mysql-mcp-server from MCP-Mirror, and it's incredibly efficient for managing MySQL databases. The user-friendly interface and seamless performance make it an essential tool for any developer working with MySQL. Highly recommend checking it out at https://github.com/MCP-Mirror/shreyansh-ghl_mysql-mcp-server!