Export Query Results as CSV
pg_copy_csvExport PostgreSQL query results as CSV with headers. Customize delimiter and null representation, with row limit control.
Instructions
Execute a SELECT query and return the results formatted as CSV with headers.
Args:
sql: SELECT statement to export (required — must be read-only)
limit: Maximum rows to export, 1-5000 (default: 1000)
delimiter: CSV field delimiter character (default: ',')
null_value: String to use for NULL values in CSV output (default: '')
Returns: CSV text with header row. Suitable for copy-paste into spreadsheets or piping to files.
Errors:
Rejected if non-SELECT statement provided
Returns error if query fails
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SELECT query to export as CSV | |
| limit | No | Max rows (default: 1000, max: 5000) | |
| delimiter | No | CSV delimiter character (default: comma) | , |
| null_value | No | Value to use for NULL fields |