How do I connect my warehouse to ChatGPT?

Connect Rig to ChatGPT over MCP. Rig builds the context layer over your warehouse, and ChatGPT can then answer data questions with governed SQL.

Does ChatGPT see my raw data?

ChatGPT works through Rig's governed context layer and returns query results, not bulk exports. It sees your schema and metric definitions.

Will ChatGPT give consistent numbers?

Yes. Rig answers from agreed metric definitions and sandbox-validates each query, so answers stay consistent across the team.

Which warehouses are supported with ChatGPT?

Snowflake, BigQuery, Redshift, Postgres and DuckDB/MotherDuck, plus SaaS sources synced through Rig Ingest.

AI tools Supported

ChatGPT + Rig

The easiest way to query your warehouse data in ChatGPT

ChatGPT is OpenAI's AI assistant, which can connect to external data and tools through connectors and MCP.

Try Rig Book a demo

What Rig gives ChatGPT

Once connected, ChatGPT 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 ChatGPT connects to Rig

Rig connects ChatGPT to your warehouse over MCP. ChatGPT can then answer data questions by generating validated SQL against your governed schema and metric catalog, rather than working from raw table dumps.

Query your warehouse in plain English in ChatGPT

With Rig connected, ChatGPT turns a question into validated warehouse SQL using your real schema and metric definitions. Business teams get analyst-grade answers without writing SQL or exporting spreadsheets.

Ask Rig

What was revenue by product line last quarter?
Show new customers by month this year
Which campaigns drove the most pipeline?

Trust the numbers ChatGPT returns

Rig answers from agreed metric definitions and validates each query in a sandbox before running it. That means ChatGPT gives the official number, not a plausible-looking guess built on the wrong column.

Ask Rig

How is qualified pipeline defined here?
Show the SQL behind that figure
Recompute with the official revenue metric

Summarise and report straight from the data

Because ChatGPT can pull live, governed numbers through Rig, it can draft a board summary or a weekly update grounded in the warehouse. The narrative and the numbers come from the same source.

Ask Rig

Write a weekly revenue update from the latest data
Summarise this quarter's growth for the board
Compare this month to last month and explain the change

Keep access governed per user

Rig applies role-based access and inherited warehouse permissions, so what each person can ask ChatGPT to query matches what they are allowed to see. Sensitive columns stay masked.

Ask Rig

What data am I allowed to query?
Show revenue without exposing individual salaries
List the tables available to my role

Frequently asked questions

How do I connect my warehouse to ChatGPT?: Connect Rig to ChatGPT over MCP. Rig builds the context layer over your warehouse, and ChatGPT can then answer data questions with governed SQL.
Does ChatGPT see my raw data?: ChatGPT works through Rig's governed context layer and returns query results, not bulk exports. It sees your schema and metric definitions.
Will ChatGPT give consistent numbers?: Yes. Rig answers from agreed metric definitions and sandbox-validates each query, so answers stay consistent across the team.
Which warehouses are supported with ChatGPT?: Snowflake, BigQuery, Redshift, Postgres and DuckDB/MotherDuck, plus SaaS sources synced through Rig Ingest.