mysql-mcp-server
Verified Safeby yukihito-jokyu
Overview
A Model Context Protocol (MCP) server providing read-only access to MySQL database schema information and sample data for LLM agents or backend development.
Installation
npx -y @yukihito/mysql-mcp-server@latest --host localhost --port 3306 --name your_username --password your_password --database your_databaseEnvironment Variables
- DB_HOST
- DB_PORT
- DB_USER
- DB_PASSWORD
- DB_DATABASE
Security Notes
The server is explicitly designed for read-only operations, preventing any data modification (INSERT, UPDATE, DELETE). It uses parameterized queries (e.g., `DESCRIBE ??`, `SELECT * FROM ?? LIMIT 5`) in `src/lib/database.ts` to prevent SQL injection for table names. Database credentials are passed via CLI arguments, which is less secure than environment variables for highly sensitive production environments but is a common pattern for local MCP client configurations.
Similar Servers
mysql-mcp-server
Acts as a read-only MySQL server proxy that exposes database introspection and query execution tools to AI clients via the Model Context Protocol (MCP) or a REST API.
mcp_ohmy_sql-project
A Model Context Protocol (MCP) server that connects AI assistants to various SQL databases, providing intelligent query optimization, schema introspection, and secure, token-efficient data interaction.
mcp-server
A Model Context Protocol (MCP) server that provides real-time Indian options market data and volatility analytics from GetOutpost.in for integration with AI chat models like Claude.
MCP-SERVER
Provides an MCP server for automated data analysis workflows including loading datasets, cleaning data, sentiment analysis, clustering, topic extraction, and generating comprehensive reports with visualizations for an AI client.