--- title: "MySQL Integration for Rig: Query MySQL Data in Plain English" description: "Connect MySQL to Rig and query your MySQL data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/mysql" format: markdown --- Browse integrations ![MySQL logo](https://img.logo.dev/mysql.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) Warehouses & databases Supported # MySQL integration for Rig ## The easiest way to query MySQL in Claude and other AI tools MySQL is one of the most widely deployed open-source relational databases, common behind web applications and managed services like Amazon Aurora and PlanetScale. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) ## What Rig sees in MySQL Once connected, Rig models these objects so questions resolve to the right tables and joins: - Schemas and tables - Views - Foreign keys - Indexes - Stored procedures - Table statistics ## How MySQL connects to Rig Rig connects to MySQL with a read-only user and reads the information schema to build a context layer over your tables and relationships. Rig Ingest can also replicate MySQL into your analytics warehouse so reporting does not load the application database. ## Query MySQL data without writing SQL Rig reads your MySQL schema and builds a context layer so questions resolve to correct joins. An operations lead can ask for yesterday's completed orders by status and get the answer without touching a SQL client. Ask Rig - How many orders completed yesterday by status? - Show weekly active users from the MySQL app database - Which products sell most in each region? ## Replicate MySQL into your warehouse Rig Ingest copies MySQL tables into Snowflake, BigQuery or Redshift on a schedule, so analytics queries run against the warehouse and your application database stays responsive. Schema drift is tracked automatically. Ask Rig - Sync the transactions table into the warehouse hourly - Did any columns change in the customers table? - Report on revenue from the replicated MySQL data ## Work with Aurora and PlanetScale the same way Managed MySQL like Amazon Aurora and PlanetScale connect identically. Rig understands the standard information schema, so sharded or managed deployments behave like any other source in the context layer. Ask Rig - Show order growth from the Aurora cluster - Join sessions to purchases in the PlanetScale database - What is the repeat purchase rate this quarter? ## Ask MySQL questions in Claude, Cursor or ChatGPT Rig serves MySQL to AI assistants over MCP, read-only, so engineers and analysts can investigate data inside the tools they already use without exposing write access. Ask Rig - Find accounts with failed payments in the last week - Build a funnel from cart to checkout - Pull the join path from users to orders ## Ask your MySQL data in Claude, ChatGPT or Cursor Rig serves your MySQL data to AI assistants over MCP. Once MySQL 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 support managed MySQL like Aurora or PlanetScale? Yes. Any standard MySQL, including Amazon Aurora and PlanetScale, connects with a read-only user the same way. Can Rig keep analytics off my production MySQL? Yes. Rig Ingest can replicate MySQL into your warehouse so heavy reporting queries run there instead of the application database. Is access to MySQL read-only? Yes. Rig connects read-only and validates every query in a sandbox before running it. Can I query MySQL in an AI assistant? Yes. Rig exposes MySQL to Claude, ChatGPT, Cursor and other MCP clients for plain-English questions. ## 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)[![PostgreSQL logo](https://img.logo.dev/postgresql.org?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)PostgreSQLAsk questions of your Postgres database, or replicate it into your warehouse.](https://rig.so/integrations/postgres) ## Connect MySQL 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/mysql) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)