PostgreSQL

PostgreSQL is a widely used open-source relational database system known for reliability, extensibility, and standards compliance. It stores structured data in tables and supports SQL for querying, transactions, and schema management.

With this integration, you can:

• Query data: Run SELECT statements to retrieve rows from a database
• Insert, update, and delete data: Write, modify, and remove rows in a table
• Execute raw SQL: Run arbitrary SQL statements directly against the database
• Introspect schemas: Retrieve table structures, columns, primary/foreign keys, and indexes

In Sim, the PostgreSQL integration allows your agents to connect to a PostgreSQL database and query, insert, update, delete, and execute raw SQL against it, as well as introspect the database schema to discover tables, columns, and relationships. This gives your agents the ability to read and write structured data as part of a workflow, and to understand a database's structure before generating or running queries against it.

Usage Instructions

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

Actions

postgresql_query

Execute a SELECT query on PostgreSQL database

Input

Output

postgresql_insert

Insert data into PostgreSQL database

Input

Output

postgresql_update

Update data in PostgreSQL database

Input

Output

postgresql_delete

Delete data from PostgreSQL database

Input

Output

postgresql_execute

Execute raw SQL query on PostgreSQL database

Input

Output

postgresql_introspect

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

Input

Output