Multiple output formats for database dump

October 15, 2025

You can now export your Vitess database data in multiple formats using the new --output-format flag with the pscale database dump command.

The new flag supports three output formats:

• sql (default) - MySQL INSERT statements for direct import
• json - JSONL format with one JSON object per line
• csv - CSV format with headers for easy analysis

# Export as JSON
pscale database dump my-database main --output-format=json

# Export as CSV  
pscale database dump my-database main --output-format=csv

# Export as SQL (default)
pscale database dump my-database main --output-format=sql

This feature is available for Vitess databases only.

Thanks to @ivov for contributing this feature!

Read more