How does this skill prevent data loss during the archival process?

It utilizes transaction handling and mandatory verification steps, ensuring records are only deleted from the source table once their presence in the archive is confirmed via checksums and row counts.

Can I set custom archival criteria?

Yes, you can define specific criteria such as record age (e.g., older than 1 year), status flags, access frequency, or any other business logic applicable to your data.

Does it support periodic automation?

Yes, the skill includes steps for scheduling periodic archival jobs (weekly or monthly) and configuring automated monitoring for these tasks.

What storage destinations are supported for archival?

The skill supports archiving to local archive tables, separate archive databases, and cloud storage providers including AWS S3, Azure Blob Storage, and Google Cloud Storage (GCS).

Database Archival System

Name: Database Archival System
Author: jeremylongshore

byjeremylongshore

•

983

•

Database Management

Automates the migration of historical database records to archive tables or cloud cold storage to optimize database performance.

The Database Archival System skill provides a comprehensive framework for managing data retention and reducing primary database bloat. It guides users through the entire archival lifecycle—from defining age-based criteria and choosing destinations like S3 or Azure Blob Storage to executing transactional migrations and verifying data integrity. This skill is essential for teams looking to maintain high performance in production databases while ensuring historical data remains accessible and compliant for long-term storage.

Key Features

01Pre-configured templates for PostgreSQL and MySQL archival workflows

02983 GitHub stars

03Built-in data integrity verification using checksums and row count audits

04Comprehensive monitoring for storage savings and job success rates

05Automated data migration to archive tables, S3, Azure Blob, or GCS

06Transaction-safe execution to prevent data loss during migration

Use Cases

01Reducing production database size to improve query speed and backup times

02Implementing regulatory data retention policies by moving old records to cold storage

03Offloading high-volume log data to cost-effective cloud storage solutions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills archiving-databases

For use in Claude.ai and ChatGPT

Download Skill