skills.rest
ajshedivy
ajshedivyCOMMUNITY
Explore all skills by this author →
GitHub

librarian

Query IBM i libraries, contents, authorization lists, and object privileges via QSYS2 services.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i library and object management can be error-prone and time-consuming. This skill provides SQL-based visibility into libraries, contents, authorization lists, and object privileges, enabling precise governance and faster troubleshooting.

Core Features & Use Cases

  • Library list discovery and system/user separation to understand the active environment.
  • Library contents inventory and object statistics for size, type, owner, and descriptions.
  • Authorization list and user authorities visibility for security auditing.
  • Object privilege queries to verify access controls on key objects.
  • Use Case: DBAs quickly assess system vs user libraries and enforce policy with repeatable queries.

Quick Start

Query the current library list and inspect library contents using the ibmi tools to understand system libraries and permissions.

Frequently Asked Questions about librarian

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

FAQPage Schema
How do I query IBM i library contents and authorization lists for auditing?▼

Query IBM i library contents and authorization lists by leveraging QSYS2 services and the ibmi CLI to generate repeatable, read-only results for security auditing and compliance reports.

What is the best way to inventory IBM i libraries and verify object privileges?▼

The best way to inventory IBM i libraries and verify object privileges is using SQL-based queries against QSYS2 services to retrieve object statistics like size, type, owner, and access controls.

Can I use SQL to review the current library list and separate system from user libraries?▼

Yes, you can use SQL to review the current library list and perform system versus user library separation, enabling DBAs to quickly assess the active environment and enforce governance policies.

Does this approach require write access to check IBM i security settings?▼

No, checking IBM i security settings does not require write access because the queries leverage QSYS2 services to produce read-only results, ensuring safe governance and compliance verification.

How do object privilege queries support troubleshooting access controls on IBM i?▼

Object privilege queries support troubleshooting by providing precise visibility into user authorities and authorization lists, enabling faster identification of misconfigured access controls on key objects.

Related Skills

Explore More Data & Analytics Skills→
ajshedivyajshedivy
3

journal

Query IBM i journals, receivers, and audit data marts via QSYS2 SQL services.

Community
Advanced
aaron-he-zhuaaron-he-zhu
2.5k

product-feed-optimizer

Audit and rewrite Shopping product feed data for campaign optimization.

Community
Advanced
ajshedivyajshedivy
3

database-utility

Inventory and analyze IBM i database files using SQL services via ibmi CLI.

Community
Advanced
ajshedivyajshedivy
3

security

Audit IBM i security posture via QSYS2 and SYSTOOLS SQL services.

Community
Advanced