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
ensdb-sdk (TypeScript)

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 = '0xffffffffff52d316b7bd028358089bc8066b8f80'
ORDER BY d.canonical_name
LIMIT 10;

Output

#	type	canonical_name	canonical_node	id	owner_id
1	`ENSv1Domain`	`[3ad05e2a5922916840bc1e5e6039f00b27cbabf8d0428abce062aa2011307374].addr.reverse`	`0xd3947f90d04d7f41f973f09ad7dbdb34cb7463359369e6cf1663bbf928d66e53`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0xd3947f90d04d7f41f973f09ad7dbdb34cb7463359369e6cf1663bbf928d66e53`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
2	`ENSv1Domain`	`[52602a50858115661619fb28cf543ee766c182e0be6743c72d5bd674b3d12686].eth`	`0xe91ce3506cd47457c2b3f04c2736875ca1d17ed74bf1a328a7e64cca5ae8c94b`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0xe91ce3506cd47457c2b3f04c2736875ca1d17ed74bf1a328a7e64cca5ae8c94b`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
3	`ENSv1Domain`	`[8268685e13ae6bbfa54901f2954f9fcf80839ffa102fe7146b930623ce9bd7f0].addr.reverse`	`0x21c356e778799bfddf59a5683c04f6b08710d7c198fef466cc697563b2210785`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0x21c356e778799bfddf59a5683c04f6b08710d7c198fef466cc697563b2210785`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
4	`ENSv1Domain`	`[d90db363b8bc1371f7d738d264ff7294bfc5636f907c467adf68321a3c6d8188].eth`	`0x08c0f01c419a8971af6b3eefe2a8bba1556cccf1163df60b1cdbcab632c8ab48`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0x08c0f01c419a8971af6b3eefe2a8bba1556cccf1163df60b1cdbcab632c8ab48`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
5	`ENSv1Domain`	`[d99fc3d8237200c7122431276a337421cf793f51276873df5a54cc482fdbe685].addr.reverse`	`0x4fc87044c0adc4a0c996b9dafe3a4889e72fe0745fc76f18151b81ed73582218`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0x4fc87044c0adc4a0c996b9dafe3a4889e72fe0745fc76f18151b81ed73582218`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
6	`ENSv2Domain`	`eth`	`0x93cdeb708b7545dc668eb9280176169d1c33cfd8ed6f04690a0bcc88a93fc4ae`	`11155111-0x835f0b284e78cd3f358bcf6cba3b53809f09b79e-35894389512221139346028120028875095598761990588366713962827482865183915769856`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
7	`ENSv2Domain`	`reverse`	`0xa097f6721ce401e757d1223a763fef49b8b5f90bb18567ddb86fd205dff71d34`	`11155111-0x835f0b284e78cd3f358bcf6cba3b53809f09b79e-100753657518907091865523951670693454610893379027273088370152078482136467767296`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
8	`ENSv1Domain`	`reverse`	`0xa097f6721ce401e757d1223a763fef49b8b5f90bb18567ddb86fd205dff71d34`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0xa097f6721ce401e757d1223a763fef49b8b5f90bb18567ddb86fd205dff71d34`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
9	`ENSv2Domain`	`sfmpfv44d0mig.eth`	`0x9b365136312d7ee6e232e3c98e459bc8667ec818c47fbbc55bb5e23d0a21e8cc`	`11155111-0x64c81210d0e580cfc7746f3fb910bf0e8f6378e1-30078755955643454526763071980293195785165410039216352470119925106082295316480`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
10	`ENSv2Domain`	`sfmpfvtoicv2ok.eth`	`0x7d0c27336cf9d51c3fc8f29ef4ef69df9cd4a8ec983e3e17d457a8de6013f3c5`	`11155111-0x64c81210d0e580cfc7746f3fb910bf0e8f6378e1-49509597771493908415463190501045916291230588437784211605615168713991762477056`	`0xffffffffff52d316b7bd028358089bc8066b8f80`

Output matches a result snapshot; live output depends on your ENSNode instance.

TypeScript

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

const owner = "0xffffffffff52d316b7bd028358089bc8066b8f80";
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.canonicalName))
  .limit(limit);

console.log(accountDomains);

Output

#	type	canonicalName	canonicalNode	id	ownerId
1	`ENSv1Domain`	`[3ad05e2a5922916840bc1e5e6039f00b27cbabf8d0428abce062aa2011307374].addr.reverse`	`0xd3947f90d04d7f41f973f09ad7dbdb34cb7463359369e6cf1663bbf928d66e53`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0xd3947f90d04d7f41f973f09ad7dbdb34cb7463359369e6cf1663bbf928d66e53`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
2	`ENSv1Domain`	`[52602a50858115661619fb28cf543ee766c182e0be6743c72d5bd674b3d12686].eth`	`0xe91ce3506cd47457c2b3f04c2736875ca1d17ed74bf1a328a7e64cca5ae8c94b`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0xe91ce3506cd47457c2b3f04c2736875ca1d17ed74bf1a328a7e64cca5ae8c94b`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
3	`ENSv1Domain`	`[8268685e13ae6bbfa54901f2954f9fcf80839ffa102fe7146b930623ce9bd7f0].addr.reverse`	`0x21c356e778799bfddf59a5683c04f6b08710d7c198fef466cc697563b2210785`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0x21c356e778799bfddf59a5683c04f6b08710d7c198fef466cc697563b2210785`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
4	`ENSv1Domain`	`[d90db363b8bc1371f7d738d264ff7294bfc5636f907c467adf68321a3c6d8188].eth`	`0x08c0f01c419a8971af6b3eefe2a8bba1556cccf1163df60b1cdbcab632c8ab48`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0x08c0f01c419a8971af6b3eefe2a8bba1556cccf1163df60b1cdbcab632c8ab48`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
5	`ENSv1Domain`	`[d99fc3d8237200c7122431276a337421cf793f51276873df5a54cc482fdbe685].addr.reverse`	`0x4fc87044c0adc4a0c996b9dafe3a4889e72fe0745fc76f18151b81ed73582218`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0x4fc87044c0adc4a0c996b9dafe3a4889e72fe0745fc76f18151b81ed73582218`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
6	`ENSv2Domain`	`eth`	`0x93cdeb708b7545dc668eb9280176169d1c33cfd8ed6f04690a0bcc88a93fc4ae`	`11155111-0x835f0b284e78cd3f358bcf6cba3b53809f09b79e-35894389512221139346028120028875095598761990588366713962827482865183915769856`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
7	`ENSv2Domain`	`reverse`	`0xa097f6721ce401e757d1223a763fef49b8b5f90bb18567ddb86fd205dff71d34`	`11155111-0x835f0b284e78cd3f358bcf6cba3b53809f09b79e-100753657518907091865523951670693454610893379027273088370152078482136467767296`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
8	`ENSv1Domain`	`reverse`	`0xa097f6721ce401e757d1223a763fef49b8b5f90bb18567ddb86fd205dff71d34`	`11155111-0xb6fb46e1458915dd828633d91e1df8e4c3f2d4dd-0xa097f6721ce401e757d1223a763fef49b8b5f90bb18567ddb86fd205dff71d34`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
9	`ENSv2Domain`	`sfmpfv44d0mig.eth`	`0x9b365136312d7ee6e232e3c98e459bc8667ec818c47fbbc55bb5e23d0a21e8cc`	`11155111-0x64c81210d0e580cfc7746f3fb910bf0e8f6378e1-30078755955643454526763071980293195785165410039216352470119925106082295316480`	`0xffffffffff52d316b7bd028358089bc8066b8f80`
10	`ENSv2Domain`	`sfmpfvtoicv2ok.eth`	`0x7d0c27336cf9d51c3fc8f29ef4ef69df9cd4a8ec983e3e17d457a8de6013f3c5`	`11155111-0x64c81210d0e580cfc7746f3fb910bf0e8f6378e1-49509597771493908415463190501045916291230588437784211605615168713991762477056`	`0xffffffffff52d316b7bd028358089bc8066b8f80`

Output matches a result snapshot; live output depends on your ENSNode instance.