ajshedivy/ibmi-agent-skills/application

Claude Code and agent skill by ajshedivy/ibmi-agent-skills

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Query and explore IBM i application objects including CL commands, data areas, data queues, programs, environment variables, exit programs, and watches via SQL services. Use when user asks about: (1) CL command attributes or discovery, (2) data area values or inventory, (3) data queue status and messages, (4) program information (ILE/OPM), (5) environment variables, (6) registered exit programs, (7) watch sessions, (8) user spaces or user indexes, or (9) replacing DSPCMD, DSPDTAARA, DSPLIB, DSPPGM commands.

Install

npx vskill@latest install ajshedivy/ibmi-agent-skills/application

SKILL.md

The same SKILL.md was published earlier as ajshedivy/ibmi-agent-skills/application.

IBM i Application Services

Query and explore application objects on IBM i using SQL services from QSYS2.

Available Tools

The ibmi CLI is the primary tool for executing application queries. Set SKILL_DIR to this skill's installed location (the directory containing this SKILL.md file):

bash
# SKILL_DIR = directory containing this SKILL.md
# Examples: ./skills/application, ~/.claude/skills/application
ibmi tools --tools "$SKILL_DIR/tools/" --toolset application_default
ibmi tool list_programs --tools "$SKILL_DIR/tools/"
ibmi sql "SELECT * FROM QSYS2.PROGRAM_INFO WHERE PROGRAM_LIBRARY = 'MYLIB' FETCH FIRST 20 ROWS ONLY"

Service Selection Guide

Object Discovery
  • QSYS2.COMMAND_INFO — CL command metadata (library, processing program, threadsafe)
  • QSYS2.PROGRAM_INFO — ILE/OPM program details (language, activation group, size)
  • QSYS2.EXIT_PROGRAM_INFO — Registered exit programs by exit point
Data Objects
  • QSYS2.DATA_AREA_INFO (view) — Broad data area search across libraries
  • QSYS2.DATA_AREA_INFO (table function) — Targeted lookup by name
  • QSYS2.DATA_QUEUE_INFO — Data queue status, message counts, configuration
Runtime & Configuration
  • QSYS2.ENVIRONMENT_VARIABLE_INFO — System and job environment variables
  • QSYS2.WATCH_INFO — Watch/service monitor sessions
  • QSYS2.BINDING_DIRECTORY_INFO — Binding directory entries
  • QSYS2.BOUND_MODULE_INFO — Modules bound into ILE programs
  • QSYS2.BOUND_SRVPGM_INFO — Service programs bound into ILE programs
Data Interchange
  • QSYS2.DATA_QUEUE_ENTRIES — Read data queue entries
  • QSYS2.USER_SPACE / USER_SPACE_INFO — User space contents and metadata
  • QSYS2.USER_INDEX_INFO / USER_INDEX_ENTRIES — User index data

Key Capabilities

Command Discovery
  • List commands by library with processing program details
  • Check threadsafe and proxy command attributes
  • Find validity check programs for commands
Program Analysis
  • Inventory programs by library, type (ILE/OPM), and language
  • Check activation groups and creation timestamps
  • View program sizes for capacity planning
Data Object Inspection
  • Read data area values and metadata
  • Monitor data queue message counts and configuration
  • Browse user spaces and user indexes
Runtime Monitoring
  • List active and ended watch sessions
  • Check environment variables (system vs job level)
  • Review exit program registrations for security auditing

Common Use Cases

1. Library Inventory

List all programs, commands, and data areas in a specific library

2. Data Area Lookup

Retrieve the current value of a specific data area

3. Data Queue Monitoring

Find data queues with the most pending messages

4. Environment Variable Check

List system or job-level environment variables

5. Exit Program Audit

Review registered exit programs for security analysis

6. Program Analysis

Find ILE vs OPM programs and their languages

7. Watch Session Monitoring

Check active watch sessions and their configuration

CL Command Migration

CL CommandSQL Service
DSPCMDCOMMAND_INFO
DSPDTAARADATA_AREA_INFO (table function)
DSPPGMPROGRAM_INFO
WRKREGINFEXIT_PROGRAM_INFO / EXIT_POINT_INFO
WRKENVVARENVIRONMENT_VARIABLE_INFO
WRKWCHWATCH_INFO

Quick Examples

List commands in a library
sql
SELECT COMMAND_NAME, THREADSAFE, TEXT_DESCRIPTION
FROM QSYS2.COMMAND_INFO
WHERE COMMAND_LIBRARY = 'MYLIB'
ORDER BY COMMAND_NAME;
Get a data area value
sql
SELECT DATA_AREA_NAME, DATA_AREA_VALUE
FROM TABLE(QSYS2.DATA_AREA_INFO('MYDTAARA', '*LIBL'));
Find programs by language
sql
SELECT PROGRAM_NAME, PROGRAM_TYPE, PROGRAM_LANGUAGE, CREATION_TIMESTAMP
FROM QSYS2.PROGRAM_INFO
WHERE PROGRAM_LIBRARY = 'MYLIB'
ORDER BY PROGRAM_NAME;
Data queues with most messages
sql
SELECT DATA_QUEUE_LIBRARY, DATA_QUEUE_NAME, CURRENT_MESSAGES
FROM QSYS2.DATA_QUEUE_INFO
ORDER BY CURRENT_MESSAGES DESC
FETCH FIRST 20 ROWS ONLY;

Pre-built Tools

The tools/application.yaml file provides 8 ready-to-use tools:

ToolDescription
list_commandsCL commands with library and attributes
list_data_areasData area inventory across libraries
get_data_area_valueTargeted data area value lookup
list_data_queuesData queues with message counts
list_environment_variablesSystem and job environment variables
list_programsILE/OPM programs by library and type
list_exit_programsRegistered exit programs
list_watchesWatch sessions and status
bash
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" # Execute
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" --dry-run # Preview SQL
ibmi tools show <tool_name> --tools "$SKILL_DIR/tools/" # View details

Reference Documentation

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

7-day trend score
0

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/ajshedivy/ibmi-agent-skills/application/badge)](https://verified-skill.com/skills/ajshedivy/ibmi-agent-skills/application)

Something wrong with this skill or its page? Tell us.