pgclimb
A PostgreSQL utility to export data into different formats like JSON, CSV, XLSX, and XML with custom template support.
What is pgclimb?
pgclimb is a command-line tool for exporting data from PostgreSQL databases into various structured formats like JSON, CSV, XLSX, and XML. It serves as a flexible alternative to `psql` and `COPY TO` for data extraction, enabling users to publish datasets, generate reports, and create APIs. The tool supports custom templates for generating formats such as HTML or Markdown, and it automatically handles nested JSON serialization from complex queries.
Database administrators, data engineers, and developers who need to regularly extract and transform PostgreSQL data for reporting, API creation, or data distribution. It is particularly useful for those who require multi-format exports beyond basic CSV or JSON, such as Excel reports or custom templated outputs.
Developers choose pgclimb over alternatives because it offers built-in support for multiple output formats (including XLSX and XML) without requiring manual aggregation, and it provides extensibility through Go templates for custom formats. Its ability to automatically serialize complex queries into nested JSON structures and generate Excel files with multiple sheets simplifies data export workflows compared to using `psql` or `COPY TO` alone.
Overview
Export data from PostgreSQL into different data formats
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
