pg_manage_functions
Manage PostgreSQL functions effectively with operations to get, create, or drop functions. Specify parameters, return types, and function bodies for creation, or use filters for listing and removal.
Instructions
Manage PostgreSQL functions - get, create, or drop functions with a single tool. Examples: operation="get" to list functions, operation="create" with functionName="test_func", parameters="" (empty for no params), returnType="TEXT", functionBody="SELECT 'Hello'"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cascade | No | Whether to include CASCADE clause (for drop operation) | |
| connectionString | No | PostgreSQL connection string (optional) | |
| functionBody | No | Function body code (required for create operation) | |
| functionName | No | Name of the function (required for create/drop, optional for get to filter) | |
| ifExists | No | Whether to include IF EXISTS clause (for drop operation) | |
| language | No | Function language (defaults to plpgsql for create) | |
| operation | Yes | Operation to perform: get (list/info), create (new function), or drop (remove function) | |
| parameters | No | Function parameters - required for create operation, required for drop when function is overloaded. Use empty string "" for functions with no parameters | |
| replace | No | Whether to replace the function if it exists (for create operation) | |
| returnType | No | Return type of the function (required for create operation) | |
| schema | No | Schema name (defaults to public) | |
| security | No | Function security context (defaults to INVOKER for create) | |
| volatility | No | Function volatility (defaults to VOLATILE for create) |