MySQL to CSV to FTP: Nightly Table Export Template
A scheduled Spojit workflow that runs a MySQL query every night, turns the rows into a CSV file, and uploads it to an FTP server for your reporting partners.
What It Builds
A Schedule trigger fires the workflow on a nightly cron. A MySQL Connector node in Direct mode runs your SELECT query, the CSV utility converts the result rows into a delimited file, and an FTP Connector node uploads that file to a remote directory. The outcome is a fresh export waiting on the partner's server each morning, with no manual dumps.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every night at 1 AM, queries my MySQL database for yesterday's order rows, converts the result set to a CSV file with a header row, and uploads the file to the /reports folder on my FTP server named with today's date.Connectors Used
- Schedule trigger - fires the workflow on a nightly cron in your chosen timezone.
- MySQL - runs the SELECT query and returns the rows in Direct mode.
- CSV - converts the rows into a delimited file with headers.
- FTP - uploads the generated file to the partner's directory.
Customize It
Change the cron time, the SELECT statement, the date window, the /reports path, or the filename pattern directly in the prompt so the export matches your partner's expectations. You can also switch the delimiter to a tab or pipe by saying so in the prompt.
Tips
- Keep the MySQL node in Direct mode so the exact query runs every time with no AI cost.
- Use a parameterized date range so each run only pulls the prior day's records.
- Confirm the FTP connection has write access to the target directory before going live.