By ajshedivy
24 agent skills with 215+ tools for IBM i SQL Services — full coverage of work management, database, security, storage, communication, and system administration via QSYS2 and SYSTOOLS services. Driven by the @ibm/ibmi-cli.
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.
Query and analyze IBM i backup and recovery resources including save files, save file contents, media libraries, and tape cartridges via SQL services. Use when user asks about: (1) save file history or contents, (2) finding where an object was saved, (3) media library device status, (4) tape cartridge inventory, (5) backup verification, or (6) replacing DSPSAVF, WRKTAP, WRKMLBRM commands.
Monitor and analyze IBM i network and communication resources including TCP/IP connections, network interfaces, routing, HTTP servers, and DNS configuration via SQL services. Use when user asks about: (1) active network connections and traffic, (2) network interface status and IP addresses, (3) routing tables, (4) HTTP server configuration and status, (5) TCP/IP settings and hostname, (6) NTP/SNTP time synchronization, (7) network attributes, or (8) replacing NETSTAT, WRKTCPSTS, CFGTCP, WRKhttpsrvr commands.
Query IBM i system configuration including system values, hardware resources, device status, environment variables, and JVM settings via SQL services. Use when user asks about: (1) system value settings like QSECURITY or QCCSID, (2) security-related system values, (3) hardware resource inventory, (4) controller, device, or line status, (5) environment variable settings, (6) active JVM information, (7) replacing DSPSYSVAL, DSPHDWRSC, WRKCFGSTS, WRKENVVAR commands, or (8) any system configuration review.
Analyze IBM i SQL application behavior including error logs, statement parsing, SQLCODE lookups, and system limits. Use when user asks about: (1) SQL errors in applications or error log analysis, (2) most frequent SQL errors, (3) parsing SQL statements to find referenced objects, (4) looking up SQLCODE meanings, (5) properly delimiting SQL identifiers, (6) system size limits for files or indexes, or (7) objects approaching maximum capacity.
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
Agent skills for AI coding assistants to work with IBM i systems. 24 skills covering all IBM i SQL Service categories with 215+ pre-built tools, driven by the ibmi CLI.
Agents are increasingly capable, but often don't have the context they need to do real work reliably. Skills solve this by giving agents access to procedural knowledge and company, team, and user-specific context they can load on demand. Agents with access to a set of skills can extend their capabilities based on the task they're working on.
Skills are organized into plugins so you can install only what you need:
| Plugin | Skills | Tools | Audience |
|---|---|---|---|
| ibmi-core | 1 (ibmi) | 3 | Everyone — CLI, text-to-SQL, schema discovery, agent scripting |
| ibmi-database | 5 | 51 | DBAs, SQL developers |
| ibmi-system | 18 | 161 | Sysadmins, operators, security, DevOps |
| ibmi-all | 24 | 219+ | Install everything |
/plugin marketplace add ajshedivy/ibmi-agent-skills
# Install by role:
/plugin install ibmi-core@ibmi-agent-skills # Start here
/plugin install ibmi-database@ibmi-agent-skills # For DBAs
/plugin install ibmi-system@ibmi-agent-skills # For sysadmins
# Or install everything:
/plugin install ibmi-all@ibmi-agent-skills
Install skills using npx skills. Works with Claude Code, Cursor, GitHub Copilot, and 40+ other agents.
# Install from GitHub
npx skills add ajshedivy/ibmi-agent-skills
# Or clone and install locally
git clone https://github.com/ajshedivy/ibmi-agent-skills.git
cd ibmi-agent-skills
npx skills add ./skills --list # List available skills
npx skills add ./skills/ibmi # Core skill (start here)
npx skills add ./skills # Install all skills
| Option | Description |
|---|---|
-g, --global | Install to user directory instead of project |
-a, --agent <agents...> | Target specific agents (e.g., claude-code, cursor) |
-s, --skill <skills...> | Install specific skills by name |
-l, --list | List available skills without installing |
-y, --yes | Skip all confirmation prompts |
--all | Install all skills to all agents without prompts |
# Install to Claude Code only
npx skills add ./skills -a claude-code
# Install globally (available across all projects)
npx skills add ./skills -g
# Non-interactive installation
npx skills add ./skills -g -a claude-code -y --all
The only dependency is the ibmi CLI, which handles SQL execution, schema discovery, DDL generation, and YAML tool invocation. All skills in this repo are built on it.
# Recommended — daily use
npm i -g @ibm/ibmi-cli
# Or one-shot via npx (no install)
npx -y @ibm/ibmi-cli --help
The ibmi skill runs a preflight check before each session — if the CLI is missing, it will walk you through the install. Power users can just install it up-front with the command above.
The CLI keeps system connections in its own config. Add one, test it, and set it as the default:
# Add a system (you'll be prompted for the password; re-run with --password to pipe non-interactively)
ibmi system add dev \
--host your-ibmi-host.example.com \
--user YOURUSER \
--port 8076
# Make it the default so other commands don't need --system
ibmi system default dev
# Verify connectivity
ibmi system test dev
# Inspect what's configured
ibmi system list
ibmi config show # shows effective config and which file each value came from
Need multiple systems? Just add more and target them per-command with --system:
ibmi system add prod --host prod.example.com --user YOURUSER --port 8076
ibmi --system prod sql "SELECT 1 FROM SYSIBM.SYSDUMMY1"
For CI or ephemeral environments, set credentials via environment variables instead of the config file:
export DB2i_HOST=your-ibmi-host.example.com
export DB2i_USER=YOURUSER
export DB2i_PASS=your-password
ibmi sql "SELECT 1 FROM SYSIBM.SYSDUMMY1"
# Should print a few schemas
ibmi schemas --limit 5
# Run a skill tool directly (after installing a plugin or cloning)
ibmi tool list_active_jobs \
--tools ./skills/work-management/tools/ \
--limit 5
Further docs: CLI commands · agent integration · full docs index.
npx claudepluginhub ajshedivy/ibmi-agent-skills --plugin ibmi-allBuild AI agents, teams, and workflows with the Agno framework — includes tools, knowledge, memory, storage, guardrails, reasoning, and multimodal support
Interact with AgentOS API endpoints — manage agents, teams, sessions, traces, evals, knowledge, memory, and workflows remotely
Operate a running AgentOS server from the command line with agno-cli — agents, teams, workflows, traces, sessions, memories, knowledge, evals, approvals, schedules, and config.
MCP server and skills for InterSystems IRIS development — 20 tools for live IRIS interaction plus 21 validated coding skills. Single binary, no Python required.
Comprehensive operations manager for FairDB managed PostgreSQL service - SOPs, incident response, monitoring, and automation
The most comprehensive SAP Datasphere plugin for Claude. 18 specialized skills covering exploration, data modeling, integration, BW Bridge migration, security architecture, CLI automation, business content activation, catalog governance, performance optimization, and troubleshooting — all through natural language. Powered by 45 MCP tools with enterprise-grade security.
ServiceNow admin toolkit — incidents, CMDB, update sets, table explorer. 18 MCP tools + 4 guided skills.
Assists with SAP HANA Developer CLI (hana-cli) for database development and administration. Use when: installing hana-cli, connecting to SAP HANA databases, inspecting database objects (tables, views, procedures, functions), managing HDI containers, executing SQL queries, converting metadata to CDS/EDMX/OpenAPI formats, managing SAP HANA Cloud instances, working with BTP CLI integration, or troubleshooting hana-cli commands. Covers: 91 commands, 17+ output formats, HDI container management, cloud operations.
Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.