Account Domains

Fetch the Domains owned by an address (across both ENSv1 and ENSv2), including each Domain’s type (ENSv1Domain vs ENSv2Domain). See Connect for setup.

SQL

What is an `ensindexer_0`?

It is the name of an ENSDb Writer Schema, which is a database schema within an ENSDb instance, used to store indexed ENS data from a given ENSDb Writer instance. We use ensindexer_0 as the ENSDb Writer Schema Name in examples on this page, but your ENSDb Writer instance may be configured to use a different schema name. Make sure to replace ensindexer_0 with the actual schema name used by your ENSDb Writer instance when querying the ENSDb instance directly. For example, ENSIndexer allows configuring its own ENSDb Writer Schema Name with the ENSINDEXER_SCHEMA_NAME environment variable.

SQL

SELECT
  d.type,
  d.canonical_name,
  d.canonical_node,
  d.id,
  d.owner_id
FROM "ensindexer_0".domains d
WHERE d.canonical = true
AND d.owner_id = '0x179a862703a4adfb29896552df9e307980d19285'
ORDER BY d.__canonical_name_prefix ASC
LIMIT 10;

Output

#	type	canonical_name	canonical_node	id	owner_id
1	ENSv1Domain	179a862703a4adfb29896552df9e307980d19285.addr.reverse	0xf7bb5852f23c4f92e78491e28d1e5897718c1eefb6c6fdd2224fddcdd09214de	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xf7bb5852f23c4f92e78491e28d1e5897718c1eefb6c6fdd2224fddcdd09214de	0x179a862703a4adfb29896552df9e307980d19285
2	ENSv1Domain	[57af2a1afc4eeb2d190972d23b65ffbd77a900d7b5ba894214aec651eb8cdb99].mrgreg.eth	0x2c4c3a3e03f46fd80907cc2a9e7da72e7fbd098f85c59321a7fb7174a289bb85	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x2c4c3a3e03f46fd80907cc2a9e7da72e7fbd098f85c59321a7fb7174a289bb85	0x179a862703a4adfb29896552df9e307980d19285
3	ENSv1Domain	89bd55f729c552da9e88102f5044bb0a770fe512.addr.reverse	0xdf1447a9b5d1728977edc04658a38c770097a3b66291d9b5cf913f0892aecf0c	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xdf1447a9b5d1728977edc04658a38c770097a3b66291d9b5cf913f0892aecf0c	0x179a862703a4adfb29896552df9e307980d19285
4	ENSv1Domain	breadbygreg.eth	0x0e09603eaf9854179bf6b83db80dc5f9bab46c629ea87e4dcabf9a43eab0cf97	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x0e09603eaf9854179bf6b83db80dc5f9bab46c629ea87e4dcabf9a43eab0cf97	0x179a862703a4adfb29896552df9e307980d19285
5	ENSv1Domain	cae0d70e3601d45ca70c20d26f8b440b27d89a1d.addr.reverse	0x412ccdc26a20bfe0e97f37026a2bfdd9e92dc470bde4cf810ffd77a4069a2bed	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x412ccdc26a20bfe0e97f37026a2bfdd9e92dc470bde4cf810ffd77a4069a2bed	0x179a862703a4adfb29896552df9e307980d19285
6	ENSv1Domain	contract.gtest.eth	0x3d831d932784bc862d38e8e8872f06209e41030680f8fcf7c97be30494346654	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x3d831d932784bc862d38e8e8872f06209e41030680f8fcf7c97be30494346654	0x179a862703a4adfb29896552df9e307980d19285
7	ENSv1Domain	devtools.eth	0xfb17155dd713fe4143c2011b392167ea09f6958c5f1b14ffa7eacf1a21badfab	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xfb17155dd713fe4143c2011b392167ea09f6958c5f1b14ffa7eacf1a21badfab	0x179a862703a4adfb29896552df9e307980d19285
8	ENSv1Domain	ens.gregskril.eth	0x4fedc4305d84a415763cffb1b55a88dcea3dfde44b8787a6bd98223aac01b58e	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x4fedc4305d84a415763cffb1b55a88dcea3dfde44b8787a6bd98223aac01b58e	0x179a862703a4adfb29896552df9e307980d19285
9	ENSv1Domain	enswidgets.eth	0x2aff6e58dd1a29ed067afd547694b14b9389bda8285c0fc5f944c64b78ff7858	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x2aff6e58dd1a29ed067afd547694b14b9389bda8285c0fc5f944c64b78ff7858	0x179a862703a4adfb29896552df9e307980d19285
10	ENSv1Domain	ethtoolkit.eth	0x3c78cc3bb454bb4cd8f6c3dc39a567d29c4b812207a3935bd1fddcc924f3fcd4	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x3c78cc3bb454bb4cd8f6c3dc39a567d29c4b812207a3935bd1fddcc924f3fcd4	0x179a862703a4adfb29896552df9e307980d19285

Output matches a point in time snapshot of ENSDb result from our Alpha Hosted ENSNode instance. Live output depends on the configuration of your ENSNode instance and also changes that may have happened in ENS since this point in time snapshot example response was captured.

ensdb-sdk (TypeScript)

Connect with ensdb-sdk

See how to connect to ENSDb and get access to the ensDb query builder and ensIndexerSchema schema definition in the Connect example if you haven't already.

TypeScript

import { and, eq, asc } from "drizzle-orm";

const owner = "0x179a862703a4adfb29896552df9e307980d19285";
const limit = 10;

const accountDomains = await ensDb
  .select({
    canonicalName: ensIndexerSchema.domain.canonicalName,
    canonicalNode: ensIndexerSchema.domain.canonicalNode,
    type: ensIndexerSchema.domain.type,
    id: ensIndexerSchema.domain.id,
    ownerId: ensIndexerSchema.domain.ownerId,
  })
  .from(ensIndexerSchema.domain)
  .where(
    and(
      eq(ensIndexerSchema.domain.ownerId, owner),
      eq(ensIndexerSchema.domain.canonical, true),
    ),
  )
  .orderBy(asc(ensIndexerSchema.domain.__canonicalNamePrefix))
  .limit(limit);

console.log(accountDomains);

Output

#	type	canonicalName	canonicalNode	id	ownerId
1	ENSv1Domain	179a862703a4adfb29896552df9e307980d19285.addr.reverse	0xf7bb5852f23c4f92e78491e28d1e5897718c1eefb6c6fdd2224fddcdd09214de	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xf7bb5852f23c4f92e78491e28d1e5897718c1eefb6c6fdd2224fddcdd09214de	0x179a862703a4adfb29896552df9e307980d19285
2	ENSv1Domain	[57af2a1afc4eeb2d190972d23b65ffbd77a900d7b5ba894214aec651eb8cdb99].mrgreg.eth	0x2c4c3a3e03f46fd80907cc2a9e7da72e7fbd098f85c59321a7fb7174a289bb85	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x2c4c3a3e03f46fd80907cc2a9e7da72e7fbd098f85c59321a7fb7174a289bb85	0x179a862703a4adfb29896552df9e307980d19285
3	ENSv1Domain	89bd55f729c552da9e88102f5044bb0a770fe512.addr.reverse	0xdf1447a9b5d1728977edc04658a38c770097a3b66291d9b5cf913f0892aecf0c	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xdf1447a9b5d1728977edc04658a38c770097a3b66291d9b5cf913f0892aecf0c	0x179a862703a4adfb29896552df9e307980d19285
4	ENSv1Domain	breadbygreg.eth	0x0e09603eaf9854179bf6b83db80dc5f9bab46c629ea87e4dcabf9a43eab0cf97	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x0e09603eaf9854179bf6b83db80dc5f9bab46c629ea87e4dcabf9a43eab0cf97	0x179a862703a4adfb29896552df9e307980d19285
5	ENSv1Domain	cae0d70e3601d45ca70c20d26f8b440b27d89a1d.addr.reverse	0x412ccdc26a20bfe0e97f37026a2bfdd9e92dc470bde4cf810ffd77a4069a2bed	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x412ccdc26a20bfe0e97f37026a2bfdd9e92dc470bde4cf810ffd77a4069a2bed	0x179a862703a4adfb29896552df9e307980d19285
6	ENSv1Domain	contract.gtest.eth	0x3d831d932784bc862d38e8e8872f06209e41030680f8fcf7c97be30494346654	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x3d831d932784bc862d38e8e8872f06209e41030680f8fcf7c97be30494346654	0x179a862703a4adfb29896552df9e307980d19285
7	ENSv1Domain	devtools.eth	0xfb17155dd713fe4143c2011b392167ea09f6958c5f1b14ffa7eacf1a21badfab	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xfb17155dd713fe4143c2011b392167ea09f6958c5f1b14ffa7eacf1a21badfab	0x179a862703a4adfb29896552df9e307980d19285
8	ENSv1Domain	ens.gregskril.eth	0x4fedc4305d84a415763cffb1b55a88dcea3dfde44b8787a6bd98223aac01b58e	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x4fedc4305d84a415763cffb1b55a88dcea3dfde44b8787a6bd98223aac01b58e	0x179a862703a4adfb29896552df9e307980d19285
9	ENSv1Domain	enswidgets.eth	0x2aff6e58dd1a29ed067afd547694b14b9389bda8285c0fc5f944c64b78ff7858	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x2aff6e58dd1a29ed067afd547694b14b9389bda8285c0fc5f944c64b78ff7858	0x179a862703a4adfb29896552df9e307980d19285
10	ENSv1Domain	ethtoolkit.eth	0x3c78cc3bb454bb4cd8f6c3dc39a567d29c4b812207a3935bd1fddcc924f3fcd4	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0x3c78cc3bb454bb4cd8f6c3dc39a567d29c4b812207a3935bd1fddcc924f3fcd4	0x179a862703a4adfb29896552df9e307980d19285

Output matches a point in time snapshot of ENSDb result from our Alpha Hosted ENSNode instance. Live output depends on the configuration of your ENSNode instance and also changes that may have happened in ENS since this point in time snapshot example response was captured.