IBM i MCP Server v0.4.2

[ajshedivy]

Overview

• --builtin-tools CLI fix — The --builtin-tools flag now correctly registers all 7 default text-to-SQL tools instead of only 2
• UDTF column validation transparency — validate_query reports columns from UDTF output as "skipped" instead of silently passing validation

---

Bug Fixes

• --builtin-tools CLI flag: Running npx @ibm/ibmi-mcp-server --transport http --builtin-tools only registered execute_sql and generate_sql, skipping the 5 schema discovery tools (list_schemas, list_tables_in_schema, get_table_columns, get_related_objects, validate_query). The root cause was ES module evaluation timing — tool definitions were captured before CLI overrides were applied. Tool registration now defers config evaluation to runtime.

• UDTF column validation: When using validate_query on queries involving User-Defined Table Functions (e.g., TABLE(SYSTOOLS.AUDIT_JOURNAL_CP(...))), columns from the UDTF result set were silently skipped during validation. Bogus column names would pass without warning. The tool now explicitly reports which columns were skipped and advises users to verify them against the function's result set.

---

All Changes

• fix(tools): resolve --builtin-tools not registering tools and surface skipped UDTF columns by @ajshedivy in 2134d79

Full Changelog: v0.4.1...v0.4.2

---

This discussion was created from the release IBM i MCP Server v0.4.2.