--- title: "MongoDB Integration for Rig: Query MongoDB Data in Plain English" description: "Connect MongoDB to Rig and query your MongoDB data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/mongodb" format: markdown --- Browse integrations ![MongoDB logo](https://img.logo.dev/mongodb.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) Warehouses & databases Supported # MongoDB integration for Rig ## The easiest way to query MongoDB in Claude and other AI tools MongoDB is a document database, available self-hosted or as the managed MongoDB Atlas service, that stores records as JSON-like documents in collections. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) ## What Rig sees in MongoDB Once connected, Rig models these objects so questions resolve to the right tables and joins: - One table per collection - Child tables for nested arrays - The collections you choose ## How MongoDB connects to Rig Rig Ingest connects with a read-only connection string over TLS, reads from a secondary when one exists, and mirrors your collections into your warehouse on a schedule. Collections with an updated-at field sync edits as well as new documents. [Read the step-by-step MongoDB setup guide](https://rig.so/guides/connect-mongodb) ## Analyse application data without querying production Product data in MongoDB is hard to analyse with SQL tools. Rig mirrors each collection into a table in your warehouse, so analysts query a copy and the application database is left alone. Ask Rig - How many documents are in each collection? - Which records were created or changed this week? - Show new users per day for the last 30 days ## Flatten nested documents into queryable tables Documents often hold arrays of sub-records. Rig lands nested arrays as child tables, so a question about line items or events does not need custom parsing. Ask Rig - Which collections have nested arrays, and what do the child tables hold? - Join an order table to its line-item child table - Count child rows per parent document ## Join application data to CRM and billing A MongoDB user or account collection usually shares a key with your CRM and billing systems. With all of them in one warehouse, you can connect product behaviour to commercial records. Ask Rig - Which customers in our CRM also appear in the application database? - Compare signups in the app with new accounts in billing - Show product records for accounts that churned ## Ask your MongoDB data in Claude, ChatGPT or Cursor Rig serves your MongoDB data to AI assistants over MCP. Once MongoDB 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 What does Rig need to connect to MongoDB? A connection string for a read-only user, and the database name. On Atlas, add Rig's IP address under Network Access first. Can I limit which collections sync? Yes. List collection names in the Collections field. For a hard boundary, scope the MongoDB user's role as well. Does a sync put load on my primary? Reads go to a secondary when one exists, unless your connection string sets a read preference. Is the connection encrypted? Yes. TLS is on for Atlas and by default for other servers, and certificate checks cannot be turned off. ## 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)[![BigQuery shared datasets logo](https://img.logo.dev/cloud.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)BigQuery shared datasetsMirror a BigQuery dataset a vendor or partner has shared with you.](https://rig.so/integrations/bigquery-dataset)[![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 Fabric logo](https://img.logo.dev/fabric.microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Microsoft FabricIngest tables from a Fabric Warehouse or Lakehouse SQL endpoint.](https://rig.so/integrations/microsoft-fabric)[![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) ## Connect MongoDB 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/mongodb) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)