Command Reference

outlit customers list [flags]

# Paying customers inactive for 30 days
outlit customers list --billing-status PAYING --no-activity-in 30d

# High-MRR customers sorted by revenue
outlit customers list --mrr-above 50000 --order-by mrr_cents --order-direction desc

# Search for a customer
outlit customers list --search "acme"

# Pipe to jq
outlit customers list --json | jq '.items[] | {domain, mrr: .currentMrr}'

{
  "items": [
    {
      "id": "550e8400-e29b-41d4-a716-446655440000",
      "name": "Acme Corp",
      "domain": "acme.com",
      "billingStatus": "PAYING",
      "currentMrr": 500000,
      "lastActivityAt": "2025-02-10T15:30:00Z",
      "status": "ACTIVE",
      "type": "COMPANY"
    }
  ],
  "pagination": {
    "hasMore": true,
    "nextCursor": "cursor_abc123",
    "total": 150
  }
}

# First page
outlit customers list --limit 50 --json > page1.json

# Next page
CURSOR=$(jq -r '.pagination.nextCursor' page1.json)
outlit customers list --limit 50 --cursor "$CURSOR" --json

Showing 20 of 150 total. Next page: --cursor cursor_abc123

outlit customers get <customer> [flags]

# Basic profile
outlit customers get acme.com

# Full profile with all sections
outlit customers get acme.com --include users,revenue,recentTimeline --timeframe 90d

# By UUID
outlit customers get 550e8400-e29b-41d4-a716-446655440000

{
  "id": "550e8400-e29b-41d4-a716-446655440000",
  "name": "Acme Corp",
  "domain": "acme.com",
  "billingStatus": "PAYING",
  "currentMrr": 500000,
  "contacts": [
    {
      "id": "user-uuid",
      "name": "Jane Doe",
      "email": "jane@acme.com",
      "journeyStage": "CHAMPION"
    }
  ],
  "revenue": {
    "currentMrr": 500000,
    "historicalMrr": []
  },
  "recentTimeline": [
    {
      "type": "PAGE_VIEW",
      "channel": "WEB",
      "occurredAt": "2025-02-10T15:30:00Z"
    }
  ]
}

outlit customers timeline <customer> [flags]

# Last 30 days (default)
outlit customers timeline acme.com

# Last 90 days, email and Slack only
outlit customers timeline acme.com --timeframe 90d --channels EMAIL,SLACK

# Custom date range
outlit customers timeline acme.com --start-date 2025-01-01 --end-date 2025-03-01

# Page views and meetings only
outlit customers timeline acme.com --event-types PAGE_VIEW,MEETING --limit 50

{
  "items": [
    {
      "id": "event-uuid",
      "customerId": "customer-uuid",
      "type": "PAGE_VIEW",
      "channel": "WEB",
      "occurredAt": "2025-02-10T15:30:00Z",
      "metadata": {
        "url": "https://acme.com/pricing",
        "title": "Pricing Page"
      }
    }
  ],
  "pagination": {
    "hasMore": false,
    "nextCursor": null,
    "total": 45
  }
}

outlit users list [flags]

# Find champions
outlit users list --journey-stage CHAMPION

# Inactive users from a specific customer
outlit users list --customer-id 550e8400-... --no-activity-in 30d

# Search by name
outlit users list --search "alice" --order-by last_activity_at

{
  "items": [
    {
      "id": "user-uuid",
      "email": "jane@acme.com",
      "name": "Jane Doe",
      "customerId": "customer-uuid",
      "journeyStage": "CHAMPION",
      "lastActivityAt": "2025-02-10T15:30:00Z"
    }
  ],
  "pagination": {
    "hasMore": true,
    "nextCursor": "cursor_abc",
    "total": 500
  }
}

outlit facts <customer> [flags]

# Facts from last 30 days
outlit facts acme.com

# Extended lookback
outlit facts acme.com --timeframe 90d --limit 50

# Pipe for processing
outlit facts acme.com --json | jq '.items[] | select(.severity == "HIGH")'

{
  "items": [
    {
      "id": "fact-uuid",
      "customerId": "customer-uuid",
      "type": "SIGNAL",
      "title": "Budget concerns raised",
      "severity": "HIGH",
      "generatedAt": "2025-02-10T15:30:00Z"
    }
  ],
  "pagination": {
    "hasMore": false,
    "nextCursor": null,
    "total": 12
  }
}

outlit search <query> [flags]

# Organization-wide search
outlit search "pricing objections"

# Scoped to a customer
outlit search "budget concerns" --customer acme.com

# Time-bounded
outlit search "expansion signals" --after 2025-01-01 --before 2025-03-31

# More results
outlit search "churn risk" --top-k 100 --json

{
  "items": [
    {
      "customerId": "customer-uuid",
      "snippet": "Customer mentioned pricing concerns in Q1 planning meeting",
      "relevance": 0.92,
      "source": "TIMELINE",
      "timestamp": "2025-02-10T15:30:00Z"
    }
  ],
  "total": 42
}

outlit sql <query> [flags]
outlit sql --query-file <path> [flags]

# Inline query
outlit sql "SELECT event_type, COUNT(*) as cnt FROM events GROUP BY 1 ORDER BY cnt DESC"

# From a file
outlit sql --query-file ./queries/monthly-activity.sql

# Pipe to jq
outlit sql "SELECT domain, current_mrr FROM customer_dimensions ORDER BY current_mrr DESC LIMIT 10" | jq

{
  "rows": [
    { "event_type": "PAGE_VIEW", "cnt": 12500 },
    { "event_type": "MEETING", "cnt": 340 }
  ],
  "rowCount": 2
}

outlit schema [table]

# List all tables
outlit schema

# Describe a specific table
outlit schema events

# JSON output
outlit schema customer_dimensions --json

{
  "tables": [
    {
      "name": "events",
      "columns": [
        { "name": "id", "type": "uuid", "nullable": false },
        { "name": "event_type", "type": "varchar", "nullable": false }
      ]
    }
  ]
}