PostgreSQL

Usage Instructions

Integrate PostgreSQL into the workflow. Can query, insert, update, delete, and execute raw SQL.

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`query`	string	Yes	No description

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of rows returned from the query
`rowCount`	number	Number of rows returned

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`table`	string	Yes	No description
`data`	object	Yes	No description

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Inserted data (if RETURNING clause used)
`rowCount`	number	Number of rows inserted

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`table`	string	Yes	No description
`data`	object	Yes	No description
`where`	string	Yes	No description

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Updated data (if RETURNING clause used)
`rowCount`	number	Number of rows updated

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`table`	string	Yes	No description
`where`	string	Yes	No description

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Deleted data (if RETURNING clause used)
`rowCount`	number	Number of rows deleted

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`query`	string	Yes	No description

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of rows returned from the query
`rowCount`	number	Number of rows affected

Introspect PostgreSQL database schema to retrieve table structures, columns, and relationships

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`schema`	string	No	No description

Parameter	Type	Description
`message`	string	Operation status message
`tables`	array	Array of table schemas with columns, keys, and indexes
↳ `name`	string	Table name
↳ `schema`	string	Schema name (e.g., public)
↳ `columns`	array	Table columns
↳ `name`	string	Column name
↳ `type`	string	Data type (e.g., integer, varchar, timestamp)
↳ `nullable`	boolean	Whether the column allows NULL values
↳ `default`	string	Default value expression
↳ `isPrimaryKey`	boolean	Whether the column is part of the primary key
↳ `isForeignKey`	boolean	Whether the column is a foreign key
↳ `references`	object	Foreign key reference information
↳ `table`	string	Referenced table name
↳ `column`	string	Referenced column name
↳ `primaryKey`	array	Primary key column names
↳ `foreignKeys`	array	Foreign key constraints
↳ `column`	string	Local column name
↳ `referencesTable`	string	Referenced table name
↳ `referencesColumn`	string	Referenced column name
↳ `indexes`	array	Table indexes
↳ `name`	string	Index name
↳ `columns`	array	Columns included in the index
↳ `unique`	boolean	Whether the index enforces uniqueness
`schemas`	array	List of available schemas in the database