Name: vitess
Rating: 84 (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.

Install with Tessl CLI

npx tessl i github:planetscale/database-skills --skill vitess

What are skills?

Overall
score

84%

Review — 82%

Does it follow best practices?

If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:

npx tessl skill review --optimize ./path/to/skill

Learn more

Evaluation — 96%

↑ 1.10x

Agent success when using this skill

Validation — 11 / 11 Passed

Validation for skill structure

SKILL.md

Review

Evals

Evaluation results

93%

Multi-Tenant SaaS Database Sharding Design

VSchema design and sharding strategy

Criteria

Without context

With context

Shared primary vindex

100%

60%

Join co-location

100%

xxhash vindex type

100%

Vitess Sequences defined

100%

70%

Sequence in unsharded keyspace

30%

100%

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

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

30%

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%

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

70%

100%

SHOW VITESS_MIGRATIONS

100%

Tablet throttler mentioned

100%

Revert command included

100%

Cancel command included

100%

Complete command for postponed

100%

Migration UUID captured

100%

Audit log co-located

100%

Sequence for audit log

38%

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

50%

100%

92%

22%

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%

Evaluated: 9 days ago
Agent: Claude Code

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

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.