Domain by Name

Fetch a Domain by its canonical name. Because canonical_name is materialized across both ENSv1 and ENSv2, the same lookup works regardless of protocol version. 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
  id,
  type,
  canonical_name,
  canonical_node,
  owner_id
FROM "ensindexer_0".domains
WHERE canonical_name = 'vitalik.eth'
AND canonical = true;

Output

#	id	type	canonical_name	canonical_node	owner_id
1	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835	ENSv1Domain	vitalik.eth	0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835	0x220866b1a2219f40e72f5c628b65d54268ca3a9d

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 } from "drizzle-orm";

const name = "vitalik.eth";

const domains = await ensDb
  .select({
    id: ensIndexerSchema.domain.id,
    type: ensIndexerSchema.domain.type,
    canonicalName: ensIndexerSchema.domain.canonicalName,
    canonicalNode: ensIndexerSchema.domain.canonicalNode,
    ownerId: ensIndexerSchema.domain.ownerId,
  })
  .from(ensIndexerSchema.domain)
  .where(
    and(
      eq(ensIndexerSchema.domain.canonicalName, name),
      eq(ensIndexerSchema.domain.canonical, true)
    )
  );

console.log(domains);

Output

#	id	type	canonicalName	canonicalNode	ownerId
1	1-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835	ENSv1Domain	vitalik.eth	0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835	0x220866b1a2219f40e72f5c628b65d54268ca3a9d

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.