This MCP server, developed by enemyrr, provides a standardized interface for MySQL database operations. Built with TypeScript and leveraging the Model Context Protocol SDK, it offers tools for executing queries, managing database schemas, and performing CRUD operations. The implementation focuses on security, with features like prepared statements and secure password handling. It supports multiple connection methods and includes comprehensive error handling. By connecting AI models with MySQL databases, this server enables sophisticated data manipulation and retrieval scenarios, making it particularly useful for applications and AI assistants that require structured data access or need to interact with existing MySQL-based systems.
No reviews yet. Be the first to review!
Sign in to join the conversation
Connect to MySQL database using URL, workspace path, or direct credentials.
Execute SELECT queries with optional prepared statement parameters.
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.
List all tables in the connected database.
Get the structure of a specific table.
Create a new table with specified fields and indexes.
Add a new column to an existing table.
