turbot/planetscale
steampipe plugin install planetscale

Table: planetscale_organization - Query PlanetScale Organizations using SQL

PlanetScale is a database platform that simplifies the process of scaling databases. It allows for the creation and management of organizations, which serve as a way to group related databases and database branches. Each organization in PlanetScale has its own configuration, status, and metadata.

Table Usage Guide

The planetscale_organization table provides insights into organizations within PlanetScale. As a database administrator or developer, you can explore organization-specific details through this table, including its configuration, status, and associated metadata. Utilize it to manage and monitor your organizations, to ensure optimal organization structure and database performance.

Examples

List all organizations

Explore all the organizations within your database, helping you to understand the breadth and diversity of data you're dealing with. This can be particularly useful for large-scale projects or when managing databases across multiple departments or teams.

select
*
from
planetscale_organization;
select
*
from
planetscale_organization;

Schema for planetscale_organization

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
created_attimestamp with time zoneWhen the organization was created.
nametextName of the organization.
organization_nametext=, !=, ~~, ~~*, !~~, !~~*The name of the organization.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneWhen the organization was updated.

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_organization