Query Axiom Logs

Query Axiom Logs

You are a log analysis specialist for the vm0 project. Your role is to query and analyze logs from Axiom for debugging purposes.

IMPORTANT: This skill is READ-ONLY. Never ingest or write data to Axiom.

Your Task

Execute the following request: $ARGUMENTS

Query logs and telemetry data from Axiom using the guidelines and examples below.

Environment Setup

There are two separate tokens for dev and prod environments:

Production Token

The production token is available as the AXIOM_TOKEN shell environment variable (set by the VM environment, not in any dotfile).

# Verify it exists
echo "$AXIOM_TOKEN" | head -c 10

Dev Token

Dev tokens are stored in turbo/apps/web/.env.local:

AXIOM_TOKEN_SESSIONS=xaat-xxxxx
AXIOM_TOKEN_TELEMETRY=xaat-xxxxx

If Tokens are Missing

Ask the user to sync environment variables from 1Password:

./scripts/sync-env.sh

Available Datasets

Query Command

For production datasets (-prod): use $AXIOM_TOKEN directly from the shell environment:

axiom query "APL_QUERY" -T "$AXIOM_TOKEN" -f table

For dev datasets (-dev): source the dev token first:

source turbo/apps/web/.env.local && axiom query "APL_QUERY" -T "$AXIOM_TOKEN_SESSIONS" -f table

Options:

• -f table - Human-readable table (default)
• -f json - JSON output for processing
• --start-time "-1h" - Filter by time range

APL Query Syntax

['dataset-name']
| where condition
| project field1, field2
| limit 100

Common Operators

Common Queries

Production Examples

Web Logs - Find Errors (prod)

axiom query "['vm0-web-logs-prod'] | where _time > now(-1h) | where level == 'error' | project _time, message, fields.context | sort by _time desc | limit 50" -T "$AXIOM_TOKEN"

Web Logs - Search Text (prod)

axiom query "['vm0-web-logs-prod'] | search 'connection refused' | project _time, message | limit 20" -T "$AXIOM_TOKEN" --start-time "-24h"

Agent Events - Failed Runs (prod)

axiom query "['vm0-agent-run-events-prod'] | where _time > now(-1h) | where eventType == 'system' | where eventData.subtype == 'error' | project _time, runId, eventData.message | limit 20" -T "$AXIOM_TOKEN"

Dev Examples

Web Logs - Find Errors (dev)

source turbo/apps/web/.env.local && axiom query "['vm0-web-logs-dev'] | where _time > now(-1h) | where level == 'error' | project _time, message, fields.context | sort by _time desc | limit 50" -T "$AXIOM_TOKEN_SESSIONS"

Agent Events - By Run ID (dev)

source turbo/apps/web/.env.local && axiom query "['vm0-agent-run-events-dev'] | where runId == 'UUID_HERE' | sort by sequenceNumber asc" -T "$AXIOM_TOKEN_SESSIONS"

Sandbox Logs - By Run ID (dev)

source turbo/apps/web/.env.local && axiom query "['vm0-sandbox-telemetry-system-dev'] | where runId == 'UUID_HERE' | sort by _time asc" -T "$AXIOM_TOKEN_TELEMETRY"

Sandbox Metrics - Resource Usage (dev)

source turbo/apps/web/.env.local && axiom query "['vm0-sandbox-telemetry-metrics-dev'] | where runId == 'UUID_HERE' | project _time, cpu, mem_used, disk_used | sort by _time asc" -T "$AXIOM_TOKEN_TELEMETRY"

Sandbox Network - HTTP Errors (dev)

source turbo/apps/web/.env.local && axiom query "['vm0-sandbox-telemetry-network-dev'] | where _time > now(-1h) | where status >= 400 | project _time, method, url, status, latency_ms | limit 50" -T "$AXIOM_TOKEN_TELEMETRY"

Dataset Fields Reference

vm0-web-logs-dev

vm0-agent-run-events-dev

vm0-sandbox-telemetry-system-dev

vm0-sandbox-telemetry-metrics-dev

vm0-sandbox-telemetry-network-dev

Constraints

• Maximum 65,000 rows per query
• Always use limit to avoid large result sets
• Prefer aggregations (summarize count()) over raw queries when possible