M
MySQL
Query MySQL databases and inspect schemas.
·No reviews yet
Share:
About
Auto-generated
MySQL is a Model Context Protocol server in the Data & Databases category. It lets AI assistants that speak MCP call its tools and read its resources over STDIO.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about MySQL.
- What is the primary function of the MySQL MCP?
- This MCP allows you to query MySQL databases and inspect their schemas. It provides a standardized interface for interacting with MySQL instances, enabling data retrieval and structural examination.
- How do I configure this MCP in a client application?
- Configuration typically involves providing the necessary connection details for your MySQL database, such as host, port, username, and database name. The API key is also required for authentication with the MCP server.
- Does this MCP require an API key for authentication?
- Yes, this MySQL MCP uses an API key for authentication. You will need to obtain and provide a valid API key when setting up the connection in your MCP client.
- What capabilities does the MySQL MCP expose?
- The MCP exposes capabilities for executing SQL queries against a MySQL database and for inspecting the database schema. This includes listing tables, describing table structures, and retrieving data.
- What are the licensing considerations for this MySQL MCP?
- This MCP is provided by the Community and is hosted on GitHub, suggesting an open-source license. The specific license details can be found in the project's repository.
- What is a common gotcha when using the MySQL MCP?
- A common gotcha is ensuring proper network connectivity and firewall rules are configured to allow the MCP to reach your MySQL database. Incorrect connection parameters or restricted access can lead to connection failures.
Install MySQL
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"mysql": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.