DataFlows.io
DatabaseStable

PostgreSQL Connector

Direct database access for high-performance data operations.

Overview

The PostgreSQL connector allows you to directly interact with your database within your workflows. Unlike generic SQL connectors, this integration is built for high-performance and type safety.

It automatically introspects your database schema to generate TypeScript interfaces, ensuring that your queries are checked at compile time. This prevents runtime errors caused by schema mismatches or typos in column names.

Key Capabilities

  • Zero-Latency Triggers: Use `LISTEN/NOTIFY` to trigger workflows immediately when data changes in your database.
  • Atomic Transactions: Execute multiple steps within a single transaction. If any step fails, the entire transaction is rolled back.
  • Connection Management: Built-in connection pooling ensures that your database doesn't get overwhelmed, even under high load.

Features

Connection Pooling

Efficiently manage database connections for high-concurrency.

Type-Safe Queries

Generate TypeScript types from your database schema.

Listen/Notify

Trigger workflows instantly on database changes using PG Notify.

Transactions

Wrap multiple workflow steps in a database transaction.

Technical Specifications

Auth Methods
Connection StringSSL/TLS
API Coverage
SQL, Listen/Notify
Realtime