IBM Db2 for i vs MySQL Ops MCP
A side-by-side look at the IBM Db2 for i 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 IBM Db2 for i 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 IBM Db2 for i when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You have the keys it needs:
DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD. - You want tools like
execute_query, export_query, list_schemas.
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 | DB2I_HOSTNAMEDB2I_USERNAMEDB2I_PASSWORD | DB_HOSTDB_PORTDB_USERDB_PASSWORDDB_DATABASE |
| Verified owner | Community listing | Community listing |
| GitHub stars | 26 | 0 |
| Directory activity | 1 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 20 | 11 |
| Full listing | View IBM Db2 for i | View MySQL Ops MCP |
Tools & capabilities
IBM Db2 for i tools 20
execute_queryExecute read-only SELECT queries, with an optional `chart` hint for the [result view](docs/tools.md#result-view)export_queryWrite every row of a read-only query to a CSV or XLSX file: a path over stdio, a short-lived download link over HTTP. Off unless `EXPORT_ENABLED` is setlist_schemasList schemas/libraries (with optional filter)list_tablesList tables in a schema (with optional filter)search_tablesFind tables by name or description across librariessearch_columnsFind columns by name or description across librariesdescribe_tableGet detailed column informationlist_viewsList views in a schema (with optional filter)list_indexesList SQL indexes for a tableget_table_constraintsGet primary keys, foreign keys, unique constraintslist_routinesList SQL procedures and functions in a library, with language, external program, and SQL data accessdescribe_routineParameters, return value or result columns, and a call template for a procedure or function- +8 more on the listing page
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.
IBM Db2 for i
{
"mcpServers": {
"ibm-db2-for-i": {
"command": "npx",
"args": [
"-y",
"-p",
"mcp-server-db2i@latest",
"-p",
"node-jt400",
"mcp-server-db2i"
],
"env": {
"DB2I_HOSTNAME": "YOUR_DB2I_HOSTNAME_HERE",
"DB2I_USERNAME": "YOUR_DB2I_USERNAME_HERE",
"DB2I_PASSWORD": "YOUR_DB2I_PASSWORD_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
IBM Db2 for i is categorized under Databases and uses a local stdio subprocess. MySQL Ops MCP belongs to Databases and uses a local stdio subprocess. Pick IBM Db2 for i 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.
IBM Db2 for i 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 ibm-db2-for-i and mysql-ops-mcp as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, IBM Db2 for i has a quality signal of 60/100 (Good) with 1 views, 0 installs and 26 GitHub stars. MySQL Ops MCP has 51/100 (Good) with 3 views, 0 installs and 0 GitHub stars.