Table: planetscale_service_token - Query PlanetScale Service Tokens using SQL

PlanetScale Service Token is a resource in the PlanetScale Database-as-a-Service platform that allows you to authenticate your services and applications to access your databases. It provides a secure way to manage and control access to your PlanetScale databases, ensuring that only authenticated services can interact with your data. PlanetScale Service Token is essential for maintaining the security and integrity of your databases.

Table Usage Guide

The planetscale_service_token table provides insights into service tokens within PlanetScale. As a database administrator, explore token-specific details through this table, including token ID, associated service, and creation timestamp. Utilize it to uncover information about service tokens, such as those associated with specific services, the lifespan of tokens, and the verification of service access.

Examples

List all service tokens

Explore the range of service tokens available in your system. This can be particularly useful when you need to manage or audit your service tokens.

select
  *
from
  planetscale_service_token;

select
  *
from
  planetscale_service_token;

Schema for planetscale_service_token

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
id	text		Unique identifier for the service token.
organization_name	text	=, !=, ~~, ~~, !~~, !~~	The name of the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
type	text		Type of the token.

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_service_token