shreyansh-ghl_mysql-mcp-server

shreyansh-ghl_mysql-mcp-server

0
databases

The MySQL MCP Server is a tool that enables read-only access to MySQL databases in a secure manner. It allows inspection of database schemas and execution of queries, specifically designed for integration with LLMs. The server emphasizes authentication and security best practices.

MySQL MCP Server

A Model Context Protocol server offering read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

Features

  • Authentication: Supports MySQL authentication via database URL.
  • Tools:
    • query: Executes read-only SQL queries.
    • Resources: Provides JSON schema information for tables.

Installation

  1. Clone the repository and navigate into it.
  2. Prepare and install dependencies.
  3. Create a global link for terminal use.

Usage with Cursor

  • Configure MCP in Cursor settings to add the MySQL MCP server.
  • Save configuration and restart Cursor for changes to take effect.

Security Best Practices

  • Use environment variables for credentials.
  • Ensure minimal required permissions.
  • Use strong passwords and avoid committing sensitive information.

License

Licensed under the MIT License.