Every accepted workspace member can connect. Admins, Editors, and Viewers all get a read-only session scoped to what they can already reach in SourceMedium.
How to connect
1
Copy the connection URL from Settings
In your SourceMedium workspace, open Settings and find AI assistant access. Copy the connection URL.The production URL is:The path
/mcp is required. Use this exact URL as the connector in your AI client.2
Add it as a remote MCP server
In the assistant, add a connector / remote MCP server and paste the URL. When it asks you to sign in, use your existing SourceMedium account. The exact menu name varies by product. Look for MCP, connectors, or custom tools.
3
Pick an organization if you belong to more than one
One connection is one organization. If you work across several SourceMedium workspaces, pick the one this assistant should use. Reconnect to switch organizations.
4
Approve the SourceMedium sign-in screen
After you approve, the assistant can call SourceMedium. The first successful request appears under Your connected assistants on the Settings card, with an Active or Idle status.
What the assistant can reach
The Settings card lists exactly what this organization can reach. If only reporting data is listed, Shopify and Meta are not enabled yet. Warehouse questions still work.
Agency partners with a live grant can connect too. An organization-level grant sees the whole org. A brand- or store-scoped grant is narrowed to those stores, and cannot run raw SQL (
run_bigquery_sql).
How to ask
Ask in plain language. The assistant has seven read-only tools and its instructions tell it to look every name up before writing SQL:get_data_context first, then search the catalog, then query_metrics for a named SourceMedium metric.
That last step is the one worth knowing about. query_metrics compiles SourceMedium’s own definition and keeps filters such as is_order_sm_valid applied, so the number matches your dashboards. A hand-written revenue or ROAS query will not, and the answer will not warn you.
See What the MCP tools do for the full list and how to tell a good answer from a guessed one.
Limits
All tools are read-only. Writes, exports, and other projects are refused.
Coding agents
A local or IDE-hosted agent that can attach a remote MCP server uses the same connection URL as any other client. We do not keep a roster of those runtimes: if it can register the URL above and complete the SourceMedium sign-in, it is in. Optional agent skills are only for coding agents that load skills. Chat products do not need them. The MCP tools already describe how to query.Related
What the MCP tools do
The seven tools, the order that gets correct answers, and the column name assistants guess wrong.
MCP troubleshooting
Sign-in errors, source denials, and what to send support.
Slack AI Analyst
Ask in Slack when you want SourceMedium to write the SQL and charts for you.

