Table: supabase_secret - Query Supabase Secrets using SQL

Supabase Secrets are essentially the keys used to access and manage various aspects of a Supabase project. These keys are used to authenticate users, manage roles, and perform various operations within the project. Understanding and managing these secrets is crucial for maintaining security and access control within the Supabase environment.

Table Usage Guide

The supabase_secret table provides insights into the secrets within a Supabase project. As a security engineer or a project manager, you can explore secret-specific details through this table, including the secret key and its status. Use it to manage and monitor the security and access control of your Supabase project, ensuring the right access is provided to the right users and roles.

Examples

Basic info

Explore which project secrets are being used in your Supabase setup. This can help you manage and track the use of sensitive information across your projects.

select
  project_id,
  name,
  value
from
  supabase_secret;

select
  project_id,
  name,
  value
from
  supabase_secret;

List all secrets of a specific project

Discover the segments that contain all hidden or confidential information for a specific project. This can be useful in assessing data security and ensuring sensitive data is adequately protected.

select
  project_id,
  name,
  value
from
  supabase_secret
where
  project_id = 'pljlooizchwsteampipe';

select
  project_id,
  name,
  value
from
  supabase_secret
where
  project_id = 'pljlooizchwsteampipe';

Schema for supabase_secret

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
name	text		The name of the secret.
project_id	text		The ID of the project.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
value	text		The secret value.

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_secret