Table: vercel_project
List projects in your account.
Examples
List all projects
select name, framework, updated_atfrom vercel_project;
Projects not updated in the last year
select name, framework, updated_atfrom vercel_projectwhere updated_at < now() - interval '1 year';
Latest deployments
select to_timestamp((d ->> 'createdAt') :: bigint / 1000) as created_at, name, d ->> 'url' as url, d -> 'creator' ->> 'username' as creator_usernamefrom vercel_project as p, jsonb_array_elements(latest_deployments) as dorder by created_at desc;
Current production target by project
select name, to_timestamp( (targets -> 'production' ->> 'createdAt') :: bigint / 1000 ) as created_at, targets -> 'production' ->> 'url' as url, targets -> 'production' -> 'meta' ->> 'githubOrg' as github_org, targets -> 'production' -> 'meta' ->> 'githubRepo' as github_repo, targets -> 'production' -> 'meta' ->> 'githubCommitSha' as github_commit_sha, targets -> 'production' -> 'meta' ->> 'githubCommitAuthorName' as github_commit_author_name, targets -> 'production' -> 'meta' ->> 'githubCommitMessage' as github_commit_messagefrom vercel_projectorder by name;
List all project environment variables
select name, e ->> 'key', e ->> 'target'from vercel_project as p, jsonb_array_elements(env) as e;
Environment variables that are not encrypted
select name, e ->> 'key', e ->> 'type'from vercel_project as p, jsonb_array_elements(env) as ewhere e ->> 'type' != 'encrypted';
Production environment variables older than 90 days
select name, e ->> 'key', e ->> 'target', to_timestamp((e ->> 'createdAt') :: bigint / 1000)from vercel_project as p, jsonb_array_elements(env) as ewhere e -> 'target' ? 'production' and to_timestamp((e ->> 'createdAt') :: bigint / 1000) < now() - interval '90 days';
Projects by framework environment variables older than 90 days
select framework, count(id)from vercel_projectgroup by frameworkorder by count desc;
.inspect vercel_project
Projects in the Vercel account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
accountid | text | Account ID for the project. |
alias | jsonb | |
analytics | jsonb | Analytics information, if enabled for the project. |
auto_expose_system_envs | boolean | If true then system environment variables are exposed for use. |
build_command | text | The build command for this project. |
created_at | timestamp with time zone | Time when the project was created. |
dev_command | text | The dev command for this project. |
directory_listing | boolean | If true then the project is listed in the Vercel directory. |
env | jsonb | Environment variables for the project. |
framework | text | Framework used in the project, e.g. nextjs. |
id | text | ID of the project. |
install_command | text | The install command for this project. |
latest_deployments | jsonb | Information about the latest deployments of the project. |
link | jsonb | Details of the link from this project to a source code repository. |
live | boolean | If true, the project is live. |
name | text | Name of the project. |
node_version | text | Node version used by the project, e.g. 16.x. |
output_directory | text | Directory where output of the build will go. |
password_protection | jsonb | Password protection information, if enabled. |
permissions | jsonb | Permissions settings. |
public_source | boolean | If true, the project is linked to a public source. |
root_directory | text | Root directory for the build process. |
serverless_function_region | text | Region where serverless functions will be deployed. |
source_files_outside_root_directory | boolean | If true then source files are outside the root directory. |
sso_protection | jsonb | SSO protection information, if enabled. |
targets | jsonb | Targets of the build. |
updated_at | timestamp with time zone | Time when the project was last updated. |