Does this skill help with database migration?

Yes, it provides patterns for sharding, data distribution, and online DDL migrations (expand-contract) to ensure zero-downtime transitions in distributed environments.

Which databases are covered by this skill?

The skill provides guidance for 12 major technologies including CockroachDB, YugabyteDB, TiDB, Google Spanner, Vitess, PlanetScale, Citus, SingleStore, OceanBase, Neon, and AlloyDB.

How does it handle performance optimization?

It identifies common distributed anti-patterns such as primary key hotspots, inefficient cross-shard joins, and connection pooling issues that impact performance at scale.

Can it help me choose between different NewSQL options?

Absolutely. It includes a comprehensive comparison table covering consistency models, Postgres/MySQL compatibility, and HTAP capabilities to guide architectural decisions.

NewSQL & Distributed Database Expert

Name: NewSQL & Distributed Database Expert
Author: rnavarych

byrnavarych

•

Database Management

Provides production-level guidance and implementation patterns for 12 major NewSQL and distributed SQL database technologies.

This skill equips Claude with deep operational knowledge for architecting and managing globally distributed SQL databases. It covers critical configurations for platforms like CockroachDB, YugabyteDB, and TiDB, offering expertise in multi-region topologies, sharding strategies, HTAP workloads, and CAP theorem trade-offs. Whether you are migrating to a distributed system or optimizing existing horizontal scaling, this skill provides the reference patterns, anti-pattern warnings, and database-specific commands needed for high-availability production environments.

Key Features

01Anti-pattern detection for distributed sharding and serializable isolation

02Deep technical comparison of 12 NewSQL databases including consistency models

03Guidance on Change Data Capture (CDC) and online DDL migrations

04HTAP (Hybrid Transactional/Analytical Processing) workload optimization

05Multi-region topology and geo-partitioning implementation strategies

069 GitHub stars

Use Cases

01Designing a globally distributed SQL architecture for high availability and low latency.

02Migrating a monolith SQL database to a sharded architecture like Vitess or Citus.

03Optimizing performance and avoiding hotspots in CockroachDB or YugabyteDB clusters.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer newsql-distributed

For use in Claude.ai and ChatGPT

Download Skill