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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
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.
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