mcp-server-db2i

Name: mcp-server-db2i
Author: io.github.Strom-Capital

MCPattested

v2.5.0io.github.Strom-CapitalUnknownUpdated todaynpm GitHub

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

Works in

ClaudeCursorCopilotGemini

Inferred from the transports this listing declares (stdio). A client not listed here hasn’t been ruled out — it just isn’t something Forge can confirm.

Attested build

A verified provenance attestation binds this artifact to the listed repository. Nobody has claimed the listing yet — this proves where the code was built, not who stands behind it.

20GitHub stars

7Forks

todayLast update

Needs 1 credential before it runs

DB2I_PASSWORDAPI keyrequired
IBM i password

Declared by the author in the official MCP registry. Forge does not store, broker, or ever see these values — the config below is scaffolded with placeholders you fill in locally.

Package

Authorio.github.Strom-Capital

LicenseUnknown

Version2.5.0

Sourcenpm+mcp-registry

npmmcp-server-db2i

GitHubStrom-Capital/mcp-server-db2i

SBOMCycloneDX 1.6 ↓

Trust Status

85/100Trusted

✓Listed in Forge index+10/10

✓Identity verified · attested build+20/20

—Ed25519 publish signature+0/5

→ Included automatically when the publisher runs `forge publish`

—Domain verification+0/5

→ Publisher: host /.well-known/forge.json on the package homepage with { "publisher": "<github-login>" }

✓npm Trusted Publishing (Sigstore)+5/5

—npm maintainer match+0/5

→ Publisher: add the verified GitHub login to the npm package's maintainers (npm owner add <login>)

✓CVE scan · clean+30/30

✓Static analysis · clean+20/20

Paste into Claude Code, Cursor, or any AI assistant to fix all gaps

StatusIdentity verified

PublisherUnverified

SignatureUnsigned

Domain—

Provenance✓ Sigstore-verified · ad1c54d

Dependencies✓ 60 resolved+ · none vulnerable

Tool surface18 tools · none privileged

Security scan✓ Cleanv2.5.0 · todayHow well does this scan work?

EvalsNone

IndexedSep 24, 2026

Verification confirms publisher identity (repo ownership), not code safety. The security scan covers known CVEs and suspicious install scripts.

Tools

18 tools · none privileged

Statically extracted from the published packagev2.5.0 · 16h ago

Read out of the source npm actually ships, at scan time. The package was never executed. Tools registered dynamically at runtime, or hidden inside bundled or minified code, can be missed — so this is a floor on the tool surface, not a complete census of it.

Filter toolsPrivileged only

authAuthentication endpoints

Authentication endpoints

No input schema was published for this tool.

healthHealth check endpoints

Health check endpoints

No input schema was published for this tool.

mcpMCP protocol endpoints

MCP protocol endpoints

No input schema was published for this tool.

execute_queryExecute 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 large result sets.

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 large result sets.

No input schema was published for this tool.

list_schemasList all schemas (libraries) in the IBM DB2i database. Optionally filter by name pattern using * as wildcard.

List all schemas (libraries) in the IBM DB2i database. Optionally filter by name pattern using * as wildcard.

No input schema was published for this tool.

list_tablesNo description published

This tool published no description. Forge does not invent one.

search_tablesFind 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 is set, only those libraries are searched. Otherwise system libraries (Q* and SYS*) are skipped unless include_system is true.

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 is set, only those libraries are searched. Otherwise system libraries (Q* and SYS*) are skipped unless include_system is true.

No input schema was published for this tool.

search_columnsFind columns by name or description text across libraries. Matches COLUMN_NAME, SYSTEM_COLUMN_NAME, and COLUMN_TEXT. Use * as a wildcard. When QUERY_ALLOWED_SCHEMAS is set, only those libraries are searched. Otherwise system libraries (Q* and SYS*) are skipped unless include_system is true.

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_SCHEMAS is set, only those libraries are searched. Otherwise system libraries (Q* and SYS*) are skipped unless include_system is true.

No input schema was published for this tool.

describe_tableNo description published

This tool published no description. Forge does not invent one.

list_viewsNo description published

This tool published no description. Forge does not invent one.

list_indexesNo description published

This tool published no description. Forge does not invent one.

get_table_constraintsNo description published

This tool published no description. Forge does not invent one.

validate_queryCheck a SQL statement without running it. Parses it with QSYS2.PARSE_STATEMENT and checks that referenced tables, columns, and qualified routines exist in the catalog. Also reports read-only and schema-allowlist findings.

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 catalog. Also reports read-only and schema-allowlist findings.

No input schema was published for this tool.

get_object_ddlReturn 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.

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.

No input schema was published for this tool.

get_related_objectsList 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 Technology Refresh 3, or a later release.

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 Technology Refresh 3, or a later release.

No input schema was published for this tool.

get_journal_infoList 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.OBJECT_STATISTICS. needs_attention is true when a table is not journaled, or has no primary key and does not journal both images, which jo…

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.OBJECT_STATISTICS. needs_attention is true when a table is not journaled, or has no primary key and does not journal both images, which jo…

No input schema was published for this tool.

profile_tableNo description published

This tool published no description. Forge does not invent one.

get_business_contextList 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 return every annotation loaded from MCP_CUSTOM_TOOLS.

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 return every annotation loaded from MCP_CUSTOM_TOOLS.

No input schema was published for this tool.

12 of 18 tools published a description.

Tool names and descriptions are written by the publisher and shown verbatim as inert text. They are the strings an MCP client passes to a model, so Forge scans them for prompt-injection patterns — any finding appears with the security scan above. “Privileged” is a keyword match on the tool name, not an audit of what the tool does: a benign-sounding name can still do anything.

About

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

Keywords

mcp

Alternatives

Comparing tool surfaces…

Dependency tree

What one Forge scan resolved from npm metadata on 2026-09-24 — observed resolution, not a publisher declaration.

60 packages resolved · 10 direct · none carrying advisories Resolution stops at depth 4 and 60 packages.

zod4.6.5
hono4.13.9
pino10.3.111 dependencies
- sonic-boom4.2.1incomplete
- atomic-sleep1.0.0
- real-require0.2.0
- thread-stream4.2.0incomplete
- @pinojs/redact0.4.0
- process-warning5.1.0
- on-exit-leak-free2.1.2
- pino-std-serializers7.1.0
- safe-stable-stringify2.5.0
- quick-format-unescaped4.0.4
- pino-abstract-transport3.0.0incomplete
yaml2.9.1
express5.2.1+25 not drawn3 dependencies
- qs6.16.0incomplete
- depd2.0.0
- etag1.8.1
node-jt4007.0.1+4 not drawn
pino-pretty13.1.3+10 not drawn3 dependencies
- sonic-boom4.2.1incompleteshown above
- on-exit-leak-free2.1.2shown above
- pino-abstract-transport3.0.0incompleteshown above
node-sql-parser5.4.0incomplete
@modelcontextprotocol/node2.1.0incomplete
@modelcontextprotocol/server2.1.0incomplete

The crawl stopped at the 60-package limit. The rest of the tree was never resolved.

36 more resolved packages are not drawn here (display cap: 24). Every dependency carrying an advisory is drawn regardless of the cap. Full inventory (CycloneDX SBOM)

Declared but not resolved

72 declared dependencies never landed in the tree. They are missing from Forge's resolution, not from the package.

package cap reached: 72

secure-json-parse ^4.0.0 — required by pino-pretty@13.1.3package cap reached
fast-safe-stringify ^2.1.1 — required by pino-pretty@13.1.3package cap reached
strip-json-comments ^5.0.2 — required by pino-pretty@13.1.3package cap reached
@types/pegjs ^0.10.0 — required by node-sql-parser@5.4.0package cap reached
big-integer ^1.6.48 — required by node-sql-parser@5.4.0package cap reached
@hono/node-server ^1.19.9 — required by @modelcontextprotocol/node@2.1.0package cap reached
zod ^4.2.0 — required by @modelcontextprotocol/server@2.1.0package cap reached
@modelcontextprotocol/core 2.1.0 — required by @modelcontextprotocol/server@2.1.0package cap reached
atomic-sleep ^1.0.0 — required by sonic-boom@4.2.1package cap reached
real-require ^1.0.0 — required by thread-stream@4.2.0package cap reached
split2 ^4.0.0 — required by pino-abstract-transport@3.0.0package cap reached
side-channel ^1.1.1 — required by qs@6.16.0package cap reached

+60 more not listed. The counts by reason above cover all of them.

Not followed: peerDependencies. This tree covers runtime dependencies only, so anything those pull in was never resolved.

mcp-server-db2i

Tools

Tools exposed

Dependency tree

Declared but not resolved