Getting Started
Make sure to first set up your PlanetScale developer environment. Once you’ve installed thepscale CLI, you can interact with PlanetScale and manage your databases straight from the command line.
The api command
Performs authenticated calls against the PlanetScale API and prints the response to stdout. This is a helper for constructing any call to the PlanetScale API. It can invoke any endpoint, whether support in equivalent commands of the CLI has been added or not. For these reasons, the api command is useful in cases such as scripting or where you might use curl against the API.
Usage:
Endpoint
The<ENDPOINT> should be a path for the v1 PlanetScale API, not including the v1 prefix. You can use placeholders such as {org}, {db} and {branch} in the endpoint, and these will be replaced with the currently selected organization, and the project’s database and branch.
If invoked from outside a project, {db} and {branch} yield an empty string. These values can also be specified by the --org, --database, and --branch flags.
Refer to the API documentation for available endpoints.
Query parameters
Query parameters, such as for pagination, can be added with the--query/-Q flag, in key=value format.
HTTP methods
By default, all HTTP requests use the GET method, unless fields for the body are passed via--field/-F, in which case a POST method is used. If another method is required, use the --method/-X flag to specify which one to use.
Headers
Use the--header/-H flag to specify headers manually. Default headers are already included, such as User-Agent, Content-Type, Accept and Authorization.
Request body
If a body is required for the endpoint you’re targeting, the--field/-F flag allows you to specify values at specific paths of a JSON document. Repeat the flag to set multiple values. All bodies sent are JSON objects; it isn’t possible to send non-JSON content, or JSON entities of non-object type as the root of the body.
If you wish to pass the content of a file as the body, use the --input/-I flag. If the body should be read from stdin, use --input="-".
Fields specified with --field/-F will be updated in the content of --input/-I if the content is JSON. If not, an error will be returned.