archiving-databases
About
This skill automates database archival for PostgreSQL and MySQL, moving historical records to cold storage (e.g., S3) to reduce primary database size. It implements retention policies, compression, and zero-downtime migrations. Use it for managing data lifecycle, compliance, and optimizing database performance.
Quick Install
Claude Code
Recommended/plugin add https://github.com/jeremylongshore/claude-code-plugins-plusgit clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/archiving-databasesCopy and paste this command in Claude Code to install this skill
Documentation
Overview
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.
How It Works
- Identify Archival Candidates: The skill identifies database records that meet the specified archival criteria based on age, size, or other relevant factors.
- Data Migration: It migrates the identified records to archive tables within the same database or to cold storage solutions like S3, Azure Blob, or GCS.
- Policy Enforcement: The skill enforces automated retention policies, ensuring that data is archived or deleted according to pre-defined rules.
- Verification and Reporting: After the archival process, the skill verifies the successful migration of data and generates reports for compliance tracking.
When to Use This Skill
This skill activates when you need to:
- Reduce the size of a primary database.
- Implement data retention policies for compliance.
- Move historical data to cost-effective storage solutions.
Examples
Example 1: Archiving Old Order Data
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:
- Identify order records older than one year in the PostgreSQL database.
- Migrate these records to an S3 bucket, compressing the data for storage efficiency.
Example 2: Setting Up Automated Retention Policies
User request: "Set up automated retention policies for my MySQL database to archive user activity logs older than 90 days to a separate archive table."
The skill will:
- Configure automated retention policies to identify user activity logs older than 90 days.
- Create an archive table within the MySQL database and migrate the identified logs to it.
Best Practices
- Data Validation: Always validate the archived data to ensure data integrity.
- Compression: Utilize compression techniques to minimize storage costs in cold storage solutions.
- Monitoring: Implement monitoring to track the performance and success of archival processes.
Integration
This skill integrates well with other database management tools and cloud storage services. It can be used in conjunction with monitoring tools to track database performance and storage utilization after archival.
GitHub Repository
Related Skills
sglang
MetaSGLang is a high-performance LLM serving framework that specializes in fast, structured generation for JSON, regex, and agentic workflows using its RadixAttention prefix caching. It delivers significantly faster inference, especially for tasks with repeated prefixes, making it ideal for complex, structured outputs and multi-turn conversations. Choose SGLang over alternatives like vLLM when you need constrained decoding or are building applications with extensive prefix sharing.
langchain
MetaLangChain is a framework for building LLM applications using agents, chains, and RAG pipelines. It supports multiple LLM providers, offers 500+ integrations, and includes features like tool calling and memory management. Use it for rapid prototyping and deploying production systems like chatbots, autonomous agents, and question-answering services.
Algorithmic Art Generation
MetaThis skill helps developers create algorithmic art using p5.js, focusing on generative art, computational aesthetics, and interactive visualizations. It automatically activates for topics like "generative art" or "p5.js visualization" and guides you through creating unique algorithms with features like seeded randomness, flow fields, and particle systems. Use it when you need to build reproducible, code-driven artistic patterns.
webapp-testing
TestingThis Claude Skill provides a Playwright-based toolkit for testing local web applications through Python scripts. It enables frontend verification, UI debugging, screenshot capture, and log viewing while managing server lifecycles. Use it for browser automation tasks but run scripts directly rather than reading their source code to avoid context pollution.