postgresql Setup Helper
query_contextsHelper for planning InsightfulPipe postgresql requests.
Step 1: request='accounts' – Retrieve workspace_id, brand_id, connection_slug, other source metadata, AND available_actions (all read-only actions you can call).
Step 2: request='actions_details' with actions=['xxxxxx', 'xxxxxx', 'xxxxxx'] – REQUIRED before querying. Replace with actions from available_actions to get the exact request body, required identifiers, fields, and notes for each action.
Optional: request='available_actions' – Standalone call to list all available actions (already included in accounts response).
Optional: request='brands' with brand_id + workspace_id to pull brand guidelines.
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": {
"request": "<request>"
},
"name": "query_contexts"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| actions | No | ||
| request | Yes | ||
| brand_id | No | ||
| platform | No | ||
| workspace_id | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||