> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Agent Skills

> Installable skills for coding agents that work with SourceMedium data

Agent Skills package repeatable workflows that help coding agents assist with SourceMedium data analysis. Install or update the skills, then your agent can handle setup verification, SQL generation, and result validation.

## Quick Start (Copy/Paste)

<Tip>
  Copy the block below and paste it into Claude Code, Cursor, Windsurf, or any skills-compatible agent.
</Tip>

```
Install the SourceMedium BigQuery Analyst skill and help me verify my setup:

1. Run: npx skills add source-medium/skills --skill sm-bigquery-analyst
2. Run setup verification to confirm my BigQuery access is working.
3. Discover available tables, stores, and metrics.
4. Answer my first question with a SQL receipt.

My project is: sm-[your-tenant-id]
My first question is: [ask your question here]
```

***

## Install

```bash theme={null}
# Install individually
npx skills add source-medium/skills --skill sm-bigquery-analyst
npx skills add source-medium/skills --skill sm-dashboard-builder

# Or install both
npx skills add source-medium/skills --skill sm-bigquery-analyst
npx skills add source-medium/skills --skill sm-dashboard-builder
```

The `skills` CLI installs into supported agent environments. If your agent does not support automatic install, copy the skill folder into that agent's configured skills directory.

## Update

If you already installed these skills, update to the latest version before using the dashboard builder or newer BigQuery helper scripts:

```bash theme={null}
npx skills update sm-bigquery-analyst -y
npx skills update sm-dashboard-builder -y
```

***

## Available Skills

<CardGroup cols={1}>
  <Card title="SM BigQuery Analyst" icon="database" href="/ai-analyst/agent-skills/sm-bigquery-analyst">
    Query SourceMedium BigQuery safely. Verifies setup, discovers tables and metrics, generates SELECT-only cost-guarded SQL, and returns auditable SQL receipts. Supports hybrid joins to your own warehouse tables.
  </Card>

  <Card title="SM Dashboard Builder" icon="chart-line" href="/ai-analyst/agent-skills/sm-dashboard-builder">
    Build accurate BI dashboards from SourceMedium data. Defines metric contracts, validates SQL, and produces portable HTML dashboards with SQL receipts. Also handles Metabase handoff and BI tool queries.
  </Card>
</CardGroup>

***

## After Installing

Ask your coding agent questions like:

```
What was my revenue by channel last month?
```

```
Show me new customer acquisition by source over the past 30 days.
```

```
What's my customer LTV by cohort?
```

For dashboards:

```
Build an HTML executive dashboard with revenue, orders, AOV, ad spend,
and MER for the last 30 days. Validate all queries first.
```

Your agent will discover your data, generate correct SQL, and return auditable receipts — not guesses.

***

## Related

<CardGroup cols={1}>
  <Card title="BigQuery Access Request Template" icon="key" href="/ai-analyst/agent-skills/bigquery-access-request-template">
    Copy/paste request for internal admins when you do not have BigQuery access yet.
  </Card>
</CardGroup>