How do I choose a good shard key?

The skill provides criteria for identifying stable, frequently queried keys and offers examples for both user-based and multi-tenant composite keys.

Can I use this for cross-shard querying?

Yes, it includes patterns for distributed queries using PostgreSQL Foreign Data Wrappers (FDW) and cross-shard aggregation functions.

Does it help with shard rebalancing?

Absolutely. It provides step-by-step SQL patterns for adding new shards, migrating data using hash functions, and updating configuration without downtime.

What sharding strategies does this skill support?

The skill supports implementation patterns for range-based sharding, hash-based sharding (including consistent hashing), and directory-based lookup sharding.

Database Sharding Architect

Name: Database Sharding Architect
Author: aj-geddes

byaj-geddes

•

Database Management

Implements horizontal data partitioning and sharding strategies to scale large-scale database architectures across multiple servers.

This skill provides Claude with specialized patterns and implementation logic for architecting sharded database systems, enabling horizontal scalability for data-intensive applications. It covers critical strategies including range-based, hash-based, and directory-based sharding, while providing guidance on shard key selection, consistent hashing, and complex cross-shard query patterns. Developers can use this skill to design resilient distributed systems that handle high throughput and massive datasets while maintaining performance through effective data isolation and load balancing.

Key Features

01Expert guidance on shard key selection and composite key architecture

02Shard health monitoring and distribution analysis scripts

03Distributed query patterns for cross-shard data aggregation and joins

04Implementation of multiple sharding strategies including Range, Hash, and Directory patterns

05Automated shard rebalancing and migration workflows for system expansion

0618 GitHub stars

Use Cases

01Designing high-availability distributed database clusters for global applications

02Implementing strict multi-tenant data isolation and geographic data residency

03Scaling application databases that have exceeded single-server storage or throughput limits

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aj-geddes/useful-ai-prompts database-sharding

For use in Claude.ai and ChatGPT

Download Skill