secondsky avatar

Database Sharding

This is a solid sharding implementation guide that covers hash, range, and directory strategies with working TypeScript routers you can actually use. It's strongest on the gotchas: wrong shard key selection causing hotspots, cross-shard transactions without two-phase commit, and the modulo rebalancing trap that breaks all your keys when you add a fifth shard. The shard key criteria checklist is genuinely helpful (high cardinality, immutable, in 80% of queries). If you're hitting billions of records or need multi-tenant isolation, this walks you through the decision tree and gives you production patterns from companies like Instagram and Discord. The error catalog is worth reading even if you're not implementing sharding yet.

skills.sh installs
277
GitHub stars
248
last updated
Aug 21, 2026

Install

$ npx -y skills add secondsky/claude-skills --skill database-sharding --agent claude-code

Installs into .claude/skills of the current project.

Files

This is a solid sharding implementation guide that covers hash, range, and directory strategies with working TypeScript routers you can actually use. It's strongest on the gotchas: wrong shard key selection causing hotspots, cross-shard transactions without two-phase commit, and the modulo rebalancing trap that breaks all your keys when you add a fifth shard. The shard key criteria checklist is genuinely helpful (high cardinality, immutable, in 80% of queries). If you're hitting billions of records or need multi-tenant isolation, this walks you through the decision tree and gives you production patterns from companies like Instagram and Discord. The error catalog is worth reading even if you're not implementing sharding yet.

Browse the repository on GitHub

Sponsors

Details

Repository
github.com/secondsky/claude-skills
Categories
Backend & APIs, Databases
First seen
Jun 3, 2026

More from secondsky/claude-skills

All 146
1patricio0312rev avatarbackend-latency-profiler-helperpatricio0312rev/skillsIdentifies API latency hotspots and bottlenecks with profiling tools, slow endpoint detection, suspected causes, and fix roadmap. Use for "latency profiling", "272skills.sh installs
2rmyndharis avatarbackend-architectrmyndharis/antigravity-skillsExpert backend architect specializing in scalable API design, microservices architecture, and distributed systems. Masters REST/GraphQL/gRPC APIs, event-driven 270skills.sh installs
3davila7 avataruniprot-databasedavila7/claude-code-templatesDirect REST API access to UniProt. Protein searches, FASTA retrieval, ID mapping, Swiss-Prot/TrEMBL. For Python workflows with multiple databases, prefer bioser269skills.sh installs
4davila7 avatarmetabolomics-workbench-databasedavila7/claude-code-templatesAccess NIH Metabolomics Workbench via REST API (4,200+ studies). Query metabolites, RefMet nomenclature, MS/NMR data, m/z searches, study metadata, for metabolo264skills.sh installs
5awslabs avataraws-lambdaawslabs/agent-pluginsDesign, build, deploy, test, and debug serverless applications with AWS Lambda. Triggers on phrases like: Lambda function, event source, serverless application,260skills.sh installs
6martinholovsky avatarapi-expertmartinholovsky/claude-skills-generatorExpert API architect specializing in RESTful API design, GraphQL, gRPC, and API security. Deep expertise in OpenAPI 3.1, authentication patterns (OAuth2, JWT), 257skills.sh installs