expanso-nightly-backup

Automate nightly database table backups to Google Cloud Storage as compressed Parquet files.

1|Updated Feb 1, 2026

Search Tags:#database #data pipeline #disaster recovery #backup #cloud storage #gcs

Ready to run

npx skills add https://github.com/expanso-io/expanso-skills --skill expanso-nightly-backup

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: expanso-nightly-backup
Source: https://github.com/expanso-io/expanso-skills/tree/main/skills/recipes/nightly-backup
Command: npx skills add https://github.com/expanso-io/expanso-skills --skill expanso-nightly-backup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the process of backing up critical database tables to secure, cost-effective cloud storage, ensuring data resilience and disaster recovery capabilities.

Core Features & Use Cases

Scheduled Backups: Configurable for nightly execution to capture daily changes.
Multi-Table Support: Handles multiple tables within a single pipeline run.
Cloud Storage Integration: Directly outputs compressed Parquet files to Google Cloud Storage (Nearline/Glacier equivalent).
Data Integrity: Includes checksum verification for backup integrity.
Use Case: Regularly back up your orders and inventory tables from an on-premise PostgreSQL database to GCS Nearline, ensuring business continuity.

Quick Start

Run the nightly backup pipeline using the provided shell script.

Frequently Asked Questions about expanso-nightly-backup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I automate nightly database backups to Google Cloud Storage?▼

Automate nightly database backups to Google Cloud Storage by running a scheduled pipeline that exports tables like orders and inventory directly into compressed Parquet files. This process supports both incremental and full backups with automatic date partitioning.

What is the best way to back up PostgreSQL tables for disaster recovery?▼

Backing up PostgreSQL tables for disaster recovery is best handled by exporting critical data to compressed Parquet format in cloud storage. This approach includes checksum verification to ensure backup integrity and supports date partitioning for efficient data archival.

Does this database backup pipeline support incremental exports with checksum verification?▼

Yes, the database backup pipeline supports incremental exports alongside full backups. It includes checksum verification for every run to guarantee data integrity, ensuring your date-partitioned Parquet files in cloud storage remain reliable for disaster recovery.

Can I back up multiple database tables in a single pipeline run?▼

Yes, you can back up multiple database tables in a single pipeline run. The automated backup process handles multi-table support, capturing daily changes from tables like orders, inventory, and order items simultaneously to streamline your nightly data archival.

Why use compressed Parquet files with date partitioning for cloud storage backups?▼

Compressed Parquet files with date partitioning are used for cloud storage backups to optimize storage costs and query performance. This format efficiently organizes incremental and full database snapshots, making disaster recovery archives easier to manage and retrieve.

How do I run the nightly backup pipeline for my database tables?▼

Run the nightly backup pipeline for your database tables by executing the provided shell script. This script automates the extraction of tables like orders and inventory, outputting them as compressed Parquet files directly to Google Cloud Storage.