# Maximo Helper

> maximo-helper

- Skill: `abdullah1854-claudesuperskills/maximo-helper` (Agent Skill, multi-file: 5 files)
- Install (CLI): `npx skillmds@latest add abdullah1854-claudesuperskills/maximo-helper`
- Raw SKILL.md: https://api.skillmd.com/api/skills/abdullah1854-claudesuperskills/maximo-helper/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: abdullah1854 (https://skillmd.com/u/abdullah1854-claudesuperskills)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/abdullah1854-claudesuperskills/maximo-helper

---

# maximo-helper

Generates Maximo database queries with mandatory site filtering for work orders, assets, inventory.

## Metadata
- **Version**: 1.0.0
- **Category**: database
- **Source**: workspace


## Tags
`maximo`, `database`, `work-orders`, `assets`

## MCP Dependencies
None specified

## Inputs
- `table` (string) (required): Table: WORKORDER, ASSET, INVENTORY, LABOR, LABTRANS
- `filter` (string) (optional): Additional WHERE conditions



## Workflow
No workflow defined

## Anti-Hallucination Rules
None specified

## Verification Checklist
None specified

## Usage

```typescript
// Execute via MCP Gateway:
gateway_execute_skill({ name: "maximo-helper", inputs: { ... } })

// Or via REST API:
// POST /api/code/skills/maximo-helper/execute
// Body: { "inputs": { ... } }
```



## Code

```typescript

const { table, filter } = inputs;
const SITE_FILTER = "SITEID = 'YOUR_SITE_ID'";

const schemas = {
  WORKORDER: ['WONUM', 'DESCRIPTION', 'STATUS', 'WORKTYPE', 'REPORTDATE', 'LOCATION', 'ASSETNUM'],
  ASSET: ['ASSETNUM', 'DESCRIPTION', 'STATUS', 'LOCATION', 'PARENT', 'SERIALNUM'],
  INVENTORY: ['ITEMNUM', 'STORELOC', 'CURBAL', 'AVGCOST', 'MINLEVEL'],
  LABOR: ['LABORCODE', 'DISPLAYNAME', 'STATUS', 'WORKSITE'],
  LABTRANS: ['LABTRANSID', 'LABORCODE', 'REFWO', 'STARTDATE', 'REGULARHRS']
};

const t = table.toUpperCase();
const cols = schemas[t] || ['*'];

let query = `SELECT TOP 100\n    ${cols.join(',\n    ')}\nFROM ${t}\nWHERE ${SITE_FILTER}`;

if (filter) {
  query += `\n  AND ${filter}`;
}

query += ';';

console.log(`-- Maximo Query for ${t}\n-- ⚠️ ALWAYS filter by ${SITE_FILTER}\n\n${query}`);

```

---
Created: Mon Dec 22 2025 10:35:19 GMT+0800 (Singapore Standard Time)
Updated: Mon Dec 22 2025 10:35:19 GMT+0800 (Singapore Standard Time)