Skip to main content

Ops CLI Documentation

Welcome to the Wasteology Operations CLI (ops) — the unified command-line interface for managing pipelines, databases, projects, reporting, and workflow orchestration across the entire Wasteology portfolio.

Data Pipeline Overview

The Ops CLI monitors and manages the data import pipeline end-to-end:

📤
CSV Upload
n8n Workflow
☁️
Azure Blob
🔄
Prefect Flow
🗄️
SQL Server
Hover over a stage to see details

Quick Start

Installation

The Ops CLI is part of the wg-orchestration project:

Install the Ops CLI
Terminal
$cd ~/projects/wg-orchestration && uv sync

Verify Installation

See all available commands
Terminal
$uv run ops capabilities
Check overall system health (after installing shell completion)
Terminal
$ops status
Shell Completion

Install tab-completion with ops --install-completion bash (or zsh/fish). After that, use ops directly — no uv run prefix needed.

Command Reference

All 23 command groups at a glance:

CommandDescriptionCommon Usage
ops statusOverall system health across all projectsops status --verbose
ops pipelineMonitor and manage data pipelinesops pipeline list --failed
ops prefectPrefect flow and deployment managementops prefect runs --state FAILED
ops dbtdbt data transformation operationsops dbt run, ops dbt test
ops slingSQL Server queries via Slingops sling query "SELECT ..."
ops n8nn8n workflow automationops n8n workflows
ops digestDaily digests, standup, task trackingops digest standup
ops portfolioCross-project portfolio visibilityops portfolio status
ops projectProject registry managementops project list, ops project health
ops dbPostgreSQL user and role managementops db users, ops db grants
ops agentMulti-agent orchestration (broadcast, chain)ops agent broadcast --prompt "..."
ops aiClaude and Gemini AI providersops ai auto "Summarize this"
ops orchADW orchestrator agent interfaceops orch status, ops orch trigger
ops monitorContinuous project monitoringops monitor all
ops docsDocumentation site managementops docs status, ops docs deploy
ops tech-stackTech stack visualizationsops tech-stack generate
ops errorsRecent errors across all projectsops errors --hours 48
ops execExecute commands in project contextops exec wdp-import status
ops runRun manifest-registered project commandsops run dbt run --select staging.*
ops routeRoute tickets to the right projectops route ticket "Fix billing ETL"
ops classifyClassify ticket type (bug/feature/chore)ops classify "Sling timeout on large tables"
ops queryQuery project state for AI assistantsops query status --json
ops gameTrash Truck arcade gameops game

Common Workflows

📋

Morning Standup

Run ops digest standup to get an AI-generated summary of yesterday's commits across all projects.

🚨

Pipeline Triage

Run ops status for a quick overview, then ops prefect runs --state FAILED to see what broke.

🤖

Agent Broadcast

Use ops agent broadcast --prompt "..." to fan a question or task out to all project master agents simultaneously.

🗄️

DB Access

Use ops db create-user + ops db grants to provision access. ops db audit-roles flags missing grants.

LLM Integration

The Ops CLI is designed to work with AI agents. Use ops capabilities --json to get a machine-readable dump of all available commands for tool discovery. ops query status --json returns a live system snapshot perfect for piping into an AI context.

Full Command Reference

Run ops <command> --help in the terminal for full flag documentation on any command, or ops capabilities for a summary of all available commands.

Interactive Architecture Overview

See the interactive architecture overview for a visual map of how the CLI commands connect to data sources, orchestration layers, and downstream systems.

Prefect Single-Surface Lifecycle

The ops prefect group now covers the complete flow lifecycle end-to-end: probe (validate the upstream API) → run-local (smoke-test the flow) → ship / deploy (build image and register the deployment) → run --watch --verify-count (trigger with row-count gating) → doctor (diagnose stalls). No separate Prefect UI or az CLI session required.