Skip to main content
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)

Copy the block below and paste it into Claude Code, Cursor, Windsurf, or any skills-compatible agent.
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

# 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: 
npx skills update sm-bigquery-analyst -y
npx skills update sm-dashboard-builder -y

​
Available 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.

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.

​
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.

BigQuery Access Request Template

Copy/paste request for internal admins when you do not have BigQuery access yet.