Back to directory
planetscale avatar

cli

The CLI for PlanetScale Database. Read more below about its uses, features, and usage.

Clone repository

git clone https://github.com/planetscale/cli.git

664

Stars

63

Forks

22

Watchers

Apache-2.0

License

PlanetScale CLI Build status

PlanetScale is more than a database and our CLI is more than a jumble of commands. The pscale command line tool brings branches, deploy requests, and other PlanetScale concepts to your fingertips.

PlanetScale CLI

Installation

macOS

pscale is available via a Homebrew Tap, and as downloadable binary from the releases page:

brew install planetscale/tap/pscale

Optional: pscale requires a MySQL 8 Client in your PATH for certain commands. You can install it by running:

brew install [email protected]

To upgrade to the latest version:

brew upgrade pscale

Linux

pscale is available as downloadable binaries from the releases page. Download the .deb or .rpm from the releases page and install with sudo dpkg -i and sudo rpm -i respectively.

Arch: pscale-cli-bin

Windows

pscale is available via scoop, and as a downloadable binary from the releases page:

scoop bucket add pscale https://github.com/planetscale/scoop-bucket.git
scoop install pscale mysql

To upgrade to the latest version:

scoop update pscale

Manually

Download the pre-compiled binaries from the releases page and copy to the desired location.

Alternatively, you can install bin which works on all macOS, Windows, and Linux platforms:

bin install https://github.com/planetscale/cli

To upgrade to the latest version

bin upgrade pscale

Container images

We provide ready to use Docker container images. To pull the latest image:

docker pull planetscale/pscale:latest

To pull a specific version:

docker pull planetscale/pscale:v0.63.0

If you like to have a shell alias that runs the latest version of pscale from docker whenever you type pscale:

mkdir -p $HOME/.config/planetscale
alias pscale="docker run -e HOME=/tmp -v $HOME/.config/planetscale:/tmp/.config/planetscale --user $(id -u):$(id -g) --rm -it -p 3306:3306/tcp planetscale/pscale:latest"

If you need a more advanced example that works with service tokens and differentiates between commands that need a pseudo terminal or non-interactive mode, have a look at this shell function.

MCP Server Integration

Use the hosted PlanetScale MCP server: https://planetscale.com/docs/connect/mcp

GitHub Actions Usage

Use the setup-pscale-action to install and use pscale in GitHub Actions.

- name: Setup pscale
  uses: planetscale/setup-pscale-action@v1
- name: Use pscale
  env:
    PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }}
    PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }}
  run: |
    pscale deploy-request list my-db --org my-org

Local Development

To run a command:

go run cmd/pscale/main.go <command>

Alternatively, you can build pscale:

go build cmd/pscale/main.go

And then use the pscale binary built in cmd/pscale/ for testing:

./cmd/pscale/pscale <command>

The API client is vendored at internal/planetscale/; this repo no longer depends on planetscale-go. Read doc/api-client.md before touching API-facing code.

Documentation

Please checkout our Documentation page: planetscale.com/docs

For AI agents and automation, run pscale agent-guide (or pscale --skill for an installable skill file) — see AGENTS.md. For operational workflows (inventory, safety review, schema recommendations), install planetscale/skills.

Releases

Changelog

91bf102 Add pscale billing payment-method show, delete, and update. 9ae9d75 Allow --restore with --restore-point without --from. e420799 Describe the observed trigger behavior, not a guesse...

Changelog

7117215 Add Postgres PITR restore-point support to branch create

Changelog

83bfe4a Add pscale --skill to print an installable agent skill file 827cdd6 Add role connection target flags 9d33f21 Clarify missing role connection targets bb23587 Document public reposito...

Changelog

11cf42b Accept email as the primary org member identifier 4962186 Add branch maintenance run command 4e38b07 Add branch query-patterns list, show, and delete 6363df6 Add pscale branch exten...

Changelog

95ff850 Add pscale branch switchover for Postgres branches (#1354) 32baff0 Add pscale branch update for renames and deletion protection 9d5ab4f Add pscale database aggressive-cutover show/e...

Contributors

3 contributors by commits. Profile dekhne ke liye kisi bhi developer par click karein.