Data Processing & Analysis

0873 Stickynote Postgrestool Create Triggered

Complex

High

Nodes

Complex

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

postgres Tool

GetTableSchema, ListTables

2 nodes

execute Workflow Trigger

When Executed by Another Workflow

1 node

tool Workflow

ReadTableRows, CreateTableRecords, UpdateTableRecords

3 nodes

postgres

ReadTableRecord, UpdateTableRecord, CreateTableRecord

3 nodes

switch

Operation

1 node

sticky Note

Sticky Note, Sticky Note1, Sticky Note2, Sticky Note3

4 nodes

mcp Trigger

PostgreSQL MCP Server

1 node

Workflow JSON

21.01 KB

{
  "meta": {
    "instanceId": "408f9fb9940c3cb18ffdef0e0150fe342d6e655c3a9fac21f0f644e8bedabcd9",
    "templateCredsSetupCompleted": true
  },
  "name": "0873 Stickynote Postgrestool Create Triggered",
  "nodes": [
    {
      "id": "0c49141e-128c-424e-afdf-ea131b7a3dd8",
      "name": "GetTableSchema",
      "type": "n8n-nodes-base.postgresTool",
      "position": [
        -460,
        220
      ],
      "parameters": {
        "query": "SELECT column_name, data_type FROM information_schema.columns WHERE table_name = $1",
        "options": {
          "queryReplacement": "={{ $fromAI('tableName', 'The name of the table.') }}"
        },
        "operation": "executeQuery",
        "descriptionType": "manual",
        "toolDescription": "Read a table's schema."
      },
      "credentials": {
        "postgres": {
          "id": "elRn5sxKOfCdlEs6",
          "name": "Postgres account"
        }
      },
      "typeVersion": 2.6
    },
    {
      "id": "8ffeefb9-357c-41bc-8239-0c...

Showing first 1000 characters. Click "Expand" to view the full JSON.