Read Only Local Mysql MCP Server vs MySQL Ops MCP
A side-by-side look at the Read Only Local Mysql MCP Server and MySQL Ops MCP MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Read Only Local Mysql MCP Server for databases work as a local process; choose MySQL Ops MCP 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 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.
Choose MySQL Ops MCP 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_USER, DB_PASSWORD, DB_DATABASE. - You want tools like
list_databases, list_tables, describe_table.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 60/100 · Good | 51/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | Not declared | Not declared |
| Pricing | Not declared | Not declared |
| Required env vars | DB_HOSTDB_PORTDB_DATABASEDB_USERNAMEDB_PASSWORDDB_ALLOWED_HOSTS | DB_HOSTDB_PORTDB_USERDB_PASSWORDDB_DATABASE |
| Verified owner | Community listing | Community listing |
| GitHub stars | 7 | 0 |
| Directory activity | 2 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 3 | 11 |
| Full listing | View Read Only Local Mysql MCP Server | View MySQL Ops MCP |
Tools & capabilities
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
MySQL Ops MCP tools 11
list_databasesList all databaseslist_tablesList tables in a databasedescribe_tableShow table columns and typesget_table_infoFull table details: columns, indexes, DDL, statsqueryRun a SELECT querycreate_tableCreate a table (CREATE TABLE only)insertInsert rows (INSERT only)updateUpdate rows (UPDATE only)delete_dataDelete rows — requires user approvaldrop_tableDrop a table — requires user approvalexecute_sqlRun any custom SQL statement
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.
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"
}
}
}
}
MySQL Ops MCP
{
"mcpServers": {
"mysql-ops-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-ops-mcp"
],
"env": {
"DB_HOST": "YOUR_DB_HOST_HERE",
"DB_PORT": "YOUR_DB_PORT_HERE",
"DB_USER": "YOUR_DB_USER_HERE",
"DB_PASSWORD": "YOUR_DB_PASSWORD_HERE",
"DB_DATABASE": "YOUR_DB_DATABASE_HERE"
}
}
}
}
Frequently asked questions
Read Only Local Mysql MCP Server is categorized under Databases and uses a local stdio subprocess. MySQL Ops MCP belongs to Databases and uses a local stdio subprocess. Pick Read Only Local Mysql MCP Server for databases work and MySQL Ops MCP 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.
Read Only Local Mysql MCP Server has no declared pricing — check the project's own site. MySQL Ops MCP 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 read-only-local-mysql-mcp-server and mysql-ops-mcp as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Read Only Local Mysql MCP Server has a quality signal of 60/100 (Good) with 2 views, 0 installs and 7 GitHub stars. MySQL Ops MCP has 51/100 (Good) with 3 views, 0 installs and 0 GitHub stars.