Windsurf + Rig
The easiest way to query your warehouse data in Windsurf
Windsurf is an AI-native code editor with an agentic assistant that connects to external tools and data over MCP.
What Rig gives Windsurf
Once connected, Windsurf can reason over your governed data through Rig:
- Warehouse tables and views
- Metric definitions
- Join paths
- dbt lineage
- Role-based access
- Sandbox-validated SQL
How Windsurf connects to Rig
Add Rig as an MCP server in Windsurf. Its agent can then query your warehouse with governed SQL, so the code it writes and the answers it gives are grounded in real, validated data.
Code against your real warehouse schema
With Rig connected, Windsurf's agent reads your actual tables, joins and metric definitions while it builds. It writes queries and components against real data instead of inventing column names.
- Build an endpoint returning revenue by month
- Generate the SQL for active accounts and wire it in
- What columns are in the subscriptions table?
Answer data questions in the editor
Windsurf can run ad-hoc data questions through Rig inline, returning validated numbers without leaving the editor.
- How many active users this week?
- Show a sample of the orders table
- Find the join from users to invoices
Keep queries governed and safe
Rig validates each query in a sandbox and runs read-only, so Windsurf's agent cannot touch production or run an unbounded scan. Answers use agreed metric definitions.
- Validate this query before running it
- Recompute with the official churn metric
- Add a limit and re-run that
Prototype on production-accurate numbers
Because the data Windsurf sees is the governed warehouse, prototypes match production reporting and use the same metric definitions the business relies on.
- Mock this chart with live revenue numbers
- Compare my calculation to the official metric
- Explain how lifetime value is defined here
Frequently asked questions
- How do I connect Windsurf to my warehouse?
- Add Rig as an MCP server in Windsurf. Rig builds the context layer over your warehouse and Windsurf's agent can then query it with governed SQL.
- Can Windsurf build on my real schema?
- Yes. With Rig connected, Windsurf reads your real tables, joins and metric definitions and builds against them.
- Is warehouse access read-only?
- Yes. Rig connects read-only and sandbox-validates each query before it runs.
- Which warehouses are supported?
- Snowflake, BigQuery, Redshift, Postgres and DuckDB/MotherDuck, plus SaaS sources synced by Rig Ingest.
Related integrations
Connect your warehouse to Windsurf
Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust.