SourceMedium Agent Skills

For power users with coding agents (Claude Code, Codex, Cursor). The skills give your agent direct access to your warehouse, not a fixed set of tools: query your data directly, join your own data, build dashboards, pipelines, and apps, or plug it into your existing workflows. You’ll use a terminal, the gcloud CLI, and the Google account you sign in to SourceMedium with.

Skills or your own agent? Use both

	Your own agent (MCP)	SourceMedium Agent Skills
Works in	Any agent, chat or coding	Coding agents in a terminal
Access	SourceMedium sign-in; no BigQuery access needed	Your own `gcloud` login, as the Google account you use for SourceMedium
Best for	SourceMedium’s metric definitions, connection health, live Shopify and Meta data	SQL on your warehouse, joins to your own tables, dashboards, pipelines

Using a coding agent? Connect it as your own agent, then install the skills. They cover different ground.

Quick start

Paste this into a coding agent that can install skills.

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-brand]
My first question is: [ask your question here]

Install

npx skills add source-medium/skills --skill sm-bigquery-analyst
npx skills add source-medium/skills --skill sm-dashboard-builder
npx skills add source-medium/skills --skill sm-pipeline-builder

Start with the analyst. Add the others when you need them; both assume BigQuery access already works. Add --global to install for every workspace. No automatic install in your agent? Copy the skill folder into its skills directory.

Update

Already installed? Update before using the dashboard builder, the pipeline builder, or newer helper scripts:

npx skills update sm-bigquery-analyst -y
npx skills update sm-dashboard-builder -y
npx skills update sm-pipeline-builder -y

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

SM Pipeline Builder

Build data pipelines you own that land in your own BigQuery datasets alongside SourceMedium data. Writes a validated pipeline spec first, then loads incrementally with checks that catch silent failures. For technical staff running their own infrastructure.

Then ask

Try:

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.

For pipelines you own:

Design a nightly pipeline that loads our loyalty platform into our own
BigQuery datasets. Probe the API first, then show me the spec before
loading anything.

Your agent finds your tables, writes the SQL, and shows its receipts.

BigQuery Access Request Template

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

Start here