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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
bought_at	timestamp with time zone		Time when the domain was bought.
cdn_enabled	boolean		If true, then the Content Delivery Network is enabled for this domain.
config_verified_at	timestamp with time zone		Time when the domain configuration was verified.
created_at	timestamp with time zone		Time when the domain was created.
creator	jsonb		Creator of the domain.
expires_at	timestamp with time zone		Time when the domain expires.
id	text		ID of the domain.
intended_name_servers	jsonb		Intended name servers for the domain.
name	text		Name of the domain.
name_servers	jsonb		Name servers for the domain.
ns_verified_at	timestamp with time zone		Time when the name server was verified.
renew	boolean		True if the domain should auto-renew.
service_type	text		Service provided by the domain, e.g. external.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
transferred_at	timestamp with time zone		Time when the domain was created.
txt_verified_at	timestamp with time zone		Time when the domain was created.
user_uid	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of the user.
verification_record	text		Verification record for the domain.
verified	boolean		True if the domain is verified.
zone	boolean		Zone 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