turbot/planetscale
steampipe plugin install planetscale

Table: planetscale_region - Query PlanetScale Regions using SQL

PlanetScale Regions are the geographical locations available for deploying databases in the PlanetScale service. Each region is identified by a unique slug and has a display name. The enabled status indicates whether the region is currently available for use.

Table Usage Guide

The planetscale_region table provides insights into the regions available within PlanetScale. As a database administrator or developer, explore region-specific details through this table, including the unique slug, display name, and enabled status. Utilize it to understand the geographical distribution of your databases and plan for future deployments.

Examples

List all regions

Explore all the geographical regions in which PlanetScale operates, to better understand its global distribution and reach. This knowledge can be useful for planning resource allocation and optimizing service performance.

select
*
from
planetscale_region;
select
*
from
planetscale_region;

Schema for planetscale_region

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
enabledbooleanTrue if the region is enabled.
locationtextLocation for the region.
nametextDisplay name of the region.
slugtextSlug of the region.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- planetscale

You can pass the configuration to the command with the --config argument:

steampipe_export_planetscale --config '<your_config>' planetscale_region