# MySQL

MySQL is a popular open-source relational database management system. With Coupler.io, you can automatically export data from any MySQL table or view to Google Sheets, Excel, BigQuery, Looker Studio, or even AI destinations like Claude and ChatGPT — on a schedule that works for you.

## Why connect MySQL to Coupler.io?

* **No SQL expertise required** — select a table or view and export it in minutes
* **Keep data fresh** — schedule automatic refreshes so your spreadsheets and dashboards always have the latest data
* **Send to your favorite tools** — export to Google Sheets, Excel, BigQuery, Looker Studio, Claude, ChatGPT, Cursor, Gemini, Perplexity, or OpenClaw
* **Multiple tables in one flow** — combine data from different MySQL tables using Join or Append transformations

## Prerequisites

* A MySQL database (version 5.7 or later)
* Database credentials: hostname, port, username, and password
* The database user must have SELECT permission on the table(s) you want to export
* If your MySQL server is behind a firewall, you'll need to allow Coupler.io's IP addresses

## Quick start

{% hint style="success" %}
If your MySQL database is hosted on a cloud provider (AWS RDS, Google Cloud SQL, Azure, etc.) or behind a firewall, whitelist these IP addresses in your firewall or security group before connecting: **52.21.222.113** and **35.170.113.181**.
{% endhint %}

{% stepper %}
{% step %}
**Log in to Coupler.io** and create a new data flow. Choose MySQL as your source.
{% endstep %}

{% step %}
**Enter your MySQL connection details:**

* **Host** — the hostname or IP address of your MySQL server (e.g., `localhost`, `192.168.1.100`, or `mysql.example.com`)
* **Port** — the port number (default is 3306)
* **Username** — the database user account
* **Password** — the user's password

Click **Test connection** to verify your credentials are correct.
{% endstep %}

{% step %}
**Select your database and table.** Enter the database name and choose the table or view you want to export from the dropdown.
{% endstep %}

{% step %}
**Choose your destination.** Pick where you want the data to go — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like Claude or ChatGPT.
{% endstep %}

{% step %}
**Run the data flow.** Click **Run** to execute your first export. Once it completes successfully, you can schedule automatic refreshes.
{% endstep %}
{% endstepper %}

## Need help with IP whitelisting?

If your MySQL server is behind a firewall or security group, whitelist these IPs:

* **52.21.222.113**
* **35.170.113.181**

For AWS RDS, add these IPs to your security group's inbound rules (port 3306, TCP). For Google Cloud SQL, add them to your authorized networks. For other hosting providers, check their documentation on how to whitelist external IPs.