database-sharding

What problem does it solve?

This Skill provides comprehensive database sharding patterns for PostgreSQL/MySQL, enabling horizontal scaling, multi-tenant isolation, and handling billions of records with hash, range, and directory strategies. It reduces complexity by offering concrete routing and governance rules for shard keys, queries, and rebalancing.

Core Features & Use Cases

• Hash-based sharding for even distribution across shards
• Range-based sharding for time-series or sequential data
• Directory-based sharding for multi-tenant or tenant-specific routing
• Clear guidance on shard key selection, distribution, and immutability
• Patterns and templates for building shard routers and rebalancing strategies

Quick Start

1. Pick a sharding strategy template (hash, range, or directory) and implement a router for your keys.
2. Identify shard keys with high cardinality and immutability; design a router that targets a single shard when possible.
3. Plan for rebalancing with consistent hashing or directory routing to minimize data movement.