mcp-server-mysql

mcp-server-mysql

3.2

If you are the rightful owner of mcp-server-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

The MCP Server for MySQL based on NodeJS is designed to facilitate read-only interactions with MySQL databases. It allows Language Model Machines (LLMs) to access and query database schemas securely and efficiently. The server supports various installation methods, including Smithery, MCP Get, and manual installation via npm or pnpm. It offers robust security features, performance optimizations, and comprehensive monitoring and debugging tools. The server is highly configurable, allowing users to tailor its behavior to their specific needs, including connection settings, performance tuning, and security configurations. It also provides tools for executing read-only SQL queries and resources for accessing detailed database schema information.

Features

  • SQL injection prevention through prepared statements
  • Optimized connection pooling and query result caching
  • Comprehensive query logging and performance metrics collection
  • Rate limiting and query complexity analysis
  • Configurable connection encryption and read-only transaction enforcement