Table: vercel_dns_record - Query Vercel DNS Records using SQL

Vercel DNS Records are configurations that provide information about which IP addresses are associated with a domain name. They are essential for directing web traffic to the correct servers. Vercel provides a platform for DNS management, allowing users to create, update, and delete DNS records.

Table Usage Guide

The vercel_dns_record table provides insights into DNS Records within Vercel. As a network administrator, explore DNS record details through this table, including record types, associated values, and related metadata. Utilize it to uncover information about DNS records, such as their configurations, associated domain names, and the status of each record.

Examples

List all DNS records for all domains

Explore which DNS records are associated with your domains. This can be useful in managing and troubleshooting your network, ensuring the correct routing of internet traffic to your domains.

select
  domain_name,
  name,
  type,
  value,
  ttl
from
  vercel_dns_record;

select
  domain_name,
  name,
  type,
  value,
  ttl
from
  vercel_dns_record;

List all A records for all domains

Explore which domains have been assigned an IPv4 address (A record). This is useful for understanding the distribution of IP addresses across your domains, aiding in network management and troubleshooting.

select
  domain_name,
  type,
  value,
  ttl
from
  vercel_dns_record
where
  type = 'A';

select
  domain_name,
  type,
  value,
  ttl
from
  vercel_dns_record
where
  type = 'A';

Schema for vercel_dns_record

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		Time when the DNS record was created.
creator	text		Creator of the DNS record.
domain_name	text		Domain name the record belongs to.
id	text		ID of the DNS record.
mx_priority	bigint		MX priority of the DNS record.
name	text		Name of the DNS record.
priority	bigint		Priority of the DNS record.
slug	text		Slug of the DNS record.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
ttl	bigint		Time To Live of the DNS record.
type	text		Type of the DNS record.
updated_at	timestamp with time zone		Time when the DNS record was created.
user_uid	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of the user.
value	text		Type of the DNS record.

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_dns_record