mysql-crud-mcp-server
Verified Safeby Nicolas-Gong
Overview
Provides a Model Context Protocol (MCP) server plugin for performing standard CRUD (Create, Read, Update, Delete) operations on a MySQL database.
Installation
node build/index.jsEnvironment Variables
- MYSQL_HOST
- MYSQL_PORT
- MYSQL_USER
- MYSQL_PASSWORD
- MYSQL_DATABASE
Security Notes
The server correctly utilizes parameterized queries with 'mysql2/promise' to prevent SQL injection. Database credentials are loaded from environment variables, avoiding hardcoding. As an MCP server running locally and communicating via stdio, its direct network attack surface is minimal, limited to the MySQL connection itself. The primary security consideration falls on the generated SQL queries and parameters from the caller (e.g., LLM agent) to ensure they are always parameterized.
Similar Servers
mcp-mysql-server
Provides an MCP-compliant interface for AI models to securely interact with a MySQL database for CRUD operations, schema inspection, and performance analysis.
postgres-mysql-mcp-server
A Model Context Protocol (MCP) server that enables AI assistants to query PostgreSQL and MySQL databases for schema introspection and data retrieval.
mysql_mcp_server
This server provides a Model Context Protocol (MCP) interface to a MySQL database, enabling AI models to execute SQL queries and retrieve database schema information.
mcp_sql_demo
Provides secure, multi-database access for LLMs to inspect MySQL schemas and execute SQL queries, supporting both read and configurable write operations with fine-grained schema-specific permissions.