steampipe plugin install vercel

Table: vercel_domain - Query Vercel Domains using SQL

Vercel Domains is a feature within Vercel that allows you to manage and configure your custom domains for your Vercel deployments. It provides a centralized way to set up and manage domains, including DNS records, SSL certificates, and more. Vercel Domains helps you maintain the health and performance of your custom domains and take appropriate actions when predefined conditions are met.

Table Usage Guide

The vercel_domain table provides insights into the custom domains within Vercel. As a DevOps engineer, explore domain-specific details through this table, including verification status, associated DNS records, and SSL certificates. Utilize it to uncover information about domains, such as those with invalid SSL certificates, the verification status of domains, and the configuration of DNS records.

Examples

List all domains

Discover the segments that consist of all domains, including their verification status and the dates they were created and will expire. This can help you manage and track your domains effectively.

select
name,
verified,
created_at,
expires_at
from
vercel_domain;
select
name,
verified,
created_at,
expires_at
from
vercel_domain;

Domains expiring in the next 90 days

Determine the domains that are due to expire within the next 90 days. This query is useful for proactive management of domains, ensuring they are renewed on time to prevent service disruptions. Lists domains expiring soon. Domains managed outside of Vercel will not be included in results.

select
name,
expires_at
from
vercel_domain
where
expires_at < now() + interval '90 days';
select
name,
expires_at
from
vercel_domain
where
expires_at < datetime('now', '+90 days');

Schema for vercel_domain

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
bought_attimestamp with time zoneTime when the domain was bought.
cdn_enabledbooleanIf true, then the Content Delivery Network is enabled for this domain.
config_verified_attimestamp with time zoneTime when the domain configuration was verified.
created_attimestamp with time zoneTime when the domain was created.
creatorjsonbCreator of the domain.
expires_attimestamp with time zoneTime when the domain expires.
idtextID of the domain.
intended_name_serversjsonbIntended name servers for the domain.
nametextName of the domain.
name_serversjsonbName servers for the domain.
ns_verified_attimestamp with time zoneTime when the name server was verified.
renewbooleanTrue if the domain should auto-renew.
service_typetextService provided by the domain, e.g. external.
transferred_attimestamp with time zoneTime when the domain was created.
txt_verified_attimestamp with time zoneTime when the domain was created.
verification_recordtextVerification record for the domain.
verifiedbooleanTrue if the domain is verified.
zonebooleanZone of the domain.

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)" -- vercel

You can pass the configuration to the command with the --config argument:

steampipe_export_vercel --config '<your_config>' vercel_domain