FAQ

Can I export the results of a custom SQL query?

Not directly in Coupler.io — you must select a table or view. However, you can create a MySQL view that runs your custom query, then export that view. For example:

CREATE VIEW my_custom_view AS
SELECT order_id, customer_name, total
FROM orders
WHERE status = 'completed'
AND created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY);

Then in Coupler.io, select that view as your table. This gives you the flexibility of custom SQL with the simplicity of Coupler.io's interface.

Can I export multiple MySQL tables in one data flow?

Yes! Use Join or Append transformations to combine data from multiple tables:

• Join — if you have a customers table and an orders table, you can join them on customer_id to export orders with customer details side-by-side

• Append — if you have similar tables (e.g., sales_q1, sales_q2), you can stack them into one export

Add these transformations in Coupler.io after selecting your first table.

What if my MySQL database is behind a VPN or corporate firewall?

You must whitelist Coupler.io's IP addresses:

• 52.21.222.113

• 35.170.113.181

Contact your IT or database administrator to add these IPs to your firewall rules. Once whitelisted, the connection should work immediately.

Can I use SSH tunneling to connect?

SSH tunneling is not currently supported in Coupler.io. If your MySQL database is not directly accessible, you have two options:

1. Whitelist Coupler.io's IPs in your firewall or security group

2. Create a database user with remote access if your hosting provider allows it

If neither is possible, contact our support team to discuss alternatives.

How often can I schedule exports?

You can schedule data flows to run as frequently as every hour. However, for large tables (millions of rows), start with a daily schedule to ensure exports complete reliably. Once confirmed, you can increase frequency.

What happens if my MySQL database goes down during a scheduled export?

The data flow will fail, and you'll see a failed status in Coupler.io. Your destination (Google Sheets, BigQuery, etc.) will not be updated. Once your database is back online, the next scheduled run will attempt the export again. You can also manually trigger a run using the Run button.

Can I export data to Google Sheets, Excel, BigQuery, and a spreadsheet simultaneously?

Yes! In your data flow, you can add multiple destinations. Set up the first destination, then click Add another destination to send the same data to multiple tools.

Can I send MySQL data directly to Claude or ChatGPT?

Yes! Select an AI destination (Claude, ChatGPT, Cursor, Gemini, Perplexity, or OpenClaw) instead of a spreadsheet or database. Your MySQL data will be exported and sent to the AI for analysis, summarization, or insights.

How do I filter data by a date range that updates automatically?

Use Coupler.io's date picker in the filter settings. Instead of hardcoding dates, select a dynamic range like "Last 30 days" or "This month." The filter recalculates with each scheduled run, so your export always contains recent data.

My MySQL table has millions of rows. How do I export it without timeouts?

Apply filters to reduce the volume:

1. Filter by date — export the last 30 or 90 days instead of all history

2. Filter by status — export only active or completed records

3. Split into multiple flows — create one flow per month or per status value

4. Optimize indexes — ensure indexes exist on filtered columns (created_at, status, etc.)

Start with a manual run to test, then schedule if it completes successfully.

Can I append data from multiple MySQL databases into one export?

Yes! Create two separate data flows (one for each database), export to a temporary location, then use the Append transformation to combine them. Alternatively, if both databases are on the same server, you can join tables across databases using the fully qualified table name: database_name.table_name.

I'm using AWS RDS. How do I allow Coupler.io to connect?

1. Open your RDS instance in the AWS console

2. Go to Security groups (or VPC security groups)

3. Edit the inbound rule for MySQL (port 3306)

4. Add a new rule: Type = MySQL/Aurora, Protocol = TCP, Port = 3306, Source = 52.21.222.113/32 and 35.170.113.181/32

5. Save and test the connection in Coupler.io

For more detailed connection steps, see the README. For troubleshooting specific errors, check Common Issues. For optimization tips, visit Best Practices.