intent-solutions-io/archiving-databases
010-archive/backups-20251108/skill-structure-cleanup-20251108-073936/plugins/database/database-archival-system/skills/database-archival-system/SKILL.md
This skill automates database archival processes. It helps reduce primary database size by moving historical records to archive tables or cold storage solutions like S3, Azure Blob, or GCS. The plugin supports PostgreSQL and MySQL, implementing automated retention policies, compression, compliance tracking, and zero-downtime migration. Use this when the user mentions "database archival", "archive old database records", "retention policies", "cold storage", or "reduce database size." It is particularly useful for handling requests related to data lifecycle management and compliance requirements in database systems.
$ install --global
skillsauthnpx skillsauth add intent-solutions-io/plugins-nixtla archiving-databasesInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 24, 2026, 8:38 PM1.8s1 file scanned
SKILL.md
- name:
- archiving-databases
- description:
- |
- allowed-tools:
- Read, Write, Edit, Grep, Glob, Bash
- version:
- 1.0.0
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.
Related Skills
intent-solutions-io/managing-test-environments
testing
VerifiedTrustedCommunity
This skill enables Claude to manage isolated test environments using Docker Compose, Testcontainers, and environment variables. It is used to create consistent, reproducible testing environments for software projects. Claude should use this skill when the user needs to set up a test environment with specific configurations, manage Docker Compose files for test infrastructure, set up programmatic container management with Testcontainers, manage environment variables for tests, or ensure cleanup after tests. Trigger terms include "test environment", "docker compose", "testcontainers", "environment variables", "isolated environment", "env-setup", and "test setup".
6SKILL.mdUpdated Jun 5, 2026
intent-solutions-io/generating-test-doubles
tools
VerifiedTrustedCommunity
This skill uses the test-doubles-generator plugin to automatically create mocks, stubs, spies, and fakes for unit testing. It analyzes dependencies in the code and generates appropriate test doubles based on the chosen testing framework, such as Jest, Sinon, or others. Use this skill when you need to generate test doubles, mocks, stubs, spies, or fakes to isolate units of code during testing. Trigger this skill by requesting test double generation or using the `/gen-doubles` or `/gd` command.
6SKILL.mdUpdated Jun 5, 2026
intent-solutions-io/generating-test-data
tools
VerifiedTrustedCommunity
This skill enables Claude to generate realistic test data for software development. It uses the test-data-generator plugin to create users, products, orders, and custom schemas for comprehensive testing. Use this skill when you need to populate databases, simulate user behavior, or create fixtures for automated tests. Trigger phrases include "generate test data", "create fake users", "populate database", "generate product data", "create test orders", or "generate data based on schema". This skill is especially useful for populating testing environments or creating sample data for demonstrations.
6SKILL.mdUpdated Jun 5, 2026
intent-solutions-io/analyzing-test-coverage
development
VerifiedTrustedCommunity
This skill analyzes code coverage metrics to identify untested code and generate comprehensive coverage reports. It is triggered when the user requests analysis of code coverage, identification of coverage gaps, or generation of coverage reports. The skill is best used to improve code quality by ensuring adequate test coverage and identifying areas for improvement. Use trigger terms like "analyze coverage", "code coverage report", "untested code", or the shortcut "cov".
6SKILL.mdUpdated Jun 5, 2026