Connect your own agent

Ask your SourceMedium data questions from the AI you already use. Every agent uses one URL and your SourceMedium sign-in. It reads, never writes, and you never paste BigQuery, Shopify, or Meta credentials. Want SourceMedium to write the SQL for you? Use SourceMedium Agent in Slack.

Any workspace member can connect. Sign in with your membership email. The session is read-only and sees only what you already can.

The connection URL

https://mcp.sourcemedium.com/mcp

Keep the /mcp. The AI Agents page in your workspace has it ready to copy and confirms when your agent connects. Another MCP client may work with the same URL; these are the ones we keep steps for.

When you connect SourceMedium to an AI service, queries and the resulting data may be sent to the AI provider you choose. Access remains limited by your existing SourceMedium organization membership and connected-source permissions. This connection does not provide semantic PII detection or field-level masking. Do not request customer contact, address, or other direct personal data unless it is necessary and authorized for your use case.

Chat apps

Claude
ChatGPT

On Team or Enterprise, an Owner first adds SourceMedium under Organization settings → Connectors → Add → Custom → Web. Members then connect it under Customize → Connectors.

Open connectors

In claude.ai, go to Customize → Connectors.

Add the connector

On Free, Pro, or Max, click + and choose Add custom connector. On Team or Enterprise, click Connect on the connector your Owner added and skip the next step.

Paste the URL

Paste https://mcp.sourcemedium.com/mcp, click Add, then Connect.

Ask

In a chat, click +, open Connectors, switch SourceMedium on, and ask.

Claude’s Free plan allows one custom connector.

On paid plans the live pages Claude builds can read SourceMedium through this connection. Each viewer needs their own SourceMedium connection to refresh live charts. Check Claude’s sharing options for your plan and workspace. On Team or Enterprise, an Owner may first need to turn on Dashboards (Organization settings → Artifacts) and artifact connectors (Organization settings → Capabilities).

Vendor guide: Claude custom connectors

Developer mode depends on your plan and workspace policy. No toggle? Ask your workspace admin.

Turn on Developer mode

Settings → Security and login → Developer mode.

Add the connection

On the Plugins page, click +. Name it SourceMedium and paste https://mcp.sourcemedium.com/mcp under Connection.

Create it, review the tools, and complete the SourceMedium sign-in.

Ask

In a new chat, enable the SourceMedium plugin and ask.

Vendor guide: Connect to ChatGPT

Agents

Add it

claude mcp add --transport http sourcemedium https://mcp.sourcemedium.com/mcp

Start Claude Code, run /mcp, pick sourcemedium, and sign in.

Ask

Ask a question about your data.

claude mcp remove keeps your saved token. Run claude mcp logout sourcemedium to clear it.

Vendor guide: Claude Code MCP

Add it

codex mcp add sourcemedium --url https://mcp.sourcemedium.com/mcp

codex mcp login sourcemedium

Ask

Restart Codex and ask. Prefer config? Add this to ~/.codex/config.toml instead of the add command:

[mcp_servers.sourcemedium]
url = "https://mcp.sourcemedium.com/mcp"

Send one message

In a new chat, send:

Connect SourceMedium MCP at https://mcp.sourcemedium.com/mcp

Approve and sign in

Approve adding SourceMedium, then sign in with your SourceMedium email.

Ask

Ask a question about your data.

The AI Agents page with Grok Bot selected, showing the message to send and the account to sign in with

Send one message

In a new chat, send:

Connect SourceMedium MCP at https://mcp.sourcemedium.com/mcp

Approve and sign in

Approve adding SourceMedium, then sign in with your SourceMedium email.

Ask

Ask a question about your data.

Add it

hermes mcp add sourcemedium --url https://mcp.sourcemedium.com/mcp --auth oauth

hermes mcp test sourcemedium

Ask

Ask a question about your data.

Hermes Agent CLI only; the Hermes chat apps have no connector settings.

Vendor guide: Hermes Agent MCP

Add it

Add this to ~/.cursor/mcp.json (or Customize → MCPs → Add New MCP Server):

{
  "mcpServers": {
    "sourcemedium": {
      "url": "https://mcp.sourcemedium.com/mcp"
    }
  }
}

In Cursor’s MCP settings, click Login next to sourcemedium.

Ask

Ask Cursor’s agent a question about your data.

Vendor guide: Cursor MCP

Want your coding agent working in your warehouse directly? Add SourceMedium Agent Skills too: it keeps this connection, and builds dashboards and pipelines with your own gcloud login.

When your agent opens SourceMedium

Every agent above sends you to the same SourceMedium sign-in at its sign-in step:

Continue with Google, or enter the email you use for SourceMedium. Use the same account you use in your workspace.
Click Allow access. One connection reaches one organization. If you belong to more than one, pick it under Organization access. To use a different organization later, open a private window and connect again.

A sign-in step on the AI Agents page, showing the SourceMedium sign-in screen and the Organization access screen with Allow access

If connecting fails

Sign-in failed? Remove SourceMedium, add it again (or resend the message), then sign in.
Claude Code? Run claude mcp logout sourcemedium before adding it again.
401, ACCESS_DENIED, or the wrong organization? See Agent connection troubleshooting.

After you connect

One connection is one organization. In several workspaces? Pick one at sign-in. To switch, open a private window, connect again, and pick the other organization. A normal sign-out keeps the previous choice. In Claude Code, run claude mcp logout sourcemedium before adding the server again so the old token is gone. The AI Agents page lists every agent you’ve connected, and when it was last used:

Your own agent on the AI Agents page, listing Claude and Claude Code with when each connected and was last used

What it can reach

Surface	When
SourceMedium reporting data (`sm_transformed_v2`, `sm_metadata`, and any other SourceMedium dataset `get_data_context` lists)	Always
Other datasets in your BigQuery project	Dedicated project, and you are a direct member. The assistant only queries datasets `get_data_context` lists.
Google Sheets tables in those datasets	Once each sheet is shared with your SourceMedium address. See Google Sheets tables.
SourceMedium docs search	Always
Shopify	Once a store is connected
Meta Ads	Once an ad account is connected

Not connected? That tool answers SOURCE_UNAVAILABLE, and warehouse questions still work. Agency partners with a live grant can connect too; a brand- or store-scoped grant sees only those stores and can’t run raw SQL.

Google Sheets tables

A Google Sheet connected to your BigQuery project as a table works like any other table, once SourceMedium can open the sheet. A sheet starts out unshared. SourceMedium opens sheets as one address for your organization and checks each one for you.

Open AI Agents in SourceMedium. The Google Sheets section lists every Sheets table in your warehouse as Ready, Needs sharing, or Couldn’t check. Copy the address shown there.
For each table that needs sharing, click Open sheet, then Share.
Paste the address, choose Viewer, untick Notify people, and click Share.
Back on AI Agents, click Check again. The table shows Ready.

Just added a Sheets table? Click Check again to see it right away. SourceMedium also rechecks every sheet about every 15 minutes, and get_data_context tells your agent which tables it can’t read yet. Only someone who can share the sheet can do this. Not yours? Ask its owner. A sheet in a SourceMedium shared drive is shared by your SourceMedium team. If your Google Workspace blocks sharing outside your company, your admin has to allow the address first. If your agent queries a sheet before it is shared, it gets PROVIDER_PERMISSION_DENIED. The error links the sheet and gives the address, so the agent can tell you exactly what to share.

Your first question

Paste this in:

Compare net revenue for the last complete week against the week before, using SourceMedium’s own metric definition (query_metrics). Tell me which stores, dates, and timezone you used, and show the definition and any filters.

A good answer names your stores, the right dates, and the definition it used. Checking it against a dashboard? Match dates, timezone, stores, and filters first. The MCP tool reference explains every tool.

Limits

Limit	Value
Warehouse rows	500, then marked truncated
Shopify and Meta records per page	100
BigQuery billed bytes	10 GiB per query
Query time	60 s warehouse, 30 s Shopify and Meta
Response size	256 KiB

MCP tool reference

Every tool, and the order that gets correct answers.

Agent connection troubleshooting

Sign-in errors, source denials, and what to send support.

SourceMedium Agent

Ask in Slack and let SourceMedium write the SQL and charts.

Start here

SourceMedium Agent

SourceMedium Agent Skills

Your own agent

Reference

The connection URL

Chat apps

Agents

When your agent opens SourceMedium

If connecting fails

After you connect

What it can reach

Google Sheets tables

Your first question

Limits

MCP tool reference

Agent connection troubleshooting

SourceMedium Agent

​The connection URL

​Chat apps

​Agents

​When your agent opens SourceMedium

​If connecting fails

​After you connect

​What it can reach

​Google Sheets tables

​Your first question

​Limits

​Related

MCP tool reference

Agent connection troubleshooting

SourceMedium Agent

The connection URL

Chat apps

Agents

When your agent opens SourceMedium

If connecting fails

After you connect

What it can reach

Google Sheets tables

Your first question

Limits

Related