listRoutines
listRoutinesDiscover database function, procedure, and package names in a schema, optionally filtered by a name pattern.
Instructions
Discover function, procedure and package names in a schema, optionally by name pattern. Use getRoutineDefinition when the source of one known routine is needed.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>"
},
"name": "listRoutines"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| namePattern | No | JDBC name pattern, e.g. '%calculate%'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| routines | No | Function, procedure, and package entries. |