turbot/namecheap
steampipe plugin install namecheap

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
addresstextTarget address for the host, e.g. steampipe.io., 1.2.3.4
domaintext=Name of the domain, e.g. steampipe.io.
email_typetextEmail type for the domain.
friendly_nametextFriendly name of the host, e.g. MX2.
host_idbigintUnique ID of the host record at Namecheap, e.g. 1234.
is_activebooleanTrue if the record is active.
is_ddns_enabledbooleanTrue if dynamic DNS is enabled.
is_using_our_dnsbooleanTrue if the domain is using Namecheap DNS.
mx_prefbigintMX priority of the host.
nametextName of the host, e.g. www or @ for the root domain.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
ttlbigintTTL of the record.
typetextType of the host, e.g. CNAME.
usernametext=, !=, ~~, ~~*, !~~, !~~*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