MySQL MCP Server
Provides MySQL database connectivity with tools for querying table schemas and structures in MySQL databases.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MySQL MCP Server show me the schema for the users table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MySQL MCP Server
A Model Context Protocol (MCP) server that provides MySQL database connectivity and tools.
Installation
npm install
npm run buildRelated MCP server: MySQL Managing MCP
Usage
Configuration
The server can be configured using either environment variables or command-line arguments. Environment variables take precedence over command-line arguments.
Environment Variables
MYSQL_HOST: MySQL host (default: localhost)MYSQL_PORT: MySQL port (default: 3306)MYSQL_USER: MySQL user (default: root)MYSQL_PASSWORD: MySQL password (default: empty)MYSQL_DATABASE: MySQL database (default: test)
Command-Line Arguments
-h, --host: MySQL host (default: localhost)-p, --port: MySQL port (default: 3306)-u, --user: MySQL user (default: root)-P, --password: MySQL password (default: empty)-d, --database: MySQL database (default: test)
Examples
Basic usage with default settings:
crimson-mysql-mcpSpecify custom host and database:
crimson-mysql-mcp --host db.example.com --database myappUsing short flags:
crimson-mysql-mcp -h 192.168.1.100 -u myuser -P mypass -d productionClaude Desktop Configuration
Using environment variables (recommended):
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"crimson-mysql-mcp@1.0.2"
],
"env": {
"MYSQL_HOST": "your-mysql-host",
"MYSQL_PORT": "3306",
"MYSQL_USER": "your-username",
"MYSQL_PASSWORD": "your-password",
"MYSQL_DATABASE": "your-database"
}
}
}
}For local development:
{
"mcpServers": {
"mysql": {
"command": "node",
"args": [
"/path/to/your/crimson-mysql-mcp/build/index.js"
],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_USER": "root",
"MYSQL_DATABASE": "test"
}
}
}
}Available Tools
get-schema: Get the schema/structure of a MySQL table
Parameters:
schemaName(string) - The name of the table to describe
Development
# Install dependencies
npm install
# Run in development mode
npm run server:dev
# Build the project
npm run build
# Watch and rebuild on changes
npm run server:build:watch
# Run with MCP Inspector (for debugging)
npm run server:inspectPublishing to npm
To make this package available via npx:
Update the package.json with your npm account details
Run:
npm publish
License
ISC
Available Tools
1 toolget-schemaARead-only
Get the schema of a table
Inputs: schemaName (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 1 tool
With only one tool, there is no possibility of ambiguity or overlap between tools. The single tool has a clear, distinct purpose focused on retrieving table schema information.
A single tool inherently has perfect naming consistency, as there are no other tools to compare against. The tool name 'get-schema' follows a clear verb-noun pattern and uses kebab-case consistently (though this is trivial with one tool).
A MySQL server with only one tool is severely under-scoped for its domain. MySQL involves operations like querying, inserting, updating, deleting, managing connections, and handling transactions, so a single schema retrieval tool represents an extreme mismatch with the expected functionality.
The tool surface is severely incomplete for a MySQL server. It lacks basic CRUD operations (create, read, update, delete), query execution, connection management, and other essential database functions, making it impossible for agents to perform meaningful database interactions.
Maintenance
Related MCP Connectors
Connect to PlanetScale databases, branches, schema, query insights, and execute SQL
MySQL change tracking with instant row-level recovery and forensic attribution for compliance.
PostgreSQL, MySQL, OpenAPI/Swagger, and shared Agent Memory with scoped access.
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…
Related MCP Servers
- FlicenseNot gradedqualityNot gradedmaintenanceEnables direct interaction with MySQL databases through SQL queries, table exploration, and schema inspection with support for prepared statements and connection pooling.-
- FlicenseNot gradedqualityDmaintenanceEnables interaction with MySQL databases through tools for listing tables, querying table schemas, executing queries, viewing indexes, and analyzing query execution plans.-
- AlicenseNot gradedqualityDmaintenanceEnables interaction with MySQL databases through connection management, SQL execution, and schema exploration. It features multi-connection support and a safety-focused 'dangerous mode' for write operations.27 npm4MIT
- AlicenseNot gradedqualityDmaintenanceEnables safe querying and optional writing to MySQL databases via MCP tools, with support for schema inspection, connection management, and read-only mode.28 npm3MIT