turbot/vercel

GitHub
steampipe plugin install vercelsteampipe plugin install vercel

Table: vercel_secret

Secrets are a legacy way to encrypt variables in Vercel, and have been deprecated. All environment variables are now encrypted by default.

Examples

List all secrets

select
project_id,
name,
uid,
created_at
from
vercel_secret;

Secrets more than 1 year old

select
project_id,
name,
uid,
created_at
from
vercel_secret
where
created_at < now() - interval '1 year';

Secrets used by environment variables

select
p.name as project_name,
e ->> 'key' as env_var,
e ->> 'type' as env_var_type,
s.name as secret_name,
s.uid as secret_uid,
s.created_at as secret_created_at
from
vercel_project as p,
jsonb_array_elements(env) as e,
vercel_secret as s
where
e ->> 'type' = 'secret'
and e ->> 'value' = s.uid;

.inspect vercel_secret

Secrets in the Vercel account.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneTime when the secret was created.
decryptablebooleanTrue if the secret value can be decrypted after it is created.
nametextName of the secret.
project_idtextUnique identifier of the project the secret belongs to.
team_idtextUnique identifier of the team the secret was created for.
uidtextUnique identifier of the secret.
user_idtextUnique identifier of the user who created the secret.
valuetextValue of the secret.