golem-add-postgres-ts

You connect a TypeScript Golem agent to PostgreSQL by using the golem:rdbms/[email protected] DbConnection interface. This enables your agent to establish database connections and execute SQL statements safely using normal try/catch handling for failures.

You run parameterized SQL queries in TypeScript by using PostgreSQL-style $1, $2 placeholders and passing typed DbValue parameters. This approach ensures safe data access and prevents SQL injection when executing SELECT, INSERT, or UPDATE statements from your agent code.

Yes, you can execute transactional database updates from a Golem TypeScript agent. Use the beginTransaction method to start a transaction, execute your SQL updates, and call commit to apply atomic changes across multiple tables for data consistency.

PostgreSQL parameterized queries in TypeScript use Pg-style $1, $2, ... placeholder syntax. You bind values to these placeholders using typed DbValue parameters, ensuring safe query execution without hand-rolling boilerplate connection code.

Yes, this Skill supports atomic updates across multiple PostgreSQL tables. By using beginTransaction and commit within your TypeScript agent, you can execute multiple related SQL statements and ensure they either all succeed or roll back to maintain data consistency.