archiving-databases

## Overview This skill provides a streamlined way to archive database records, freeing up space on the primary database and ensuring compliance with data retention policies. It automates the process of moving historical data to more cost-effective storage solutions while maintaining query access. ## How It Works 1. **Identify Archival Candidates**: The skill identifies database records that meet the specified archival criteria based on age, size, or other relevant factors. 2. **Data Migration**: It migrates the identified records to archive tables within the same database or to cold storage solutions like S3, Azure Blob, or GCS. 3. **Policy Enforcement**: The skill enforces automated retention policies, ensuring that data is archived or deleted according to pre-defined rules. 4. **Verification and Reporting**: After the archival process, the skill verifies the successful migration of data and generates reports for compliance tracking. ## When to Use This Skill This skill activates when you need to: - Reduce the size of a primary database. - Implement data retention policies for compliance. - Move historical data to cost-effective storage solutions. ## Examples ### Example 1: Archiving Old Order Data User request: "I need to archive order data older than one year from my PostgreSQL database to S3 to reduce database size and comply with retention policies." The skill will: 1. Identify order records older than one year in the PostgreSQL database. 2. Migrate these record...