mcp-server-mysql
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 for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.
The MCP Server for MySQL based on NodeJS is designed to facilitate interaction between large language models (LLMs) and MySQL databases. It allows LLMs to inspect database schemas and execute SQL queries, providing a robust interface for database management. The server supports both read and write operations, with configurable permissions to ensure security. It includes features for performance optimization, security, and monitoring, making it a comprehensive solution for managing MySQL databases in conjunction with LLMs.
Features
- Supports SQL query execution with optional write operations (INSERT, UPDATE, DELETE) based on configuration.
- Provides comprehensive database information including table schemas, column names, data types, and foreign key relationships.
- Includes security features like SQL injection prevention, query whitelisting/blacklisting, and rate limiting.
- Offers performance optimizations such as connection pooling, query result caching, and large result set streaming.
- Enables monitoring and debugging with query logging, performance metrics, and error tracking.
Tools
mysql_query
Execute SQL queries against the connected database with support for prepared statements and transaction handling.
