Comment on page
ENS Tables
Ethereum Name Service (ENS) tables available to query via SQL
Table Name | Description |
|---|---|
A mapping of ENS names to addresses |
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:/* Show the columns available */
DESCRIBE ens.domains;
User can query this table by ENS domain name to retrieve the latest
owner and eth_address information. Supported names are:- Top Level Domains (.eth)
- Subdomains
- dcl.eth
- loopring.eth
- argent.xyz
- earth.eth
- auth.eth
This table can be used, for example, to retrieve the Ethereum address associated with a
*.eth domain or subdomain:SELECT * FROM ens.domains WHERE name='spiceai.eth'
SELECT * FROM ens.domains WHERE name='ccc.earth.eth'
Or to infer the domain name of an address (reverse look-up):
SELECT * FROM ens.domains WHERE eth_address='0x425ec049c2a4722edfd770ab7bc4f9ca8b7bd815'
Expiration dates in the
expires column are given as Unix timestamps. They can be null for entities such as subdomains, which do not necessarily have expiry dates. We currently do not track expiration dates of NameWrapper subdomains.Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
ens.domains | name, eth_address |
Last modified 4mo ago