Read Only Local Mysql MCP server
{
"mcpServers": {
"hove-read-only-local-mysql": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}{
"mcpServers": {
"hove-read-only-local-mysql": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}{
"mcpServers": {
"hove-read-only-local-mysql": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}{
"servers": {
"hove-read-only-local-mysql": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "${input:db_host}",
"DB_DATABASE": "${input:db_database}",
"DB_USERNAME": "${input:db_username}",
"DB_PASSWORD": "${input:db_password}"
}
}
},
"inputs": [
{
"id": "db_host",
"type": "promptString",
"description": "Db host",
"password": true
},
{
"id": "db_database",
"type": "promptString",
"description": "Db database",
"password": true
},
{
"id": "db_username",
"type": "promptString",
"description": "Db username",
"password": true
},
{
"id": "db_password",
"type": "promptString",
"description": "Db password",
"password": true
}
]
}{
"mcpServers": {
"hove-read-only-local-mysql": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}file .mcp.json (in your project root)file claude_desktop_config.jsonfile ~/.cursor/mcp.jsonfile .vscode/mcp.jsonfile ~/.codeium/windsurf/mcp_config.jsoninstall npx -y @hovecapital/read-only-mysql-mcp-serverversion 0.1.1
What it does
An MCP server that allows Claude Desktop and Claude Code to query MySQL databases using natural language. It supports read-only operations (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN) with built-in security validation and returns results as JSON.
- Ask Claude to retrieve data from your MySQL database using natural language without writing SQL directly.
- Explore your database schema by having Claude describe tables, columns, and relationships.
- Generate reports or summaries from your database by asking Claude to query and analyze the data.
Tools this server exposes
| Tool | Does |
|---|---|
| query_database | Execute read-only SQL queries (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN) against a configured MySQL database and receive JSON-formatted results. |
Before you enable it
An MCP server runs with whatever access you give it. Start with a development account rather than production, and check which tools the server exposes before you let an agent call them unattended.