list_functions
List and filter chDB SQL functions by name. Returns function metadata including aggregate status, case sensitivity, and alias.
Instructions
List SQL functions available in the chDB engine.
Returns name, is_aggregate, case_insensitive, alias_to for
each entry in system.functions — useful for agents discovering
ClickHouse's 1000+ function library (windowFunnel, quantilesTDigest,
-If/-State/-Merge combinators, etc.) in one round trip.
Args: pattern: Optional case-insensitive substring filter on the function name. Plain text only; SQL wildcards and quotes are escaped.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |