--- title: "PostgreSQL Integration for Rig: Query PostgreSQL Data in Plain English" description: "Connect PostgreSQL to Rig and query your PostgreSQL data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/postgres" format: markdown --- Browse integrations ![PostgreSQL logo](https://img.logo.dev/postgresql.org?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) Warehouses & databases Supported # PostgreSQL integration for Rig ## The easiest way to query PostgreSQL in Claude and other AI tools PostgreSQL is a widely used open-source relational database that powers both operational apps and analytics workloads, including managed versions like Supabase and Amazon RDS. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) ## What Rig sees in PostgreSQL Once connected, Rig models these objects so questions resolve to the right tables and joins: - Schemas and tables - Views and materialized views - Foreign keys and constraints - Indexes - Functions - Row counts and table stats ## How PostgreSQL connects to Rig Rig connects to Postgres with a read-only role and reads the catalog to build a context layer over your tables and relationships. For app databases, Rig Ingest can also replicate Postgres into your analytics warehouse on a schedule, so reporting queries never touch production. ## Query your Postgres app database in plain English Rig reads your Postgres schema, including foreign keys, and builds a context layer so the join paths are known. A product manager can ask how many trial users converted last week and get a correct answer without learning the table structure. Ask Rig - How many trials converted to paid last week? - Show daily new accounts from the Postgres users table - Which features do retained users adopt first? ## Replicate Postgres into your warehouse for reporting Rig Ingest can copy your Postgres tables into Snowflake, BigQuery or Redshift on a schedule, so heavy analytics queries run against the warehouse instead of your production database. Schema changes are tracked, so new columns appear without manual pipeline work. Ask Rig - Sync the orders and users tables into the warehouse nightly - Has the schema of the subscriptions table changed? - Build a revenue report from the replicated Postgres data ## Work with Supabase and RDS data the same way Managed Postgres like Supabase and Amazon RDS connect identically. Rig understands the standard catalog, so you can query auth tables, app tables and analytics tables together with consistent definitions. Ask Rig - Show sign-ups by week from the Supabase auth schema - Join app events to billing in the RDS database - What is the activation rate by cohort? ## Ask Postgres questions from Claude, Cursor or ChatGPT Rig serves your Postgres database to AI assistants over MCP with read-only governance. The assistant answers from your modelled schema, so engineers and operators can investigate data without opening a SQL client. Ask Rig - Find users who hit an error in the last 24 hours - What is the funnel from signup to first action? - Pull the join path from accounts to invoices ## Ask your PostgreSQL data in Claude, ChatGPT or Cursor Rig serves your PostgreSQL data to AI assistants over MCP. Once PostgreSQL is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL. - [Claude](https://rig.so/integrations/claude) - [Claude Code](https://rig.so/integrations/claude-code) - [Cursor](https://rig.so/integrations/cursor) - [ChatGPT](https://rig.so/integrations/chatgpt) - [Codex](https://rig.so/integrations/codex) - [Gemini](https://rig.so/integrations/gemini) ## Frequently asked questions Does Rig query my production Postgres directly? It can, read-only, or Rig Ingest can replicate Postgres into your warehouse so analytics queries run off production. You choose per database. Does Rig support Supabase and Amazon RDS? Yes. Any standard PostgreSQL, including managed Supabase and RDS instances, connects the same way with a read-only role. Can I query Postgres in Claude or ChatGPT? Yes. Rig exposes Postgres to AI assistants over MCP, so you can ask plain-English questions and get governed SQL answers. How does Rig know the joins in my Postgres schema? Rig reads foreign keys and the catalog to learn relationships, and you can refine join paths in the context layer so answers stay correct. ## Related integrations [![Amazon Redshift logo](https://img.logo.dev/aws.amazon.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Amazon RedshiftPlain-English analytics over your Redshift cluster, governed and validated.](https://rig.so/integrations/redshift)[![BigQuery logo](https://img.logo.dev/cloud.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)BigQueryAsk questions of your BigQuery datasets from Claude, ChatGPT or Cursor.](https://rig.so/integrations/bigquery)[![Databricks logo](https://img.logo.dev/databricks.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)DatabricksQuery your Databricks lakehouse in plain English from any AI tool.](https://rig.so/integrations/databricks)[![Microsoft SQL Server logo](https://img.logo.dev/microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Microsoft SQL ServerPlain-English questions over SQL Server and Azure SQL, governed by Rig.](https://rig.so/integrations/sql-server)[![MotherDuck logo](https://img.logo.dev/motherduck.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)MotherDuckPlain-English analytics over MotherDuck and DuckDB, served to any AI tool.](https://rig.so/integrations/motherduck)[![MySQL logo](https://img.logo.dev/mysql.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)MySQLNatural-language access to your MySQL database, or sync it to the warehouse.](https://rig.so/integrations/mysql) ## Connect PostgreSQL data to AI tools like Claude 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/postgres) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)