MCP.directory

archiving-databases

by jeremylongshore
0
0
Source

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

mkdir -p .claude/skills/archiving-databases && curl -L -o skill.zip "https://mcp.directory/api/skills/download/9373" && unzip -o skill.zip -d .claude/skills/archiving-databases && rm skill.zip

Installs to .claude/skills/archiving-databases

About this skill

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

  1. Identify Archival Candidates: The skill identifies database records that meet the specified archival criteria based on age, size, or other relevant factors.
  2. 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.
  3. Policy Enforcement: The skill enforces automated retention policies, ensuring that data is archived or deleted according to pre-defined rules.
  4. 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:

  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.

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:

  1. Configure automated retention policies to identify user activity logs older than 90 days.
  2. 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.

More by jeremylongshore

View all skills by jeremylongshore →

d2-diagram-creator

jeremylongshore

D2 Diagram Creator - Auto-activating skill for Visual Content. Triggers on: d2 diagram creator, d2 diagram creator Part of the Visual Content skill category.

6532

svg-icon-generator

jeremylongshore

Svg Icon Generator - Auto-activating skill for Visual Content. Triggers on: svg icon generator, svg icon generator Part of the Visual Content skill category.

9029

automating-mobile-app-testing

jeremylongshore

This skill enables automated testing of mobile applications on iOS and Android platforms using frameworks like Appium, Detox, XCUITest, and Espresso. It generates end-to-end tests, sets up page object models, and handles platform-specific elements. Use this skill when the user requests mobile app testing, test automation for iOS or Android, or needs assistance with setting up device farms and simulators. The skill is triggered by terms like "mobile testing", "appium", "detox", "xcuitest", "espresso", "android test", "ios test".

15922

performing-penetration-testing

jeremylongshore

This skill enables automated penetration testing of web applications. It uses the penetration-tester plugin to identify vulnerabilities, including OWASP Top 10 threats, and suggests exploitation techniques. Use this skill when the user requests a "penetration test", "pentest", "vulnerability assessment", or asks to "exploit" a web application. It provides comprehensive reporting on identified security flaws.

4915

designing-database-schemas

jeremylongshore

Design and visualize efficient database schemas, normalize data, map relationships, and generate ERD diagrams and SQL statements.

12014

ollama-setup

jeremylongshore

Configure auto-configure Ollama when user needs local LLM deployment, free AI alternatives, or wants to eliminate hosted API costs. Trigger phrases: "install ollama", "local AI", "free LLM", "self-hosted AI", "replace OpenAI", "no API costs". Use when appropriate context detected. Trigger with relevant phrases based on skill purpose.

5110

You might also like

flutter-development

aj-geddes

Build beautiful cross-platform mobile apps with Flutter and Dart. Covers widgets, state management with Provider/BLoC, navigation, API integration, and material design.

1,4071,302

drawio-diagrams-enhanced

jgtolentino

Create professional draw.io (diagrams.net) diagrams in XML format (.drawio files) with integrated PMP/PMBOK methodologies, extensive visual asset libraries, and industry-standard professional templates. Use this skill when users ask to create flowcharts, swimlane diagrams, cross-functional flowcharts, org charts, network diagrams, UML diagrams, BPMN, project management diagrams (WBS, Gantt, PERT, RACI), risk matrices, stakeholder maps, or any other visual diagram in draw.io format. This skill includes access to custom shape libraries for icons, clipart, and professional symbols.

1,2201,024

ui-ux-pro-max

nextlevelbuilder

"UI/UX design intelligence. 50 styles, 21 palettes, 50 font pairings, 20 charts, 8 stacks (React, Next.js, Vue, Svelte, SwiftUI, React Native, Flutter, Tailwind). Actions: plan, build, create, design, implement, review, fix, improve, optimize, enhance, refactor, check UI/UX code. Projects: website, landing page, dashboard, admin panel, e-commerce, SaaS, portfolio, blog, mobile app, .html, .tsx, .vue, .svelte. Elements: button, modal, navbar, sidebar, card, table, form, chart. Styles: glassmorphism, claymorphism, minimalism, brutalism, neumorphism, bento grid, dark mode, responsive, skeuomorphism, flat design. Topics: color palette, accessibility, animation, layout, typography, font pairing, spacing, hover, shadow, gradient."

9001,013

godot

bfollington

This skill should be used when working on Godot Engine projects. It provides specialized knowledge of Godot's file formats (.gd, .tscn, .tres), architecture patterns (component-based, signal-driven, resource-based), common pitfalls, validation tools, code templates, and CLI workflows. The `godot` command is available for running the game, validating scripts, importing resources, and exporting builds. Use this skill for tasks involving Godot game development, debugging scene/resource files, implementing game systems, or creating new Godot components.

958658

nano-banana-pro

garg-aayush

Generate and edit images using Google's Nano Banana Pro (Gemini 3 Pro Image) API. Use when the user asks to generate, create, edit, modify, change, alter, or update images. Also use when user references an existing image file and asks to modify it in any way (e.g., "modify this image", "change the background", "replace X with Y"). Supports both text-to-image generation and image-to-image editing with configurable resolution (1K default, 2K, or 4K for high resolution). DO NOT read the image file first - use this skill directly with the --input-image parameter.

970608

pdf-to-markdown

aliceisjustplaying

Convert entire PDF documents to clean, structured Markdown for full context loading. Use this skill when the user wants to extract ALL text from a PDF into context (not grep/search), when discussing or analyzing PDF content in full, when the user mentions "load the whole PDF", "bring the PDF into context", "read the entire PDF", or when partial extraction/grepping would miss important context. This is the preferred method for PDF text extraction over page-by-page or grep approaches.

1,033496

Related MCP Servers

Browse all servers
Google GenAI ToolboxGoogle GenAI Toolbox

Google GenAI Toolbox: open-source GenAI database agent and AI database connector for Google Cloud database—query Cloud S

13,3270 tools
Claude ContextClaude Context

Claude Context offers semantic code search and indexing with vector embeddings and AST-based code splitting. Natural lan

5,5770 tools
PlaywrightPlaywright

Playwright automates web browsers for web scraping, scraping, and internet scraping, enabling you to scrape any website

5,29132 tools
Mobile NextMobile Next

Mobile Next offers fast, seamless mobile automation for iOS and Android. Automate apps, extract data, and simplify mobil

3,75219 tools
CipherCipher

Cipher empowers agents with persistent memory using vector databases and embeddings for seamless context retention and t

3,5590 tools
Supabase MCP ServerSupabase MCP Server

Connect Supabase projects to AI with Supabase MCP Server. Standardize LLM communication for secure, efficient developmen

2,5160 tools

Stay ahead of the MCP ecosystem

Get weekly updates on new skills and servers.