Table: planetscale_database
List databases in your account.
Examples
List all databases
select *from planetscale_database
Databases created in the last week
select *from planetscale_databasewhere age(created_at) < interval '7 days'
Databases in US regions
select *from planetscale_databasewhere region like 'us-%'
.inspect planetscale_database
Databases in the PlanetScale account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
created_at | timestamp with time zone | When the database was created. |
name | text | Name of the database. |
notes | text | Notes for the database. |
region_slug | text | Region where the database is located. |
updated_at | timestamp with time zone | When the database was updated. |