Table: namecheap_domain_host - Query Namecheap Domain Hosts using SQL

Namecheap Domain Hosts is a resource within the Namecheap domain registration and management service that allows users to manage and configure host records for their domains. These host records, also known as DNS records, are essential for directing internet traffic to the correct servers and services associated with a domain. As such, they play a crucial role in domain name resolution, website hosting, email delivery, and other domain-related functions.

Table Usage Guide

The namecheap_domain_host table provides insights into the DNS host records configured for domains within the Namecheap service. As a system administrator or DevOps engineer, explore host record-specific details through this table, including the associated domain, record type, address, and TTL (Time to Live) values. Utilize it to monitor and manage DNS configurations, ensure proper domain name resolution, and maintain the overall health and performance of your domains.

Examples

List domain host records

Discover the segments that contain specific details of a domain's host records, such as its name and address. This can be useful in managing and organizing your domains, particularly in identifying which domains have specific host settings.

select
  domain,
  name,
  type,
  address,
  ttl,
  mx_pref
from
  namecheap_domain_host
order by
  domain,
  name;

select
  domain,
  name,
  type,
  address,
  ttl,
  mx_pref
from
  namecheap_domain_host
order by
  domain,
  name;

List host records for a given domain

Explore the host records associated with a particular domain to gain insights into its configuration and settings. This can be especially useful for managing and troubleshooting domain-related issues.

select
  domain,
  name,
  type,
  address,
  ttl,
  mx_pref
from
  namecheap_domain_host
where
  domain = 'steampipe.io';

select
  domain,
  name,
  type,
  address,
  ttl,
  mx_pref
from
  namecheap_domain_host
where
  domain = 'steampipe.io';

List CNAME records

Explore which domain names are associated with specific addresses, useful for identifying potential redirections or aliases. This can provide insights into your domain hosting configuration for better management and security.

select
  domain,
  name,
  address,
  ttl
from
  namecheap_domain_host
where
  type = 'CNAME';

select
  domain,
  name,
  address,
  ttl
from
  namecheap_domain_host
where
  type = 'CNAME';

Schema for namecheap_domain_host

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
address	text		Target address for the host, e.g. steampipe.io., 1.2.3.4
domain	text	=	Name of the domain, e.g. steampipe.io.
email_type	text		Email type for the domain.
friendly_name	text		Friendly name of the host, e.g. MX2.
host_id	bigint		Unique ID of the host record at Namecheap, e.g. 1234.
is_active	boolean		True if the record is active.
is_ddns_enabled	boolean		True if dynamic DNS is enabled.
is_using_our_dns	boolean		True if the domain is using Namecheap DNS.
mx_pref	bigint		MX priority of the host.
name	text		Name of the host, e.g. www or @ for the root domain.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
ttl	bigint		TTL of the record.
type	text		Type of the host, e.g. CNAME.
username	text	=, !=, ~~, ~~, !~~, !~~	The name of the user.

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

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

steampipe_export_namecheap --config '<your_config>' namecheap_domain_host