Name: vitess
Rating: 90.6 (1 reviews)
Author: planetscale

vitess

Vitess best practices, query optimization, and connection troubleshooting for PlanetScale Vitess databases. Load when working with Vitess databases, sharding, VSchema configuration, keyspace management, or MySQL scaling issues.

1.16x

Quality

81%

Does it follow best practices?

Impact

93%

1.16x

Average score across 8 eval scenarios

Securityby

Passed

No known issues

Evaluation results

88%

12%

Multi-Tenant SaaS Database Sharding Design

VSchema design and sharding strategy

Criteria

Without context

With context

Shared primary vindex

50%

60%

Join co-location

70%

80%

xxhash vindex type

100%

Vitess Sequences defined

60%

Sequence in unsharded keyspace

90%

80%

auto_increment linked

100%

Reference table for products

100%

Reference table for tenants

100%

Email lookup vindex

100%

Lookup vindex owner set

100%

No foreign keys in design

62%

100%

Optimize Slow Queries for a Sharded E-Commerce Database

Query optimization for sharded tables

Criteria

Without context

With context

Scatter query identified

100%

Vindex filter added

100%

Correlated subquery rewritten

100%

Cursor-based pagination

100%

OLAP mode for analytics

100%

Lookup vindex recommended

100%

Avoid SELECT star

100%

ORDER BY for determinism

100%

Cross-shard join identified

100%

VEXPLAIN mentioned

100%

Aggregation memory warning

100%

95%

15%

Plan and Script a Production Schema Migration

Schema migration planning

Criteria

Without context

With context

Vitess DDL strategy set

100%

No direct DDL

100%

Postpone-completion used

100%

SHOW VITESS_MIGRATIONS

100%

Tablet throttler mentioned

100%

Revert command included

100%

Cancel command included

100%

Complete command for postponed

37%

100%

Migration UUID captured

100%

Audit log co-located

100%

Sequence for audit log

37%

100%

Migrate a Legacy MySQL Application to Vitess

MySQL-to-Vitess migration compatibility

Criteria

Without context

With context

Stored procedure flagged

100%

Trigger flagged

100%

Event flagged

100%

GET_LOCK flagged

100%

LOCK TABLES flagged

100%

SELECT FOR UPDATE warning

100%

Foreign keys removed

100%

AUTO_INCREMENT replaced

100%

Booking logic rewritten

100%

Clinic_id in booking query

100%

Bulk update without LOCK

62%

100%

84%

30%

Plan a Reshard Operation for a Growing Keyspace

Reshard workflow and traffic switching

Criteria

Without context

With context

VDiff before switchtraffic

100%

Reads switched first

100%

Reverse traffic for rollback

100%

Defer secondary keys

100%

On-DDL stop flag

100%

Correct shard ranges

100%

Source shards specified

100%

250GB shard target noted

Tablet throttler enabled

100%

Complete command at end

100%

Status monitoring included

100%

79%

15%

Wallet Transfer Service: Transaction Design Review

Cross-shard transaction design

Criteria

Without context

With context

MULTI mode partial commit risk

75%

100%

2PC recommended for atomicity

100%

Single-shard ACID noted

60%

50%

Co-location design proposed

30%

20%

Cross-shard transfer identified

100%

Foreign key incompatibility flagged

100%

AUTO_INCREMENT issue identified

20%

100%

SELECT FOR UPDATE warning

12%

Transaction mode explanation

62%

100%

Schema-level fix proposed

100%

Isolation level clarification

33%

100%

19%

Separating the Catalog Service from a Monolithic Keyspace

MoveTables vertical sharding workflow

Criteria

Without context

With context

MoveTables create command

100%

Defer secondary keys flag

100%

On-DDL stop flag

100%

Sharded auto-increment handling

25%

100%

VDiff before switchtraffic

100%

Reads switched before writes

100%

Reversetraffic for rollback

100%

Complete command at end

100%

Status monitoring included

100%

Tablet throttler enabled

100%

Reverse replication preservation

100%

Production Readiness Review for a New Vitess Cluster

Production Vitess architecture setup

Criteria

Without context

With context

Multiple VTGate instances

100%

VTGate stateless noted

100%

Replica tablets for OLTP reads

100%

Rdonly tablets for analytics

100%

VTOrc deployment

100%

Etcd HA configuration

100%

Replication lag monitoring

100%

Single-etcd risk identified

100%

Single-VTGate risk identified

100%

OLAP mode for analytics

100%

No-primary-only risk identified

100%

Repository: planetscale/database-skills
Commit: b156f4c

Evaluated: 28 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Multi-Tenant SaaS Database Sharding Design Optimize Slow Queries for a Sharded E-Commerce Database Plan and Script a Production Schema Migration Migrate a Legacy MySQL Application to Vitess Plan a Reshard Operation for a Growing Keyspace Wallet Transfer Service: Transaction Design Review Separating the Catalog Service from a Monolithic Keyspace Production Readiness Review for a New Vitess Cluster

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.