PostgreSQL MCP by InsightfulPipe

Execute postgresql action (Step 3 (FINAL) of workflow).

REQUIRED: Complete these steps first using query_contexts:

1. request='accounts' - Get workspace_id, brand_id, connection_slug AND available_actions

2. request='actions_details' with actions=['xxxxxx', 'xxxxxx', 'xxxxxx'] - Get detailed body structure for specific action(s) using actions from available_actions

IMPORTANT: Always call step 2 to see the exact body structure before executing.

execute_action runs write SQL (INSERT/UPDATE/DELETE/DDL). Writes succeed only if your workspace role allows writes and the connected database role has the needed privileges.

Access postgresql prompt catalog with 4 operations:

1. List Public Prompts: • request='menu' - No additional params needed • Returns: All public/system prompts available for postgresql

2. List Custom Prompts: • request='menu', prompt_type='custom', workspace_id= • Returns: All custom prompts for the specified workspace

3. Get Public Prompt Details: • request='prompt_details', prompt_id= • Returns: Full text/details of a public prompt

4. Get Custom Prompt Details: • request='prompt_details', prompt_id=, is_custom=True, workspace_id= • Returns: Full text/details of a custom prompt

Helper 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.

Query postgresql data (Step 3 (FINAL) of workflow).

REQUIRED: Complete these steps first using query_contexts:

1. request='accounts' - Get workspace_id, brand_id, connection_slug AND available_actions

2. request='actions_details' with actions=['xxxxxx', 'xxxxxx', 'xxxxxx'] - Get detailed body structure for specific action(s) using actions from available_actions

IMPORTANT: Always call step 2 to see the exact body structure before querying.

query_data accepts read-only SQL only: a single SELECT (or EXPLAIN) statement. Write statements (INSERT/UPDATE/DELETE/DDL) are rejected here - send them through execute_action.