IBM i Core — CLI & Text-to-SQL

Foundation skill for working with IBM i systems. Provides the iterative querying methodology, CLI usage patterns, and Db2 for i SQL conventions that all other IBM i skills build on.

Available Tools

ibmi CLI

The ibmi CLI is the primary mechanism for executing SQL and running pre-built tools:

# Ad-hoc SQL
ibmi sql "SELECT * FROM QSYS2.SERVICES_INFO FETCH FIRST 5 ROWS ONLY"
ibmi sql "SELECT ..." --format table     # Human-readable
ibmi sql "SELECT ..." --limit 20         # Limit rows
ibmi sql --file query.sql                # From file

# Schema exploration
ibmi schemas                             # List all schemas