managing-database-partitions

## Overview This skill automates the design, implementation, and management of database table partitioning strategies. It helps optimize query performance, manage time-series data, and reduce maintenance windows for massive datasets. ## How It Works 1. **Analyze Requirements**: Claude analyzes the user's request to understand the specific partitioning needs, including data size, query patterns, and maintenance requirements. 2. **Design Partitioning Strategy**: Based on the analysis, Claude designs an appropriate partitioning strategy (e.g., range, list, hash) and determines the optimal partition key. 3. **Implement Partitioning**: Claude generates the necessary SQL scripts or configuration files to implement the partitioning strategy on the target database. 4. **Optimize Queries**: Claude provides guidance on optimizing queries to take advantage of the partitioning scheme, including suggestions for partition pruning and index creation. ## When to Use This Skill This skill activates when you need to: - Manage tables exceeding 100GB with slow query performance. - Implement time-series data archival strategies (IoT, logs, metrics). - Optimize queries that filter by date ranges or specific values. - Reduce database maintenance windows. ## Examples ### Example 1: Optimizing Time-Series Data User request: "Create database partitions for my IoT sensor data to improve query performance." The skill will: 1. Analyze the data schema and query patterns for the IoT sensor data. 2...