Which databases are supported by this skill?

This skill provides specialized support for PostgreSQL and MySQL databases using integrated bash tools for command execution.

How does the skill ensure data is not lost during archival?

The process includes transaction handling that ensures data is only deleted from the source table after successful extraction and verification at the destination.

Can this skill handle very large datasets without timing out?

Yes, the skill provides logic to split archival tasks into smaller, manageable batches and suggests execution during low-traffic maintenance windows.

Where can I store my archived data?

Data can be moved to local archive tables, secondary databases, or cloud-based cold storage including AWS S3, Azure Blob Storage, and Google Cloud Storage (GCS).

Does it support data compression?

Yes, the skill includes configurations for storage efficiency, such as compression settings and specific data formats like Parquet and CSV for cloud storage.

Database Archival System

Name: Database Archival System
Author: Brmbobo

byBrmbobo

Gestión de Bases de Datos

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

Acerca de

The Database Archival System skill empowers Claude to manage large-scale data retention strategies by identifying historical records and safely migrating them to archive tables or cloud providers like AWS S3, Azure Blob Storage, and GCS. It streamlines the entire archival lifecycle—from defining age thresholds and schema creation to integrity verification and automated scheduling—ensuring primary databases remain lean and performant while maintaining strict data compliance and business requirements.

Características Principales

Multi-database support for PostgreSQL and MySQL archival tasks
Customizable schema creation for structured archive storage
Automated retention policy scheduling and error handling
0 GitHub stars
Automated data migration to S3, Azure Blob, and Google Cloud Storage
Data integrity verification using checksums and row count validation

Casos de Uso

Implementing automated data retention policies for regulatory and industry compliance
Migrating historical transaction logs or audit trails to cost-effective cold storage
Reducing primary database size to improve query performance and lower infrastructure costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brmbobo/web2podcast archiving-databases

For use in Claude.ai and ChatGPT

Download Skill

GitHub