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

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
enabled	boolean	True if the region is enabled.
location	text	Location for the region.
name	text	Display name of the region.
slug	text	Slug 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