---
title: "ChatGPT + Rig: Query Your Warehouse Data in ChatGPT"
description: "Connect your warehouse to ChatGPT with Rig. Ask data questions in plain English and get governed, validated SQL answers. Snowflake, BigQuery, Redshift, Postgres and more."
canonical: "https://rig.so/integrations/chatgpt"
format: markdown
---

Browse integrations

![ChatGPT logo](https://img.logo.dev/openai.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true)

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](https://app.rig.so/signup)[Book a demo](https://rig.so/book-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

You add Rig to ChatGPT as a custom connector: copy your workspace MCP URL from Rig, paste it into ChatGPT's connector settings, and approve the OAuth prompt. ChatGPT then answers data questions by generating validated SQL against your governed schema and metric catalog, rather than working from raw table dumps, and every query runs under your role-based access rules.

[Read the step-by-step guide to connecting Rig to ChatGPT](https://rig.so/guides/connect-ai-tools)

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

## Related integrations

[![Claude logo](https://img.logo.dev/claude.ai?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)ClaudeAsk questions of your warehouse in Claude, with governed SQL behind every answer.](https://rig.so/integrations/claude)[![Claude Code logo](https://img.logo.dev/claude.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Claude CodeQuery and build with warehouse data from the Claude Code terminal.](https://rig.so/integrations/claude-code)[![Cursor logo](https://img.logo.dev/cursor.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)CursorBring governed warehouse data into Cursor for data-aware coding.](https://rig.so/integrations/cursor)[![Google Gemini logo](https://img.logo.dev/gemini.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Google GeminiQuery your warehouse from Gemini and the Gemini CLI with governed SQL.](https://rig.so/integrations/gemini)[![OpenAI Codex logo](https://img.logo.dev/openai.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)OpenAI CodexGive Codex governed access to your warehouse for data-aware coding.](https://rig.so/integrations/codex)[![VS Code logo](https://img.logo.dev/visualstudio.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)VS CodeQuery your warehouse from VS Code and GitHub Copilot over MCP.](https://rig.so/integrations/vs-code)

## Connect your warehouse to ChatGPT

Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust.

[Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo)

---

- [This page as HTML](https://rig.so/integrations/chatgpt)
- [Site map for language models](https://rig.so/llms.txt)
- [API and agent documentation](https://rig.so/developers)