Turn your data into AI tools.

-- Tool: get_quarterly_revenue
-- Source: PostgreSQL (production-db)

SELECT
  SUM(amount) AS revenue,
  COUNT(*) AS transactions
FROM orders
WHERE
  quarter = {{ quarter }}
  AND year = {{ year }}
  AND status = 'completed'

-- Tool: user_cohort_analysis
-- Source: Snowflake (analytics-warehouse)

SELECT
  DATE_TRUNC('month', created_at) AS cohort_month,
  COUNT(DISTINCT user_id) AS users,
  SUM(CASE WHEN retained THEN 1 ELSE 0 END) AS retained_users
FROM user_events
WHERE
  segment = {{ segment }}
  AND created_at >= DATEADD('month', -{{ months }}, CURRENT_DATE)
GROUP BY 1
ORDER BY 1

-- Tool: marketing_attribution
-- Source: BigQuery (marketing-data)

SELECT
  utm_source,
  utm_campaign,
  COUNT(*) AS conversions,
  SUM(revenue) AS attributed_revenue
FROM `project.analytics.conversions`
WHERE
  DATE(converted_at) BETWEEN
    DATE_SUB(CURRENT_DATE(), INTERVAL {{ days }} DAY)
    AND CURRENT_DATE()
  AND channel = {{ channel }}
GROUP BY 1, 2
ORDER BY attributed_revenue DESC

# Tool: inventory_lookup
# Source: Google Sheets (product-catalog)

spreadsheet: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms"
sheet: "Inventory"
lookup:
  key_column: "SKU"
  key_value: "{{ sku }}"
  return_columns:
    - "Product Name"
    - "Current Stock"
    - "Reorder Point"
    - "Warehouse Location"

# Tool: check_order_status
# Source: REST API (shipping-api)

method: GET
path: /v1/orders/{{ order_id }}/tracking
query:
  format: summary
  carrier: "{{ carrier }}"

# The API key lives on the source, encrypted at rest.