PostgreSQL
Connect to PostgreSQL database
Configuration
Query (SELECT)
Operation
Query (SELECT)
Host*
localhost or your.database.host
Port*
5432
Database Name*
your_database
Username*
postgres
Password*
••••••••
SSL Mode
Select...
SQL Query*
sql
SELECT * FROM users WHERE active = true
Query (SELECT) (
postgresql_query)Execute a SELECT query on PostgreSQL database
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
host | string | Yes | PostgreSQL server hostname or IP address |
port | number | Yes | PostgreSQL server port (default: 5432) |
database | string | Yes | Database name to connect to |
username | string | Yes | Database username |
password | string | Yes | Database password |
ssl | string | No | SSL connection mode (disabled, required, preferred) |
query | string | Yes | SQL SELECT query to execute |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of rows returned from the query |
Insert Data
Operation
Insert Data
Host*
localhost or your.database.host
Port*
5432
Database Name*
your_database
Username*
postgres
Password*
••••••••
SSL Mode
Select...
Table Name*
users
Data (JSON)*
json
{\n "name": "John Doe",\n "email": "john@example.com",\n "active": true\n}
Insert Data (
postgresql_insert)Insert data into PostgreSQL database
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
host | string | Yes | PostgreSQL server hostname or IP address |
port | number | Yes | PostgreSQL server port (default: 5432) |
database | string | Yes | Database name to connect to |
username | string | Yes | Database username |
password | string | Yes | Database password |
ssl | string | No | SSL connection mode (disabled, required, preferred) |
table | string | Yes | Table name to insert data into |
data | object | Yes | Data object to insert (key-value pairs) |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Inserted data (if RETURNING clause used) |
Update Data
Operation
Update Data
Host*
localhost or your.database.host
Port*
5432
Database Name*
your_database
Username*
postgres
Password*
••••••••
SSL Mode
Select...
Table Name*
users
Update Data (JSON)*
json
{\n "name": "Jane Doe",\n "email": "jane@example.com"\n}
WHERE Condition*
id = 1
Update Data (
postgresql_update)Update data in PostgreSQL database
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
host | string | Yes | PostgreSQL server hostname or IP address |
port | number | Yes | PostgreSQL server port (default: 5432) |
database | string | Yes | Database name to connect to |
username | string | Yes | Database username |
password | string | Yes | Database password |
ssl | string | No | SSL connection mode (disabled, required, preferred) |
table | string | Yes | Table name to update data in |
data | object | Yes | Data object with fields to update (key-value pairs) |
where | string | Yes | WHERE clause condition (without WHERE keyword) |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Updated data (if RETURNING clause used) |
Delete Data
Operation
Delete Data
Host*
localhost or your.database.host
Port*
5432
Database Name*
your_database
Username*
postgres
Password*
••••••••
SSL Mode
Select...
Table Name*
users
WHERE Condition*
id = 1
Delete Data (
postgresql_delete)Delete data from PostgreSQL database
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
host | string | Yes | PostgreSQL server hostname or IP address |
port | number | Yes | PostgreSQL server port (default: 5432) |
database | string | Yes | Database name to connect to |
username | string | Yes | Database username |
password | string | Yes | Database password |
ssl | string | No | SSL connection mode (disabled, required, preferred) |
table | string | Yes | Table name to delete data from |
where | string | Yes | WHERE clause condition (without WHERE keyword) |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Deleted data (if RETURNING clause used) |
Execute Raw SQL
Operation
Execute Raw SQL
Host*
localhost or your.database.host
Port*
5432
Database Name*
your_database
Username*
postgres
Password*
••••••••
SSL Mode
Select...
SQL Query*
sql
SELECT * FROM table_name
Execute Raw SQL (
postgresql_execute)Execute raw SQL query on PostgreSQL database
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
host | string | Yes | PostgreSQL server hostname or IP address |
port | number | Yes | PostgreSQL server port (default: 5432) |
database | string | Yes | Database name to connect to |
username | string | Yes | Database username |
password | string | Yes | Database password |
ssl | string | No | SSL connection mode (disabled, required, preferred) |
query | string | Yes | Raw SQL query to execute |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of rows returned from the query |
Usage Instructions
Integrate PostgreSQL into the workflow. Can query, insert, update, delete, and execute raw SQL.
Notes
- Category:
tools - Type:
postgresql