IBM i MCP server v0.4.5 - ibmi describe, multi-system SQL, and security fixes

[ajshedivy]

We've just published v0.4.5 of @ibm/ibmi-mcp-server. This release brings two new CLI features, configuration improvements, and security fixes accumulated since v0.4.2.

Highlights

ibmi describe — DDL at your fingertips

Generate CREATE statements for any SQL object without leaving the terminal. Pass one or many objects, and get the full DDL back:

ibmi describe "SAMPLE.EMPLOYEE"
ibmi describe "SAMPLE.EMPLOYEE,SAMPLE.DEPARTMENT" --format json
ibmi describe "QSYS2.SYSCOLUMNS" --type VIEW

Supports all object types: TABLE, VIEW, INDEX, PROCEDURE, FUNCTION, TRIGGER, and more. If one object fails, you still get results for the rest.

Multi-system SQL — query dev and prod in parallel

Run the same query against multiple named systems with a single command:

ibmi sql "SELECT * FROM SAMPLE.EMPLOYEE FETCH FIRST 5 ROWS ONLY" --system dev,prod

Each row includes a SYSTEM column so you can tell results apart. JSON output adds a systems array with per-system row counts, timing, and error details. If one system is unreachable, the others still return results.

Other improvements since v0.4.2

• Config walk-up (v0.4.3): The CLI now discovers .ibmi/config.yaml by walking up the directory tree, plus a new ibmi config show command
• CLI works from any directory (v0.4.4): No more "Db2i configuration not found" when running from directories without .env
• --builtin-tools fix (v0.4.2): The flag now correctly registers the default text-to-SQL toolset
• Security: Container base image updated and npm audit fixes applied

Install / Upgrade

npm install @ibm/ibmi-mcp-server@0.4.5

Or with npx:

npx -y @ibm/ibmi-mcp-server@latest --transport http

Links

• Release notes
• Full changelog (v0.4.2...v0.4.5)
• npm package

Feedback, questions, and bug reports welcome — open an issue or reply here.