> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/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.

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

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