Materialize/doc/user/content/sql/show-secrets.md

---

title: "SHOW SECRETS" description: "SHOW SECRETS lists the names of the secrets securely stored in Materialize's secret management system." menu: main:

parent: commands

---

SHOW SECRETS lists the names of the secrets securely stored in Materialize's secret management system. There is no way to show the contents of an existing secret, though you can override it using the ALTER SECRET statement.

Syntax

SHOW SECRETS [ FROM <schema_name> ] [ LIKE <pattern>  | WHERE <condition(s)> ]

Examples

SHOW SECRETS;

         name
-----------------------
 kafka_ca_cert
 kafka_sasl_password
 kafka_sasl_username

SHOW SECRETS FROM public LIKE '%cert%';

         name
-----------------------
 kafka_ca_cert

Related pages

• CREATE SECRET
• ALTER SECRET
• DROP SECRET

2025 开源项目分享^© -- 湘ICP备2025131302号

Page: 31ms Template: 1ms Javascript Licenses 关于我们

Option	Description
FROM	If specified, only show secrets from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.
LIKE <pattern>	If specified, only show secrets whose name matches the pattern.
WHERE	If specified, only show secrets that meet the condition(s).