Table: supabase_project_custom_hostname - Query Supabase Project Custom Hostnames using SQL

A Supabase Project Custom Hostname is an attribute of a Supabase project, which allows users to associate custom domain names with their projects. It enables the customization of the project's URL, thereby enhancing its accessibility and user-friendliness. This feature contributes to the flexibility and scalability of Supabase projects.

Table Usage Guide

The supabase_project_custom_hostname table provides insights into the custom domain names associated with a Supabase project. As a project manager or developer, you can explore details about these custom hostnames through this table, including their verification status, creation time, and associated project ID. Utilize it to manage and monitor the custom domain names of your Supabase projects.

Examples

Basic info

Explore which custom hostnames are associated with your Supabase projects, along with their status and creation date. This can be useful in managing and tracking your project's custom domain configurations.

select
  custom_hostname,
  status,
  data ->> 'created_at' as created_at,
  project_id
from
  supabase_project_custom_hostname;

select
  custom_hostname,
  status,
  json_extract(data, '$.created_at') as created_at,
  project_id
from
  supabase_project_custom_hostname;

List custom hostname that are yet to start

Discover the segments that include custom hostnames in your projects that are yet to begin. This is beneficial in managing project timelines and identifying potential delays.

select
  custom_hostname,
  status,
  project_id
from
  supabase_project_custom_hostname
where
  status = '1_not_started';

select
  custom_hostname,
  status,
  project_id
from
  supabase_project_custom_hostname
where
  status = '1_not_started';

List custom hostname created in last 3 days

Uncover the details of recent custom hostnames to monitor the development of your projects. This is particularly useful for keeping track of any new custom hostnames that have been created within the last three days.

select
  custom_hostname,
  status,
  data ->> 'created_at' as created_at,
  project_id
from
  supabase_project_custom_hostname
where
  (data ->> 'created_at') :: timestamp > (current_date - interval '3 days');

select
  custom_hostname,
  status,
  json_extract(data, '$.created_at') as created_at,
  project_id
from
  supabase_project_custom_hostname
where
  datetime(json_extract(data, '$.created_at')) > datetime(julianday('now') - 3);

Schema for supabase_project_custom_hostname

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
custom_hostname	text		The custom hostname.
data	jsonb		Specifies the custom hostname object for the specified project.
project_id	text		The ID of the project.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the hostname.

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)" -- supabase

You can pass the configuration to the command with the --config argument:

steampipe_export_supabase --config '<your_config>' supabase_project_custom_hostname