Table: namecheap_domain - Query Namecheap Domains using SQL
Namecheap is a domain registrar and technology company that provides services for buying, hosting, and managing domains. It offers a wide range of domain management services including domain name registration, domain name transfers, domain name renewal, domain expiration protection, and domain privacy services. Namecheap's domain management platform allows users to manage their domains in a centralized manner, providing tools for DNS management, domain forwarding, email hosting, and more.
Table Usage Guide
The namecheap_domain
table provides insights into domains registered with Namecheap. As a system administrator, you can explore domain-specific details through this table, including domain IDs, domain names, expiration dates, and more. Utilize it to manage and monitor your domains, such as checking the expiration date of domains, verifying the status of domain transfers, and keeping track of all registered domains.
Examples
List domains
Explore which domains are nearing their expiration dates to ensure timely renewals and uninterrupted service.
select domain, expiresfrom namecheap_domain;
select domain, expiresfrom namecheap_domain;
Get a specific domain
Discover the expiration date of a specific domain to stay updated and renew it before it lapses. This query is beneficial for domain management, ensuring uninterrupted online presence.
select domain, expiresfrom namecheap_domainwhere domain = 'steampipe.io';
select domain, expiresfrom namecheap_domainwhere domain = 'steampipe.io';
Domains expiring in the next 90 days
Explore which domains are due to expire in the next 90 days. This can be particularly useful for domain renewal management, ensuring that you don't lose control of important domains due to overlooked expiration dates.
select domain, expires, age(expires)from namecheap_domainwhere expires < (current_date + interval '90 days');
select domain, expires, julianday('now') - julianday(expires)from namecheap_domainwhere julianday(expires) < julianday(date('now', '+90 day'));
Domains by date created at Namecheap
Discover the segments that have been recently established on Namecheap. This can help users identify new domains and understand their age, facilitating better management and oversight of their online properties.
select domain, created, age(created)from namecheap_domainorder by created;
select domain, created, julianday('now') - julianday(created) as age_createdfrom namecheap_domainorder by created;
Domains without auto-renew enabled
Discover the domains that do not have the auto-renew feature enabled. This can help manage domain expiry and avoid losing access to your domains due to missed renewals.
select domain, expiresfrom namecheap_domainwhere not auto_renew;
select domain, expiresfrom namecheap_domainwhere auto_renew = 0;
Domains and their nameservers
Explore which domains are associated with specific nameservers. This is useful in managing and understanding the distribution of your domains across different nameservers.
select domain, nsfrom namecheap_domain, jsonb_array_elements_text(nameservers) as ns;
select domain, ns.valuefrom namecheap_domain, json_each(nameservers) as ns;
Schema for namecheap_domain
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
auto_renew | boolean | True if the domain will renew automatically. | |
created | timestamp with time zone | Time when the domain was created at Namecheap. | |
dns_provider_type | text | ||
domain | text | = | Name of the domain, e.g. steampipe.io. |
expires | timestamp with time zone | Time when the domain expires. | |
id | text | Unique ID of the domain, e.g. 1234. | |
is_expired | boolean | True if the domain has expired. | |
is_locked | boolean | True if the domain is locked. | |
is_our_dns | boolean | True if the domain uses Namecheap DNS. | |
is_premium | boolean | True if the domain uses premium DNS. | |
nameservers | jsonb | Array of nameservers for the domain. | |
user | text | Namecheap user who owns the domain, e.g. janedoe. | |
whois_guard | text | Status of WhoisGuard, e.g. ENABLED, NOTPRESENT, etc. |
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