Which cloud providers are supported for off-site archiving?

The system supports Amazon S3, Azure Blob Storage, and Google Cloud Storage (GCS) through integrated CLI tools.

How do I define which records get archived?

You can define archival criteria based on age thresholds (e.g., older than 1 year), status flags, or any custom SQL-based business logic.

Does this skill ensure data is not lost during the move?

Yes, the skill implements transactional handling and verification queries to confirm data integrity at the destination before any records are deleted from the source table.

Can I archive data into a different table instead of cloud storage?

Absolutely. You can choose to archive records to a separate table within the same database or a dedicated archive database.

Database Archival System

Name: Database Archival System
Author: BbgnsurfTech

byBbgnsurfTech

•

数据库管理

Automates the transfer of historical database records to archive tables or cold storage to optimize performance and reduce primary storage costs.

The Database Archival System skill provides a comprehensive framework for managing data lifecycle policies by identifying, extracting, and moving aging records from production databases to secondary storage solutions like S3, Azure Blob, or dedicated archive tables. It automates the creation of archive schemas, execution of archival scripts, and verification of data integrity, ensuring that primary databases remain lean and performant while maintaining full compliance with data retention requirements and storage efficiency standards.

主要功能

01Built-in data integrity verification using checksums and row counts

02Multi-cloud support for archival to AWS S3, Azure Blob, and GCS

03Support for optimized storage formats including Parquet, CSV, and JSON

04Automated identification of archival candidates based on age or status

053 GitHub stars

06Transactional 'move' logic ensuring data is only deleted after successful archival

使用场景

01Implementing automated data retention policies for legal and regulatory compliance

02Improving production query performance by offloading billions of historical records

03Reducing primary database size to lower infrastructure costs and improve backup speed

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-archival-system

For use in Claude.ai and ChatGPT

Download Skill