Agent skill
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 this agent skill to your Project
npx add-skill https://github.com/sushichan044/dotfiles/tree/main/.agents/skills/vitess
Metadata
Additional technical details for this skill
- date
- February 2026
- author
- planetscale
- version
- 1.0.0
- organization
- PlanetScale
SKILL.md
Vitess
Vitess is a MySQL-compatible, cloud-native database system originally built at YouTube to scale MySQL. PlanetScale runs Vitess as a managed service. Core capabilities:
- Horizontal sharding: Built-in sharding transparent to the application — no sharding logic in app code.
- Connection pooling: VTTablet multiplexes client connections to MySQL, scaling concurrent connections far beyond native MySQL limits.
- High availability: Automatic primary failure detection and repair. Resharding and data migrations with near-zero downtime.
- Query rewriting and caching: VTGate rewrites and optimizes queries before routing to shards.
- Schema management: Apply schema changes across all shards consistently, in the background, without disrupting workloads.
- Materialized views and messaging: Cross-shard materialized views and publish/subscribe messaging via VStream.
Key concepts
| Concept | What it is |
|---|---|
| Keyspace | Logical database mapping to one or more shards. Analogous to a MySQL schema. |
| Shard | A horizontal partition of a keyspace, each backed by a separate MySQL instance. |
| VSchema | Configuration defining how tables map to shards, vindex (sharding) keys, and routing rules. |
| Vindex | Sharding function mapping column values to shards (hash, unicode_loose_xxhash, lookup). |
| VTGate | Stateless proxy that plans and routes queries to the correct shard(s). |
| Online DDL | Non-blocking schema migrations. On PlanetScale, use deploy requests for production changes. |
PlanetScale specifics
- Branching: Git-like database branches for development; deploy requests for production schema changes.
- Connections: MySQL protocol, port
3306(direct) or443(serverless). SSL always required.
SQL compatibility
Vitess supports nearly all MySQL syntax — most applications work without query changes. Standard DML, DDL, joins, subqueries, CTEs (including recursive CTEs as of v21+), window functions, and common built-in functions all work as expected.
Known limitations:
- Stored procedures / triggers / events: Not supported through VTGate.
LOCK TABLES/GET_LOCK: Not supported through VTGate.SELECT ... FOR UPDATE: Works within a single shard; cross-shard locking is not atomic.- Cross-shard joins: Supported but expensive (scatter-gather). Filter by vindex column for single-shard routing.
- Correlated subqueries: May fail or perform poorly cross-shard. Rewrite as joins when possible.
- IDs: Use Vitess Sequences (a global counter in an unsharded keyspace) or app-generated IDs (UUIDs, snowflake) to avoid collisions on sharded tables.
- Aggregations on sharded tables:
GROUP BY/ORDER BY/LIMITmerge in VTGate memory. Large result sets can be slow. - Foreign keys: Limited support. Prefer application-level referential integrity on sharded keyspaces.
References
| Topic | Reference | Use for |
|---|---|---|
| VSchema | references/vschema.md | VSchema design, vindexes, sequences, sharding strategies |
| Schema Changes | references/schema-changes.md | Online DDL, managed migrations, ddl strategies, migration lifecycle |
| VReplication | references/vreplication.md | MoveTables, Reshard, Materialize, VDiff, VStream |
| Architecture | references/architecture.md | VTGate, VTTablet, Topology Service, VTOrc, component interactions |
| Query Serving | references/query-serving.md | Query routing, MySQL compatibility, cross-shard performance, EXPLAIN |
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
sushichan044/dotfiles
terraform-style-guide
Generate Terraform HCL code following HashiCorp's official style conventions and best practices. Use when writing, reviewing, or generating Terraform configurations.
sushichan044/dotfiles
fix-github-actions-ci
GitHub Actions CI の失敗を調査して修正するためのスキルです。CI ログを分析して失敗箇所・原因を特定し、そのまま修正作業まで行います。
sushichan044/dotfiles
dd-logs
Log management - search, pipelines, archives, and cost control.
sushichan044/dotfiles
golang-safety
Defensive Golang coding to prevent panics, silent data corruption, and subtle runtime bugs. Use whenever writing or reviewing Go code that involves nil-prone types (pointers, interfaces, maps, slices, channels), numeric conversions, resource lifecycle (defer in loops), or defensive copying. Also triggers on questions about nil panics, append aliasing, map concurrent access, float comparison, or zero-value design.
sushichan044/dotfiles
resolve-merge-conflict
現在の branch を分岐元の最新に rebase するときに使う。まず rebase を実行し、止まった conflict を順番に解消して前に進める。長い事前調査を避けて、必要な file だけ見て片付けたいときに使う。
sushichan044/dotfiles
golang-data-structures
Golang data structures — slices (internals, capacity growth, preallocation, slices package), maps (internals, hash buckets, maps package), arrays, container/list/heap/ring, strings.Builder vs bytes.Buffer, generic collections, pointers (unsafe.Pointer, weak.Pointer), and copy semantics. Use when choosing or optimizing Go data structures, implementing generic containers, using container/ packages, unsafe or weak pointers, or questioning slice/map internals.
Didn't find tool you were looking for?