mcp-mysql-server
8
mcp-mysql-server is a MySQL database operation server that facilitates interaction between AI models and MySQL databases through a standardized protocol. It features robust security, multi-user support, and efficient handling of connections and databases.
mcp-mysql-server
A MySQL database server based on the Model Context Protocol that enables AI models to interact with MySQL databases through a standardized interface.
Features
- Multi-user concurrency support
- Efficient connection pool management
- Request-level isolation
- Detailed logging
- Enhanced error handling
- Performance optimization
- Automatic database connection
- Secure credential handling
- Supports TypeScript
Available Tools
- connect_db: Establishes a connection using provided credentials
- query: Executes SELECT queries with optional parameters
- list_tables: Lists all tables in the connected database
- describe_table: Provides the structure of a specific table
Deployment Modes
- Local execution
- Remote URL access
Performance
- Supports up to 50 concurrent connections
- Connection pool management enhances resource use
- Request tracing and performance monitoring
Security
- Prepared statements to prevent SQL injection
- Encrypted credential handling
- Query validation and automatic connection closure