skills.rest
abdullah1854
abdullah1854COMMUNITY
Explore all skills by this author →
GitHub

maximo-helper

Generate Maximo SELECT queries with mandatory SITEID filtering and predefined column schemas.

1|Updated Dec 22, 2025
Search Tags:#database#assets#maximo#work-orders
One-click install
npx skills add https://github.com/abdullah1854/ClaudeSuperSkills --skill maximo-helper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: maximo-helper
Source: https://github.com/abdullah1854/ClaudeSuperSkills/tree/main/maximo-helper
Command: npx skills add https://github.com/abdullah1854/ClaudeSuperSkills --skill maximo-helper

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires typing, sys, and includes scripts (resource) components.

What problem does it solve?

Generates Maximo queries with mandatory site filtering for common tables.

Core Features & Use Cases

  • Table Templates: Predefined schemas for Work Order, Asset, Inventory, etc.
  • Site Filtering: Enforce SITEID-based restrictions.

Quick Start

Build a SELECT for WORKORDER with SITEID filter, and optional extra filter.

Frequently Asked Questions about maximo-helper

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

FAQPage Schema
How do I generate Maximo queries filtered by site?▼

Maximo queries with site filtering enforce SITEID-based restrictions on work orders, assets, and inventory tables. This Skill generates SELECT statements with mandatory SITEID filters, predefined column schemas, and top 100 row limits to retrieve site-scoped data for maintenance operations, ad-hoc queries, and integrations.

Can I add custom WHERE conditions to Maximo database queries?▼

Yes. Maximo queries support an optional additional WHERE condition beyond the mandatory SITEID filter. This enables flexible filtering on work order status, asset properties, inventory levels, or labor transactions while maintaining site-scoped data retrieval.

What tables and columns does Maximo query generation support?▼

Predefined schemas cover Work Order, Asset, Inventory, and related labor transaction tables. Each template selects specific columns per table and applies SITEID filtering to ensure only site-specific records are returned in the top 100 rows.

When should I use site-filtered queries for Maximo maintenance work?▼

Site-filtered Maximo queries are essential when managing multi-site operations requiring data isolation by location. Use them for work order retrieval, asset inventory reports, and labor transaction integrations where site-scoped accuracy prevents cross-site data leakage.

Can Maximo queries work with existing database integration tools?▼

Maximo query generation supports ad-hoc queries and system integrations requiring site-scoped data retrieval. Generated SELECT statements are compatible with standard database connections and reporting workflows that consume maintenance work orders, assets, and inventory data.

Related Skills

Explore More Data & Analytics Skills→
jieni777jieni777
1

database

Connect to PostgreSQL or MySQL databases to execute SQL queries and inspect schema.

Community
Intermediate
Zidane786Zidane786

query-writing

Translate business questions into SQL queries with filters and aggregations.

Community
Intermediate
randoneeringrandoneering

evaluate-cortex-agent

Evaluate Cortex Agents in Snowflake and review results in Snowsight.

Community
Advanced
dotlab-hqdotlab-hq

query-writing

Generate and execute SQL SELECT queries with schema inspection and validation.

Official
Advanced