Description
Contains a list of all SQL-defined HTTP handlers created via CREATE HANDLER.
Reading this table requires the SHOW HANDLERS privilege; without it the table appears empty. Secrets that
may be embedded in the handler’s query (for example, credentials passed to a table function) are shown in the
query and create_query columns only when the user is allowed to see secrets (the
display_secrets_in_show_and_select server setting and format_display_secrets_in_show_and_select format
setting are enabled and the user holds the displaySecretsInShowAndSelect privilege); otherwise, they are
masked, exactly as in SHOW CREATE TABLE.
Columns
name (String) — Name of the handler.protocol (Nullable(String)) — Composable protocol the handler is restricted to, or NULL if the handler is active on all HTTP endpoints (the built-in http/https ports and every HTTP-type composable protocol listener).url_match_type (String) — How the URL is matched: exact, prefix or regexp.url (String) — The URL pattern that the handler matches.methods (Array(String)) — Allowed HTTP methods.type (String) — The handler type (only query is supported).query (String) — The SQL query executed by the handler. Secrets are hidden unless the user is allowed to see them.create_query (String) — The CREATE HANDLER statement. Secrets are hidden unless the user is allowed to see them.
Last modified on August 26, 2026
