Mysql MCP Server vs Read Only Local Mysql MCP Server
A side-by-side look at the Mysql MCP Server and Read Only Local Mysql MCP Server MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Mysql MCP Server for databases work as a local process; choose Read Only Local Mysql MCP Server for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose Mysql MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You have the keys it needs:
MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD. - You want tools like
execute_sql, get_schema_info, get_table_sample.
Choose Read Only Local Mysql MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You have the keys it needs:
DB_HOST, DB_PORT, DB_DATABASE, DB_USERNAME, DB_PASSWORD, DB_ALLOWED_HOSTS. - You want tools like
connect, disconnect, query.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 56/100 · Good | 60/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | Not declared |
| Pricing | Free | Not declared |
| Required env vars | MYSQL_HOSTMYSQL_USERMYSQL_PASSWORD | DB_HOSTDB_PORTDB_DATABASEDB_USERNAMEDB_PASSWORDDB_ALLOWED_HOSTS |
| Verified owner | Community listing | Community listing |
| GitHub stars | 1,400 | 7 |
| Directory activity | 4 views 0 installs 1 upvotes | 2 views 0 installs 0 upvotes |
| Tools | 3 | 3 |
| Full listing | View Mysql MCP Server | View Read Only Local Mysql MCP Server |
Tools & capabilities
Mysql MCP Server tools 3
execute_sqlExecutes any standard SQL query.get_schema_infoProvides detailed metadata about database structures.get_table_sampleFetches a representative sample of data.
Read Only Local Mysql MCP Server tools 3
connectConnect to a MySQL database using a connection string. The connection will be used for subsequent queries until changed.disconnectDisconnect from the current runtime database and revert to the default environment-configured connectionqueryRun a read-only SQL query against the currently connected database
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
Mysql MCP Server
{
"mcpServers": {
"designcomputer-mysql-mcp-server": {
"command": "uvx",
"args": [
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "YOUR_MYSQL_HOST_HERE",
"MYSQL_USER": "YOUR_MYSQL_USER_HERE",
"MYSQL_PASSWORD": "YOUR_MYSQL_PASSWORD_HERE"
}
}
}
}
Read Only Local Mysql MCP Server
{
"mcpServers": {
"read-only-local-mysql-mcp-server": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "YOUR_DB_HOST_HERE",
"DB_PORT": "YOUR_DB_PORT_HERE",
"DB_DATABASE": "YOUR_DB_DATABASE_HERE",
"DB_USERNAME": "YOUR_DB_USERNAME_HERE",
"DB_PASSWORD": "YOUR_DB_PASSWORD_HERE",
"DB_ALLOWED_HOSTS": "YOUR_DB_ALLOWED_HOSTS_HERE"
}
}
}
}
Frequently asked questions
Mysql MCP Server is categorized under Databases and uses a local stdio subprocess. Read Only Local Mysql MCP Server belongs to Databases and uses a local stdio subprocess. Pick Mysql MCP Server for databases work and Read Only Local Mysql MCP Server for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
Mysql MCP Server is listed as free. Auth: other. Read Only Local Mysql MCP Server has no declared pricing — check the project's own site. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add designcomputer-mysql-mcp-server and read-only-local-mysql-mcp-server as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Mysql MCP Server has a quality signal of 56/100 (Good) with 4 views, 0 installs and 1,400 GitHub stars. Read Only Local Mysql MCP Server has 60/100 (Good) with 2 views, 0 installs and 7 GitHub stars.