Set up docs MCPDescription
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-inhttp/httpsports 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 (onlyqueryis 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.