Can I run direct DDL on production branches?

No, PlanetScale production branches with 'safe migrations' enabled reject direct DDL. You must use the deploy request workflow (branch, change, review, deploy).

Why is custom type casting necessary?

The default PlanetScale driver returns types like BigInt, DateTime, and TinyInt(1) as strings. This skill provides patterns to cast them into native JavaScript objects and booleans.

How does it handle Vitess compatibility?

It provides guidance on Vitess-specific constraints, such as the absence of stored procedures and the requirement for specific patterns when renaming columns.

Does this skill support TCP connections?

This skill primarily focuses on the @planetscale/database driver, which uses the Fetch API (HTTP) rather than TCP, making it ideal for edge and serverless runtimes.

PlanetScale Serverless MySQL

Name: PlanetScale Serverless MySQL
Author: agents-inc

byagents-inc

•

Database Management

Integrates PlanetScale's serverless MySQL platform using edge-compatible drivers and automated branching workflows.

This skill enables Claude to efficiently manage PlanetScale's serverless MySQL databases, focusing on the @planetscale/database driver for HTTP-based edge access. It provides patterns for safe schema migrations via deploy requests, Vitess-specific SQL compatibility, and programmatic branching for development and CI/CD pipelines. By automating complex tasks like custom type casting for BigInt or dates and enforcing parameterized queries, it ensures robust, scalable, and secure database interactions within serverless environments.

Key Features

01HTTP-based MySQL access via the @planetscale/database driver

02Atomic transaction handling for serverless runtimes

03Custom type casting for BigInt, Date, and Boolean columns

04Vitess-compatible SQL syntax enforcement and workarounds

055 GitHub stars

06Git-like database branching and deploy request management

Use Cases

01Automating CI/CD workflows with temporary database preview branches

02Managing zero-downtime schema migrations via deploy requests

03Building edge-ready applications on Vercel or Cloudflare Workers

Key Features

01HTTP-based MySQL access via the @planetscale/database driver

02Atomic transaction handling for serverless runtimes

03Custom type casting for BigInt, Date, and Boolean columns

04Vitess-compatible SQL syntax enforcement and workarounds

055 GitHub stars

06Git-like database branching and deploy request management

Use Cases

01Automating CI/CD workflows with temporary database preview branches

02Managing zero-downtime schema migrations via deploy requests

03Building edge-ready applications on Vercel or Cloudflare Workers