steampipe plugin install francois2metz/scalingo

Table: scalingo_database

List databases associated to an app.

The scalingo_database table can be used to query information about a addon database, and you must specify which application in the where or join clause using the app_name column and the addon_id.

Examples

Get Database info

select
*
from
scalingo_database
where
app_name = 'caresteouvert-api'
and addon_id = 'ad-0c33a92f-000-000-000-0000000';

List database from all addons of an application

select
db.app_name,
db.status,
db.encryption_at_rest
from
scalingo_addon ad
inner join scalingo_database db on ad.id = db.addon_id
and ad.app_name = db.app_name
where
ad.app_name = 'caresteouvert-api';

Schema for scalingo_database

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
addon_idtext=ID of the addon.
app_nametext=Name of the app.
created_attimestamp with time zoneCreation date of the database.
encryption_at_restbooleanIs encryption at rest enabled on this database.
force_sslbooleanIs SSL encryption is required.
idtextUnique ID identifying the database.
instancestextList of all database instances
maintenance_window_duration_in_hourbigintDuration in hour of the maintenance window.
maintenance_window_starting_hour_utcbigintHour of the maintenance window.
maintenance_window_weekday_utcbigintWeek day of the maintenance window.
periodic_backups_enabledbooleanTrue if periodic backups are enabled.
periodic_backups_scheduled_attextHours of the day of the periodic backup (UTC).
plantextName of the application plan.
publicly_availablebooleanIs the instance publicly available.
readable_versiontextHuman readable database version
resource_idtextResource reference.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextStatus of the current database.
type_idtextDatabase type ID.
type_nametextDatabase type Name.
version_idtextDatabase version ID.