INSPECTR
SHIFTLOG
MAINTAINR
REPORTR
CSV
MP
? Quick Guide — Configuration
  1. Mock mode — Leave endpoint blank. OPSIQ runs with realistic sample data, no server needed.
  2. Live mode — Enter your API endpoint (e.g. http://192.168.1.140:5050/api/query) and API key.
  3. Click Save & Close. The status bar at the bottom shows connection state.
TIP Mock mode is perfect for demos and testing. All features work without a backend.
API Endpoint
API Key
Leave endpoint blank for mock simulation mode.
Anthropic API Key (Claude)
Checking…
How to get your own key
  1. OPSIQ uses Anthropic's Claude to turn your plain-English questions into SQL, so each account needs its own Anthropic API key.
  2. Go to console.anthropic.com/settings/keys and sign in (or create an account).
  3. Click Create Key, give it a name (e.g. "OPSIQ"), and copy the key — it starts with sk-ant-. You won't be able to see it again after closing.
  4. Make sure your Anthropic account has billing/credits enabled (Plans & Billing).
  5. Paste the key in the field above and click Save Key. It's stored on your OPSIQ account only and is never shown back to you.
TIP Your key is only used to run your own queries. You can replace or remove it here anytime.
? Quick Guide — CSV Import
  1. Drag & drop a CSV file onto the drop zone, or click to browse.
  2. OPSIQ auto-detects the domain (procurement, production, quality, workforce, maintenance) from your column headers.
  3. Columns are auto-mapped to the governed schema — e.g. "Supplier" maps to vendor_name, "PO#" maps to po_number.
  4. Review the validation summary. Valid rows are ready to commit; errors are listed for review.
TIP Supported formats: CSV, TSV, pipe-delimited. Use a header row. Accepts 70+ common column name variations.
CSV / Flat File Import
Drop CSV file here or click to browse
OPSIQ auto-detects the domain and maps columns to the governed schema.
? Quick Guide — Alerts
  1. Alert rules monitor your ops KPIs against thresholds you set (e.g. "OT > 15%").
  2. Click ENABLE on any Quick Rule template below to activate it instantly.
  3. When a query result triggers a rule, an alert event appears here with severity (critical/warning).
  4. Click ACK to acknowledge an alert. Acknowledged alerts are cleared from the active list.
TIP Alerts auto-evaluate every time you run a query matching the rule's intent. In live mode, alerts can also send email or webhooks.
Active Alerts
No active alerts
Quick Rules
? Quick Guide — Querying
  1. Type a plain English question in the box below, e.g. "Show vendor spend for Q1 by category"
  2. Or click a chip or template card below for a pre-built query
  3. OPSIQ classifies your intent, generates a safe SQL query, and returns formatted results
  4. Results include KPI tiles, data tables, alerts, and an AI narrative summary
  5. Use the CSV, PDF, or SAVE buttons on any result card to export or save
TIP Press Enter to send. Shift+Enter for a new line. Toggle AUTO-SAVE to keep every query.
Ask OPSIQ
AUTO-SAVE
Vendor spend
PO aging
Invoice exceptions
Production vs plan
Asset downtime
ASK ANYTHING
Type a question or pick a template. OPSIQ queries your governed ops data and returns a formatted result.
📊
Vendor Spend
Spend by category, supplier, or period
📋
PO Aging
Open POs by age, vendor, or buyer
⚠️
Invoice Alerts
Over-PO, no-PO, and past-due invoices
🏭
Production Yield
Output vs plan, scrap rates
🔧
Asset Downtime
Downtime hours and costs
👥
Overtime Summary
OT hours by dept or employee
INSPECTR SYNCING
SHIFTLOG
MAINTAINR
REPORTR
MOCK MODE
API NOT CONFIGURED