> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-vortex-format.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Contains a list of all SQL-defined HTTP handlers created via CREATE HANDLER.

# system.handlers

<h2 id="description">
  Description
</h2>

Contains a list of all SQL-defined HTTP handlers created via [`CREATE HANDLER`](/reference/statements/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`.

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types/string)) — Name of the handler.
* `protocol` ([Nullable(String)](/reference/data-types/nullable)) — 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](/reference/data-types/string)) — How the URL is matched: exact, prefix or regexp.
* `url` ([String](/reference/data-types/string)) — The URL pattern that the handler matches.
* `methods` ([Array(String)](/reference/data-types/array)) — Allowed HTTP methods.
* `type` ([String](/reference/data-types/string)) — The handler type (only `query` is supported).
* `query` ([String](/reference/data-types/string)) — The SQL query executed by the handler. Secrets are hidden unless the user is allowed to see them.
* `create_query` ([String](/reference/data-types/string)) — The CREATE HANDLER statement. Secrets are hidden unless the user is allowed to see them.