CSV, Scheduled Exports, and Backups

Export a Query to CSV

1. Write or select the query to export.
2. Click Export query to CSV in the query toolbar.
3. Choose the destination file.
4. SSH Bridge runs the query and writes the returned columns and rows to CSV.

Import CSV or TSV

Open a table and use its result-grid import action. Select a CSV or TSV file, confirm the delimiter and header behavior, map source fields to database columns, and preview the import. SSH Bridge stages the generated insert statements in a change query tab for review.

Schedule CSV Exports

1. Write or select the query you want to export.
2. Open Scheduled Exports and choose Schedule Current Query.
3. Select a destination directory, schedule name, file prefix, and interval.
4. Choose Every 15 minutes, Hourly, Every 6 hours, Daily, or Weekly.

Schedules are device-aware and run only while that database window remains open and connected. The schedule list shows its next run and last error, and lets you enable, disable, run now, or delete a schedule. Generated filenames include a timestamp.

Backup and Restore Availability

• SQLite — Backup and restore use local database-file copies.
• PostgreSQL — Requires pg_dump and pg_restore in the desktop application's PATH.
• MySQL — Requires mysqldump and mysql.
• MongoDB — Requires mongodump and mongorestore.
• Redis — Backup requires redis-cli; restore is not offered as a safe local-file workflow.
• SQL Server and Oracle — Backup and restore are not currently offered by this desktop workflow.

Native backup tools cannot currently reuse a database profile's SSH tunnel. Restore operations can overwrite existing data and always require confirmation.