skills.rest
jeremylongshore
jeremylongshoreCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

archiving-databases

Archive historical database records to cold storage with retention policies.

2.6k|379|Updated Oct 10, 2025
Search Tags:#database#compliance#archival#PostgreSQL#MySQL#data retention#cost optimization#cold storage
One-click install
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill archiving-databases
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: archiving-databases
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/database/database-archival-system/skills/database-archival-system
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill archiving-databases

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

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.

Core Features & Use Cases

  • Automated Data Migration: Move historical data to archive tables or cold storage (S3, Azure Blob, GCS).
  • Retention Policy Enforcement: Automatically apply and enforce data retention rules.
  • Space & Cost Reduction: Reduce primary database size and storage costs.
  • Use Case: Archive order data older than one year from a PostgreSQL database to S3, reducing database load and meeting compliance.

Quick Start

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 records to an S3 bucket, compressing the data for storage efficiency.

Frequently Asked Questions about archiving-databases

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

FAQPage Schema
How do I archive old database records to reduce storage costs?▼

Database archival automates moving historical records from your primary database to cold storage like S3 or Azure Blob, freeing up space and cutting storage costs while keeping archived data queryable. This skill handles the migration, compression, and retention policy enforcement for PostgreSQL and MySQL deployments.

Can I archive PostgreSQL and MySQL data to cloud storage without downtime?▼

Yes, this skill enables zero-downtime migration of historical data from PostgreSQL and MySQL to cloud storage such as S3, Azure Blob, or GCS. It automatically identifies archival candidates, migrates them with compression, and maintains data integrity throughout the process.

How do I enforce data retention policies and ensure compliance with archival?▼

Archival automation enforces retention rules by identifying records meeting age or criteria thresholds, migrating them to archive targets, and generating compliance reports. It tracks the full data lifecycle across on-premises and cloud storage, satisfying regulatory retention requirements.

What's the best way to migrate historical order data from PostgreSQL to S3?▼

Identify orders older than your retention threshold, compress and migrate them to an S3 bucket in a single automated workflow, then validate data integrity. This skill handles candidate identification, zero-downtime migration, compression, and compliance tracking end to end.

Do I need to rewrite queries to access archived database data?▼

No, archived data remains queryable through the archival mechanism. The skill preserves access patterns while moving historical records to cold storage, so your application queries work without modification after archival completes.

What happens if archival fails mid-migration?▼

The skill validates data integrity before and after migration to catch failures early. If issues occur, archival can be paused or rolled back without affecting the primary database, since the process supports zero-downtime operation with built-in safeguards.

Related Skills

Explore More Software Engineering Skills→
cornmanwtfcornmanwtf

data-lake-architecture

Organizes cloud object storage via automated tiering, archiving, deletion lifecycle policies.

Community
Intermediate
marquesfelipmarquesfelip

customer-offboarding

Automate end-to-end customer offboarding workflows for SaaS platforms.

Community
Advanced
JaveedIshaqJaveedIshaq
1

Data Management Skill

Manage database data lifecycle with migrations, backups, retention, and compliance.

Community
Advanced
patricio0312revpatricio0312rev
5

data-retention-archiving-planner

Plan and enforce data retention and archival policies across hot and cold storage.

Community
Advanced