mcp-server-mysql
401
This project is an MCP server allowing seamless integration with MySQL databases for querying and schema access, leveraging NodeJS. It supports complex configurations for multi-database environments, provides schema-specific permissions, and ensures high performance and security.
MCP Server for MySQL based on NodeJS
A Model Context Protocol server providing access to MySQL databases, supporting LLMs to inspect database schemas and execute SQL queries.
Requirements
- Node.js v18 or higher
- MySQL 5.7 or higher (MySQL 8.0+ recommended)
- MySQL user with appropriate permissions
Features
- Execute SQL queries (READ ONLY by default)
- Schema-specific permissions
- Multi-DB Mode
- Security features: SQL injection prevention, query whitelisting
- Performance optimizations: connection pooling, query caching
Installation
- Recommended: visit Smithery
- Manual: install with npm or pnpm, and configure your LLM application
Configuration
- Automatic with Smithery
- Advanced options for performance, security, and monitoring
Testing
- Set up test databases and run test suite for reliability
Contributions
Contributions are welcome via GitHub