How do I install the Planetscale Pscale CLI Automation skill?

Run npx skillmds add planetscale-skills/planetscale-pscale-cli-automation in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Planetscale Pscale CLI Automation safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: makes network calls. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Planetscale Pscale CLI Automation?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Planetscale Pscale CLI Automation free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Planetscale Pscale CLI Automation?

planetscale (@planetscale-skills) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Planetscale Pscale CLI Automation by planetscale-skills

Name: Planetscale Pscale CLI Automation
Rating: 4.2 (5 reviews)
Author: planetscale

Planetscale Pscale CLI Automation

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 ec93453 3.5 KB Updated Sep 9, 2026

File contents

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)

Document	Where	Purpose
CLI agent guide	Shipped 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 guide	Your application repository's `AGENTS.md`	Which 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)

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

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):

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:

pscale agent-guide --format json

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

---name: planetscale-pscale-cli-automationdescription: 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) | Document | Where | Purpose | |----------|-------|---------| | **CLI agent guide** | Shipped 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 guide** | Your application repository's `AGENTS.md` | Which 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.

Frequently asked questions