MCP-MySQL-server-implementation
0
The project is a Model Context Protocol server for MySQL databases built on NodeJS, designed to facilitate database schema inspection and SQL query execution by LLMs. It offers robust features like multi-DB mode, schema-specific permissions, and performance optimizations with strong security features.
MCP Server for MySQL based on NodeJS
A Model Context Protocol server providing access to MySQL databases, allowing LLMs to inspect schemas and execute SQL queries.
Features
- Node.js and MySQL 5.7+ required
- Multi-DB mode and schema-specific permissions
- SQL operations: READ, INSERT, UPDATE, DELETE (configurable)
- Security: SQL injection prevention, transactional handling, query complexity analysis
- Performance: Connection pooling, query caching, optimized large dataset handling
Installation Methods
- Claude Desktop
- Cursor
- Smithery
- MCP Get
- NPM/PNPM
Contributions welcome via GitHub.