Official agent skill

Planetscale Pscale CLI Automation

by planetscale in planetscale/skills

Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force.

OfficialMITAuto-check passedDatabases

Install Planetscale Pscale CLI Automation

skills CLI
$ npx skills add planetscale/skills --skill planetscale-pscale-cli-automation -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install planetscale/skills planetscale-pscale-cli-automation --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/planetscale/skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/planetscale-pscale-cli-automation .claude/skills/planetscale-pscale-cli-automation && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
planetscale-pscale-cli-automation
GitHub stars
133
Token cost
~880 tokens
SKILL.md length
335 words
Files
1
Skills in repo
15
Repo updated
First seen
Licence
MIT

At a glance

Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force.

  • The user asks to automate pscale
  • SKILL.md covers Purpose, Two AGENTS.md files (do not…, Bootstrap (always start here) and Conventions, plus 4 more sections
  • Calls git
  • Run CLI commands headless

What it does

Planetscale Pscale CLI Automation is an agent skill from planetscale/skills, published by the product's own GitHub organization. Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force. Run before other PlanetScale skills when driving pscale directly. Use when the user asks to automate pscale, run CLI commands headless, or verify pscale auth from an agent.

Its SKILL.md is about 880 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering SQL. It works with PlanetScale, SQL and Model Context Protocol. The repository describes itself as: Skills that help you configure and get the most out of PlanetScale. The licence is MIT.

When your agent uses it

  • The user asks to automate pscale
  • Run CLI commands headless
  • Verify pscale auth from an agent

Example prompts

  • “/planetscale-pscale-cli-automation”

Requirements

  • Node.js

What it can do on your machine

Read from SKILL.md and the folder at commit 999045c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • git

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use git, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Planetscale Pscale CLI Automation loads about 880 tokens when it runs. Until then it costs about 83 tokens; SKILL.md has 335 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~83
When it runs · the whole SKILL.md, loaded when a task matches
~880

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from planetscale/skills at commit 999045c, republished under its MIT licence (© planetscale). 335 words, ~880 tokens.

Download SKILL.mdSave it as .claude/skills/planetscale-pscale-cli-automation/SKILL.md (or your agent's skills folder).
name
planetscale-pscale-cli-automation
description
Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force. Run before other PlanetScale skills when driving pscale directly. Use when the user asks to automate pscale, run CLI commands headless, or verify pscale auth from an agent.

PlanetScale CLI automation

Purpose

Teach agents how to invoke pscale non-interactively. This skill covers CLI conventions only. Operational workflows (inventory, safety review, schema recommendations) use the other skills in this repo — start with ../planetscale-safe-orchestrator/SKILL.md for a full assessment.

Two AGENTS.md files (do not confuse them)

DocumentWherePurpose
CLI agent guideShipped with pscale (AGENTS.md in the CLI repo, or pscale agent-guide)How to call pscale: auth, --format json, flag placement, pscale sql
Project agent guideYour application repository's AGENTS.mdWhich org, database, branch, engine, prod branch, MCP scope, approval rules

Do not edit project AGENTS.md without operator approval (see ../planetscale-mcp-agent-operating-model/SKILL.md).

Bootstrap (always start here)

bash
pscale agent-guide --format json
pscale auth check --format json

If auth check returns "status": "action_required", follow issues and next_steps in the JSON. For login, the human may need to approve in the browser; use pscale auth login --format json.

Conventions

  • Always pass --format json for automation.
  • Put --org <org> on resource subcommands (database, branch, sql, api, …) — not on root pscale.
  • Put positional arguments before flags (pscale sql mydb main --org bb …).
  • Use pscale sql, not pscale shell (shell requires a TTY).
  • Default SQL role is reader; pass --role admin (or writer/readwriter) for writes. Match pscale shell semantics for --role and --replica.
  • --force is per subcommand only (e.g. database delete … --force, pscale sql … --force). There is no global --force or PSCALE_FORCE.
  • --format json alone never skips confirmations — add --force on the destructive subcommand after explicit user approval.

Typical workflow

bash
pscale auth check --format json
pscale org list --format json
pscale database list --org <org> --format json
pscale branch list <database> --org <org> --format json
pscale sql <database> <branch> --org <org> --format json --query "SELECT 1"

MySQL uses @primary by default (same as pscale shell); pass --keyspace only for multi-keyspace databases.

MCP vs CLI

  • MCP clients — use the hosted PlanetScale MCP server (see pscale agent-guide --format json for the current URL).
  • Shell scripts and coding agents — use pscale with --format json as above.

When this skill is not enough

Install the full PlanetScale skills pack (if not already):

sh
git clone https://github.com/planetscale/skills.git && cd skills && script/setup
# or: npx skills add planetscale/skills -g -y

Then run sub-skills or ../planetscale-safe-orchestrator/SKILL.md for database operations beyond basic CLI invocation.

Current conventions source of truth

Prefer live output over memorized flag syntax:

bash
pscale agent-guide --format json

The embedded guide field contains the full CLI agent guide shipped with your pscale binary.

© planetscale, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in planetscale-pscale-cli-automation of planetscale/skills.

Open the folder on GitHubat commit 999045c

Compare with similar skills

Planetscale Pscale CLI Automation next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Planetscale Pscale CLI Automation compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Planetscale Pscale CLI Automation this skillplanetscale/skills133—~880Automated safety check: PassMIT
Tune Monitorsickn33/agentic-awesome-skills47k1 repos~3.3kAutomated safety check: PassApache-2.0
Sap Hana CLIsecondsky/sap-skills462—~3.1kAutomated safety check: NotesGPL-3.0
Dune MCP Skillholon-run/uxc116—~1.2kAutomated safety check: PassMIT
StarRocks SQL Doc Auto-FixStarRocks/starrocks12k—~7.6kAutomated safety check: NotesApache-2.0
Schema Explorationtimescale/pg-aiguide1.9k—~1.1kAutomated safety check: PassApache-2.0

Similar skills

  • Tune Monitor

    sickn33/agentic-awesome-skills

    Analyze a Monte Carlo monitor and recommend config changes to reduce alert noise.

    47k GitHub starsUsed in 1 repo~3.3k tokens
    DatabasesAuto-check passed
  • Sap Hana CLI

    secondsky/sap-skills

    Assists with SAP HANA Developer CLI (hana-cli) for database development and administration.

    462 GitHub stars~3.1k tokensUpdated 2 days ago
    DatabasesAuto-check: notes
  • Dune MCP Skill

    holon-run/uxc

    Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and…

    116 GitHub stars~1.2k tokensUpdated 23 days ago
    DatabasesAuto-check passed
  • StarRocks SQL Doc Auto-Fix

    StarRocks/starrocks

    Proposes verified fixes for failing SQL examples in StarRocks docs across three languages and several versions, then opens draft pull requests and never merges.

    12k GitHub stars~7.6k tokensUpdated today
    DatabasesAuto-check: notes
  • Schema Exploration

    timescale/pg-aiguide

    Explore an existing PostgreSQL database before answering questions about its data or writing SQL.

    1.9k GitHub stars~1.1k tokensUpdated today
    DatabasesAuto-check passed
  • Dv Query

    microsoft/Dataverse-skills

    Official

    Bulk reads, multi-page iteration, and analytics over Dataverse data.

    242 GitHub starsUsed in 1 repo~4.5k tokens
    DatabasesAuto-check: notes

More from planetscale/skills

All 15 skills in this repo
  • Official

    Master skill that runs the full PlanetScale safe best-practices assessment — inventory, engine review, Insights, Traffic Control, webhooks, schema recommendations, codebase instrumentation, and…

    133 GitHub stars~2.9k tokensUpdated yesterday
    Auto-check passed
  • Official

    Execute approved PlanetScale changes end-to-end without per-step approval when the operator has explicitly acknowledged the risk.

    133 GitHub stars~2.6k tokensUpdated yesterday
    Auto-check passed
  • Official

    A concise feature matrix for deciding which PlanetScale safety, observability, and automation recommendations apply by engine.

    133 GitHub stars~1.4k tokensUpdated yesterday
    Auto-check passed
  • Enforce explicit approval gates for any PlanetScale, database, repository, credential, network, or automation mutation.

    133 GitHub stars~1.3k tokensUpdated yesterday
    Auto-check passed
  • Inspect an application repository connected to PlanetScale and recommend SQLCommenter-compatible query tagging packages and conventions.

    133 GitHub stars~1.2k tokensUpdated yesterday
    Auto-check passed
  • Official

    Produce the final PlanetScale best-practices report after running the inventory and relevant review skills.

    133 GitHub stars~1.9k tokensUpdated yesterday
    Auto-check passed

Questions about Planetscale Pscale CLI Automation

What does Planetscale Pscale CLI Automation do?

Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force. Planetscale Pscale CLI Automation is an agent skill from planetscale/skills, published by the product's own GitHub organization. Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force.

When should I use Planetscale Pscale CLI Automation?

Planetscale Pscale CLI Automation fits situations like: the user asks to automate pscale; run CLI commands headless; verify pscale auth from an agent.

How do I install Planetscale Pscale CLI Automation in Claude Code?

Run `npx skills add planetscale/skills --skill planetscale-pscale-cli-automation -a claude-code`. Or copy the skill folder (planetscale-pscale-cli-automation in planetscale/skills) into .claude/skills/planetscale-pscale-cli-automation in your project. Claude Code loads it when a task matches its description.

How do I install Planetscale Pscale CLI Automation in Codex?

Run `npx skills add planetscale/skills --skill planetscale-pscale-cli-automation -a codex`. Or copy the skill folder (planetscale-pscale-cli-automation in planetscale/skills) into .agents/skills/planetscale-pscale-cli-automation in your project. Codex loads it when a task matches its description.

Can I use Planetscale Pscale CLI Automation in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add planetscale/skills --skill planetscale-pscale-cli-automation -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/planetscale-pscale-cli-automation, .gemini/skills/planetscale-pscale-cli-automation, .github/skills/planetscale-pscale-cli-automation and .opencode/skills/planetscale-pscale-cli-automation in your project.

What does Planetscale Pscale CLI Automation need to run?

Going by SKILL.md and its folder, Planetscale Pscale CLI Automation needs the command-line tools its instructions call (git). Our summary lists: Node.js.

Does Planetscale Pscale CLI Automation access the network?

SKILL.md contains no URLs. Its commands use git, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Planetscale Pscale CLI Automation safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Planetscale Pscale CLI Automation use?

Planetscale Pscale CLI Automation is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Planetscale Pscale CLI Automation use?

About 880 tokens (SKILL.md is roughly 3.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Planetscale Pscale CLI Automation?

Skills that share tags, products or a category with Planetscale Pscale CLI Automation: Tune Monitor (sickn33/agentic-awesome-skills, 47k stars), Sap Hana CLI (secondsky/sap-skills, 462 stars), Dune MCP Skill (holon-run/uxc, 116 stars) and StarRocks SQL Doc Auto-Fix (StarRocks/starrocks, 12k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Planetscale Pscale CLI Automation?

planetscale (a GitHub organization, an official publisher) maintains it in planetscale/skills, which has 133 GitHub stars. The repository holds 15 skills in this directory. The repository was last updated on October 7, 2026.

Source: planetscale/skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.