ajshedivy/librarian
skills/librarian/SKILL.md
Manage and query IBM i library lists, library contents, authorization lists, and object privileges via SQL services. Use when user asks about: (1) current library list configuration, (2) library contents and object inventory, (3) authorization lists and secured objects, (4) object-level privilege details, (5) library information and sizes, (6) system vs user library list entries, (7) replacing DSPLIBL, DSPLIB, DSPAUTL, DSPOBJAUT commands, or (8) any library management task.
$ install --global
skillsauthnpx skillsauth add ajshedivy/ibmi-agent-skills librarianInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 25, 2026, 5:33 AM53.6s4 files scanned
SKILL.md
- name:
- librarian
- description:
- Manage and query IBM i library lists, library contents, authorization lists, and object privileges via SQL services. Use when user asks about: (1) current library list configuration, (2) library contents and object inventory, (3) authorization lists and secured objects, (4) object-level privilege details, (5) library information and sizes, (6) system vs user library list entries, (7) replacing DSPLIBL, DSPLIB, DSPAUTL, DSPOBJAUT commands, or (8) any library management task.
IBM i Library & Object Management
Manage and query library lists, library contents, authorization lists, and object privileges using SQL services from QSYS2.
Available Tools
The ibmi CLI is the primary tool for executing library queries. Set SKILL_DIR to this skill's installed location (the directory containing this SKILL.md file):
# SKILL_DIR = directory containing this SKILL.md
# Examples: ./skills/librarian, ~/.claude/skills/librarian
ibmi tools --tools "$SKILL_DIR/tools/" --toolset librarian_default
ibmi tool get_library_list --tools "$SKILL_DIR/tools/"
ibmi sql "SELECT * FROM QSYS2.LIBRARY_LIST_INFO ORDER BY ORDINAL_POSITION"
Service Selection Guide
Library List
- QSYS2.LIBRARY_LIST_INFO -- Current job library list (system, product, current, user)
Library & Object Information
- QSYS2.OBJECT_STATISTICS() -- Object details: size, owner, type, timestamps
- QSYS2.OBJECT_PRIVILEGES -- Authority details for any object
Authorization Lists
- QSYS2.AUTHORIZATION_LIST_INFO -- Objects secured by authorization lists
- QSYS2.AUTHORIZATION_LIST_USER_INFO -- User authorities on authorization lists
Key Capabilities
Library List Management
- Complete List -- View full library list with ordinal positions
- Type Filtering -- Filter by SYSTEM, PRODUCT, CURRENT, or USER entries
- Library Details -- Size, owner, creation date, last used date
Object Inventory
- Library Contents -- List all objects in a library with type filtering
- Object Statistics -- Size, attribute, timestamps, and owner info
- Pattern Matching -- Find libraries matching a name pattern
Authorization Lists
- List Discovery -- Find all authorization lists and their secured objects
- User Authorities -- See who has what level of access on each list
- Privilege Details -- Granular authority breakdown (read/add/update/delete/execute)
Object Privileges
- Authority Audit -- Check all users and their authorities on a specific object
- Granular Permissions -- Object operational, management, existence, alter, reference
Common Use Cases
- Library list review -- Check current system and user library list entries
- Object inventory -- List files, programs, or other objects in a library
- Library sizing -- Check library size and object counts
- Authorization audit -- Review authorization list configurations
- Privilege check -- Verify object-level authorities for a specific object
- Library comparison -- Compare system vs user library list entries
Quick Examples
View library list
ibmi tool get_library_list --tools "$SKILL_DIR/tools/"
System libraries only
ibmi tool get_library_list_by_type --tools "$SKILL_DIR/tools/" --list-type SYSTEM
Objects in a library
ibmi tool list_library_objects --tools "$SKILL_DIR/tools/" --library-name QGPL
Check object privileges
ibmi tool get_object_privileges --tools "$SKILL_DIR/tools/" --object-schema QSYS --object-name QGPL --object-type '*LIB'
Pre-built Tools
The tools/librarian.yaml file provides 7 ready-to-use tools:
| Tool | Description |
|------|-------------|
| get_library_list | Complete library list with ordinal positions |
| get_library_list_by_type | Library list entries filtered by type |
| get_library_info | Detailed library information via OBJECT_STATISTICS |
| list_library_objects | Objects in a library with optional type filter |
| list_authorization_lists | Authorization lists and secured objects |
| list_authorization_list_users | User authorities on authorization lists |
| get_object_privileges | Object-level privilege details |
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
- Librarian Services Catalog -- Available SQL services
- Example SQL Patterns -- Working query examples
- IBM LIBRARY_LIST_INFO -- View documentation
- IBM OBJECT_STATISTICS -- Table function documentation
Related Skills
ajshedivy/work-management
tools
VerifiedTrustedCommunity
Query, monitor, and analyze jobs on IBM i using SQL table functions via the ibmi CLI. Use when user asks about: (1) finding jobs by status, user, subsystem, or type, (2) monitoring active job performance (CPU, I/O, memory), (3) detecting long-running SQL statements, (4) analyzing lock contention, (5) checking job queues, (6) scheduled jobs, (7) job logs, (8) replacing WRKACTJOB, WRKUSRJOB, WRKSBSJOB, WRKSBMJOB commands, or (9) any IBM i work management task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/system-health
testing
VerifiedTrustedCommunity
Monitor IBM i system health including CPU, memory, disk, ASPs, system limits, and network status via SQL services. Use when user asks about: (1) CPU utilization or system status, (2) memory pool sizes or page faults, (3) disk capacity or ASP usage, (4) system limits approaching thresholds, (5) TCP/IP connections and network status, (6) system activity overview, (7) replacing WRKSYSSTS, WRKDSKSTS, WRKTCPSTS commands, or (8) any system health monitoring task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/storage
development
VerifiedTrustedCommunity
Monitor and analyze IBM i storage resources including ASPs, disk units, temporary storage, user storage consumption, and NVMe devices via SQL services. Use when user asks about: (1) ASP capacity, usage, or health, (2) disk unit status or I/O performance, (3) temporary storage consumption by jobs, (4) storage used per user profile, (5) NVMe device health, (6) IASP vary operations, or (7) replacing WRKDSKSTS, WRKSYSSTS storage info, or WRKSTG commands.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/spool
testing
VerifiedTrustedCommunity
Manage and analyze spooled files, output queues, and printer configurations on IBM i via SQL services. Use when user asks about: (1) listing or searching output queues, (2) viewing spooled file entries by queue, user, or status, (3) reading spool file content, (4) identifying top spool consumers or old spool files, (5) printer file definitions, (6) spool storage analysis, (7) replacing WRKSPLF, WRKOUTQ, WRKOBJLCK commands, or (8) any spool file management task.
2SKILL.mdUpdated Apr 2, 2026