Mysql

What it does

The source addresses InnoDB modeling, indexes, transactions, query tuning and operations. It combines design and diagnostic guidance, which is useful when a seemingly local query or index change affects write amplification, lock duration or the behavior of concurrent requests.

Best for

Developers and operators improving a MySQL-backed application with a measurable problem.

Tradeoffs and requirements

An index that accelerates one query can increase storage and write cost. Migration and locking behavior depend on server version and table characteristics, while a development dataset may hide production cardinality and contention.

Unknown; inspect source requirements and supporting scripts.

Install from the source

Inspect the pinned source snapshot and its supporting files first. The command selects this skill through the open-source skills CLI. Node.js and agent-specific setup may be required. Installation can download code. Catalog ingestion never executes skill instructions or install scripts.

npx skills add https://github.com/planetscale/database-skills/tree/f6ed002d03084cb39c01d1d58904d47a36f5322a/skills/mysql --skill mysql

Review pinned skill folder ↗ · CLI documentation ↗

After source review, use npx skills check and npx skills update to inspect and apply upstream updates. Re-check changed instructions before running them.

Safety & review signals

Static review only. This is not a security audit or a guarantee of safety.

SKILL.md text only; scripts, dependencies and runtime behavior not audited.

• Network Access — review the source context.

Allowed tools declaration: Unknown. Runtime permissions and network behavior: Unknown.

Offline package integrity

A temporary folder-copy check, not an agent installation or runtime safety verdict.

19 files copied and checksummed from this exact source snapshot. No package code or installation scripts were executed.

Inventory SHA-256: cff7c5b8d383dcfcfd47b4a13c14be0602634b5428b3c036d7e40b002249f2a7

AI Craft Pad Skill Score

86/100 · Metadata coverage 100% · Model 1.0

Scores summarize observable discovery signals. Popularity and repository activity apply to the whole repository. Unknown runtime safety earns no certification.

Documentation

100/100

100

Maintenance

100/100

100

License Clarity

100/100

100

Repository Health

100/100

100

Compatibility Evidence

80/100

80

Popularity

52/100

52

Originality

80/100

80

Static Safety

60/100

60

Supporting-file static inspection

Bounded source inspection, not a runtime security audit. This inspection does not execute code.

0 text files inspected at this exact repository snapshot. 18 files outside the inspection budget or type allowlist. Dependencies were not installed or independently audited.

Absence of a pattern is not proof of safety. Permission needs and runtime behavior remain Unknown.

Suggested workflow

Inspect the relevant schema, workload and server version, capture a representative execution plan and define the desired behavior. Make a narrow query or index proposal, reviewing transaction scope and the operational method for applying any schema change.

How to judge the result

Compare plans and actual timings with realistic parameter values, then exercise concurrent writes and error paths where relevant. Verify result equivalence and inspect migration effects separately; a successful EXPLAIN output does not establish end-to-end application improvement.