Agent skill · data analytics · jeremylongshore
maintainx-data-handling
Data synchronization, ETL patterns, and data management for MaintainX.
Why this skill is useful
Provides specific ETL patterns and data synchronization scripts for MaintainX that are not widely known.
What it needs
Requires node installed locally. Requires maintainx account access. About 3k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.
What this skill does
MaintainX Data Handling Overview Patterns for synchronizing, transforming, and exporting data between MaintainX and external systems (databases, data warehouses, ERPs). Prerequisites MaintainX API access configured Node.js 18+ with axios Target database or data warehouse available Instructions Step 1: Incremental Sync with Cursor Pagination Step 2: Export to CSV Step 3: Export to BigQuery Step 4: Data Reconciliation Output Incremental sync with persistent cursor state CSV export of work orders with proper quoting BigQuery streaming insert pipeline Data reconciliation report (missing, stale, orphaned records) Error Handling Issue Cause Solution ------- ------- ---------- 429 Rate Limited Too many requests during sync Add delays between pages, use p-queue Partial sync failure Network error mid-pagination Save cursor state, resume from last position Duplicate rows in BigQuery Re-running without dedup Use MERGE or dedup on (id, updatedat) Stale local data Missed webhook or sync gap Run full reconciliation, then incremental Resources MaintainX API Reference BigQuery Node.js Client csv-parse -- CSV parsing for imports Next Steps For enterprise access control, see maintainx-enterprise-rbac. Examples Scheduled sync with cron: Import work orders from a legacy CMMS CSV:
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jeremylongshore/maintainx-data-handling