ibmi

Automate IBM i tasks via the ibmi CLI with SQL and NDJSON streaming.

3|1|Updated Feb 3, 2026
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill ibmi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ibmi
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/ibmi
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill ibmi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i administrators and developers need a consistent, scriptable way to interact with Db2 for i, run queries, discover schemas, and automate cross-system workflows. This skill provides a unified CLI interface and robust scripting patterns that reduce manual tasks and errors.

Core Features & Use Cases

  • CLI-driven interaction for IBM i systems, including system connections, schema discovery, and SQL execution across multiple targets.
  • Agent scripting patterns support deterministic outputs, NDJSON streaming, dry-run planning, and semantic exit codes to fit into automation pipelines.
  • Multi-system workflows and pipelines for CI/CD, cross-system diffs, and automated operational tasks.

Quick Start

Install the ibmi CLI and connect to a configured IBM i system to begin running queries and scripting tasks.

Frequently Asked Questions about ibmi

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate IBM i SQL query execution across multiple systems?

IBM i SQL query execution across multiple systems is automated using the ibmi CLI, which supports multi-system configurations, schema discovery, and deterministic outputs within CI workflows. It provides a unified interface to run cross-system tasks.

What is NDJSON streaming and when do I need it for IBM i scripting?

NDJSON streaming (--stream) is a data processing mechanism that outputs continuous JSON objects for IBM i scripting tasks. It is needed when handling large query result sets or running continuous agent scripts where buffering entire outputs would cause memory or pipeline bottlenecks.

Does the ibmi CLI support dry-run planning for CI/CD pipelines?

The ibmi CLI supports dry-run planning for CI/CD pipelines by evaluating multi-system workflow configurations without executing destructive changes. It returns semantic exit codes to signal success or specific failure states, enabling deterministic automation pipeline control.

Can I extend IBM i task automation with custom YAML-based tools?

IBM i task automation can be extended using YAML-based tools that define custom scripting patterns for the ibmi CLI. This allows administrators to configure specific Db2 for i interactions and operational workflows without modifying the core CLI implementation.

What is the best way to run cross-system diffs for Db2 for i schemas?

The best way to run cross-system diffs for Db2 for i schemas is using the ibmi CLI's multi-system workflow capabilities. It connects to configured IBM i targets, discovers database schemas, and executes comparative SQL queries to identify structural differences across systems.

Why should I use semantic exit codes in IBM i automation workflows?

Semantic exit codes should be used in IBM i automation workflows because they provide deterministic success and failure signaling for CI/CD pipelines. They allow agent scripts to distinguish between connection errors, query failures, and dry-run validations for precise pipeline control.