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

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.

1

Log in to Coupler.io and create a new data flow. Choose MySQL as your source.

2

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.

3

Select your database and table. Enter the database name and choose the table or view you want to export from the dropdown.

4

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.

5

Run the data flow. Click Run to execute your first export. Once it completes successfully, you can schedule automatic refreshes.

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.