How does this skill ensure data was moved correctly?

The skill includes a verification and reporting phase that confirms successful data migration and generates reports for compliance and audit tracking.

Which databases does this skill support?

This skill currently supports PostgreSQL and MySQL databases for automated archival and migration processes.

Can I define custom retention periods for different tables?

Yes, you can configure specific automated retention policies based on record age, data size, or other metadata criteria to match your business requirements.

Where can I move my archived database records?

You can migrate data to internal archive tables or external cold storage providers including Amazon S3, Azure Blob Storage, and Google Cloud Storage (GCS).

Does archiving data cause application downtime?

No, the skill is designed to implement archival workflows and data migrations with zero downtime, ensuring your primary database remains accessible.

Database Archival & Retention

Name: Database Archival & Retention
Author: intent-solutions-io

byintent-solutions-io

0•

Database Management

Automates the archival of historical database records to cold storage or archive tables to optimize performance and ensure regulatory compliance.

This skill streamlines data lifecycle management by automatically identifying, migrating, and verifying historical records from primary PostgreSQL and MySQL databases. By offloading aged data to cost-effective cold storage solutions like Amazon S3, Azure Blob, or Google Cloud Storage, it significantly reduces primary database size and operational costs while maintaining data integrity. It is an essential tool for engineering teams needing to enforce automated retention policies, handle high-volume transaction logs, and maintain zero-downtime migration workflows for large-scale production systems.

Key Features

01Automated identification of archival-ready historical records

02Multi-cloud support for S3, Azure Blob, and GCS cold storage

03Customizable automated data retention and compliance policies

04Verification reporting for data integrity and audit trails

05Zero-downtime data migration and table compression

060 GitHub stars

Use Cases

01Reducing primary database size to improve query performance and lower costs

02Enforcing regulatory compliance by moving sensitive logs to secure cold storage

03Automating the cleanup of high-volume transaction tables based on record age

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla skill-adapter

For use in Claude.ai and ChatGPT

Download Skill