exec_function_preview
Execute PostgreSQL functions with parameters to preview results for data exploration and analysis in the workbench-mcp environment.
Instructions
Execute a PostgreSQL function with positional parameters and return preview rows.
Use this tool for function calls such as
sales."Fn_GetSalesChamps"(2, 2025, ARRAY[1,2,5], 5).
Pass arguments in positional order using JSON-compatible values:
scalars:
2,2025,5arrays:
[1, 2, 5]null:
null
PostgreSQL array parameters should be passed as normal lists; psycopg adapts them to PostgreSQL arrays automatically.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| function_name | Yes | ||
| parameters | No | ||
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||