# mcp-server-db2i

Read-only SQL queries and schema inspection for IBM DB2 for i (AS/400). Requires Java.

- **Type:** MCP server
- **Trust:** 85/100 (A), scored on the package rubric
- **Verification:** verified (build provenance)
- **Version:** 2.5.0
- **Author:** io.github.Strom-Capital
- **License:** Unknown
- **npm:** mcp-server-db2i
- **Source:** https://github.com/Strom-Capital/mcp-server-db2i
- **Compatible clients:** claude-code, cursor, copilot, gemini (basis: transport)

## Trust

85/100 (A), scored on the package rubric
- Publisher verified: no
- Build provenance: verified attestation
- npm trusted publishing (OIDC): yes
- Install scripts: nothing suspicious found
- Prompt-injection scan: not run
- Obfuscation scan: not run
- Evidence age: 0 days

## Security scan

- **Status:** clean
- **Scanned:** 2026-09-24T09:56:56.380Z
- **Version scanned:** 2.5.0
- **CVEs:** none found by OSV at scan time

## Tools

18 declared. Statically extracted from the shipped source — a floor on the surface, not a census.
- `auth` — Authentication endpoints
- `health` — Health check endpoints
- `mcp` — MCP protocol endpoints
- `execute_query` — Execute a read-only SQL SELECT query against the IBM DB2i database. Only SELECT statements are allowed for security. Results are limited by default to prevent l
- `list_schemas` — List all schemas (libraries) in the IBM DB2i database. Optionally filter by name pattern using * as wildcard.
- `list_tables`
- `search_tables` — Find tables by name or description text across libraries. Matches TABLE_NAME, SYSTEM_TABLE_NAME, and TABLE_TEXT. Use * as a wildcard. When QUERY_ALLOWED_SCHEMAS
- `search_columns` — Find columns by name or description text across libraries. Matches COLUMN_NAME, SYSTEM_COLUMN_NAME, and COLUMN_TEXT. Use * as a wildcard. When QUERY_ALLOWED_SCH
- `describe_table`
- `list_views`
- `list_indexes`
- `get_table_constraints`
- `validate_query` — Check a SQL statement without running it. Parses it with QSYS2.PARSE_STATEMENT and checks that referenced tables, columns, and qualified routines exist in the c
- `get_object_ddl` — Return the SQL DDL that recreates a database object, using QSYS2.GENERATE_SQL. Does not run the generated statements. Requires IBM i 7.3 or later.
- `get_related_objects` — List views, indexes, triggers, and other objects that depend on a table, using SYSTOOLS.RELATED_OBJECTS. Requires IBM i 7.3 Technology Refresh 9, IBM i 7.4 Tech
- `get_journal_info` — List the physical data files in a library with their journal, journal library, journal images, omitted entries, and whether they have a primary key, using QSYS2
- `profile_table`
- `get_business_context` — List business entities, table and column descriptions, and relations that the catalog does not declare as foreign keys. Filter by entity or table. Omit both to 

## Install

**Verdict: install** — No blocking findings and no open coverage gaps — safe to install as configured.
**Config** (claude-code):
```json
"{\n  \"mcpServers\": {\n    \"mcp-server-db2i\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"mcp-server-db2i\"\n      ],\n      \"env\": {\n        \"DB2I_PASSWORD\": \"<YOUR_DB2I_PASSWORD>\"\n      }\n    }\n  }\n}"
```
**Credentials it will ask for** (names only — Forge never holds a value):
- `DB2I_PASSWORD` — Db2i Password (required)
Placeholders only. Forge never holds, brokers, or transmits a credential value — replace each <YOUR_NAME> in your own config file. Do not send a value back to Forge; no Forge endpoint accepts one.
- This entry needs 1 credential (1 required). The generated config carries placeholders, so it will fail in the editor rather than at runtime if they are left unset.

## Blast radius

Moderate blast radius — holds an api key; runs on your machine.
- Floor 23, ceiling 23 (tier: moderate)
- This is impact, not likelihood. A high radius is not a defect: a filesystem server is supposed to write files. It is never part of the trust score.

## Machine-readable views of this entry

- Signed JSON: https://forgeregistry.com/api/v1/packages/mcp-server-db2i
- Install plan: https://forgeregistry.com/api/v1/packages/mcp-server-db2i/install-plan
- Alternatives: https://forgeregistry.com/api/v1/alternatives/mcp-server-db2i
- HTML page: https://forgeregistry.com/registry/mcp-server-db2i
- MCP: POST https://forgeregistry.com/api/mcp → `forge_get_package` / `forge_install_plan`

## About this document

Generated by Forge (https://forgeregistry.com) — a compact rendering of the same record served, signed, at the JSON URL above. Trust and scan facts are the registry's own measurements; anything Forge did not measure is named as unmeasured rather than omitted.