Use PostgreSQL to query and modify rows, execute SQL, and inspect tables, columns, keys, and indexes. Schema inspection lets a workflow discover the database structure before generating a query.
Query or modify PostgreSQL rows, execute SQL, and inspect tables, columns, keys, and indexes.
Execute a SELECT query on PostgreSQL database
Parameter Type Required Description hoststring Yes PostgreSQL server hostname or IP address portnumber Yes PostgreSQL server port (default: 5432) databasestring Yes Database name to connect to usernamestring Yes Database username passwordstring Yes Database password sslstring No SSL connection mode (disabled, required, preferred) querystring Yes SQL SELECT query to execute
Parameter Type Description messagestring Operation status message rowsarray Array of rows returned from the query rowCountnumber Number of rows returned
Insert data into PostgreSQL database
Parameter Type Required Description hoststring Yes PostgreSQL server hostname or IP address portnumber Yes PostgreSQL server port (default: 5432) databasestring Yes Database name to connect to usernamestring Yes Database username passwordstring Yes Database password sslstring No SSL connection mode (disabled, required, preferred) tablestring Yes Table name to insert data into dataobject Yes Data object to insert (key-value pairs)
Parameter Type Description messagestring Operation status message rowsarray Inserted data (if RETURNING clause used) rowCountnumber Number of rows inserted
Update data in PostgreSQL database
Parameter Type Required Description hoststring Yes PostgreSQL server hostname or IP address portnumber Yes PostgreSQL server port (default: 5432) databasestring Yes Database name to connect to usernamestring Yes Database username passwordstring Yes Database password sslstring No SSL connection mode (disabled, required, preferred) tablestring Yes Table name to update data in dataobject Yes Data object with fields to update (key-value pairs) wherestring Yes WHERE clause condition (without WHERE keyword)
Parameter Type Description messagestring Operation status message rowsarray Updated data (if RETURNING clause used) rowCountnumber Number of rows updated
Delete data from PostgreSQL database
Parameter Type Required Description hoststring Yes PostgreSQL server hostname or IP address portnumber Yes PostgreSQL server port (default: 5432) databasestring Yes Database name to connect to usernamestring Yes Database username passwordstring Yes Database password sslstring No SSL connection mode (disabled, required, preferred) tablestring Yes Table name to delete data from wherestring Yes WHERE clause condition (without WHERE keyword)
Parameter Type Description messagestring Operation status message rowsarray Deleted data (if RETURNING clause used) rowCountnumber Number of rows deleted
Execute raw SQL query on PostgreSQL database
Parameter Type Required Description hoststring Yes PostgreSQL server hostname or IP address portnumber Yes PostgreSQL server port (default: 5432) databasestring Yes Database name to connect to usernamestring Yes Database username passwordstring Yes Database password sslstring No SSL connection mode (disabled, required, preferred) querystring Yes Raw SQL query to execute
Parameter Type Description messagestring Operation status message rowsarray Array of rows returned from the query rowCountnumber Number of rows affected
Introspect PostgreSQL database schema to retrieve table structures, columns, and relationships
Parameter Type Required Description hoststring Yes PostgreSQL server hostname or IP address portnumber Yes PostgreSQL server port (default: 5432) databasestring Yes Database name to connect to usernamestring Yes Database username passwordstring Yes Database password sslstring No SSL connection mode (disabled, required, preferred) schemastring No Schema to introspect (default: public)
Parameter Type Description messagestring Operation status message tablesarray 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 schemasarray List of available schemas in the database
