managing-database-sharding

## Overview This skill empowers Claude to design and implement horizontal database sharding strategies. It guides the user through the process of distributing data across multiple database instances, ensuring scalability and performance for applications handling large datasets and high query loads. ## How It Works 1. **Strategy Design**: Analyzes the application's data model and access patterns to determine the optimal sharding key and sharding strategy (e.g., range-based, hash-based). 2. **Implementation Planning**: Generates a detailed plan for implementing the chosen sharding strategy, including database schema modifications, data migration procedures, and application code changes. 3. **Cross-Shard Query Coordination**: Provides guidance on implementing cross-shard query coordination mechanisms to ensure data consistency and accuracy across multiple shards. ## When to Use This Skill This skill activates when you need to: - Scale a database beyond the capacity of a single server. - Distribute write load across multiple database servers. - Improve database performance by reducing contention. ## Examples ### Example 1: Scaling an E-commerce Product Catalog User request: "Implement database sharding for my e-commerce product catalog to handle increased traffic and product listings." The skill will: 1. Analyze the product catalog's data model and access patterns. 2. Recommend a hash-based sharding strategy based on product ID. 3. Generate a plan for migrating the produ...