PostgreSQL | Chatigram Documentation

Plan availability #

Feature	Free	Starter	Pro	Enterprise
Active workflows	3	10	45	Unlimited

Allowances follow the published Chatigram pricing page. Your organization’s Billing & Plans screen confirms its subscription and current usage. Plans can change. Plan information reviewed 2026-11-10.

What you can do #

Query a connected PostgreSQL database and work with database events.

This reference includes 7 actions. A connection for workflow actions and a customer-facing Line serve different purposes: connecting an app does not automatically create an Inbox channel.

Connect your account #

Open App Connections in the organization where you will build the workflow.
Choose the PostgreSQL connection that matches your task.
Complete the provider’s sign-in or the protected connection form. Enter credentials only in that form.
Return to your workflow, add the action, and select the connected account.
Choose a test resource and check a small operation before enabling the workflow.

Choose a compatible connection #

Actions declare these connection types. Check the account selector on the individual action; some actions support only a subset.

postgresql
postgresql.automation

External database or Chatigram Database? #

These actions connect to a database you manage. For tables created inside Chatigram, use Chatigram Database nodes instead. Start with a restricted database account and a read-only query. Review writes carefully; retrying a write can create duplicate records.

Available actions #

Action	Use it to
PostgreSQL: Connection & Automation	Check PostgreSQL connection status and control automation processors. Works with both PostgreSQL and PostgreSQL Automation integrations. Automation control only available for PostgreSQL Automation.
PostgreSQL: Delete Data	Delete rows from a PostgreSQL table with WHERE conditions. ⚠️ SECURITY: Use parameterized WHERE clauses ($1, $2, ...) to prevent SQL injection. Example: 'id = $1 AND status = $2'
PostgreSQL: Execute Query	Execute a raw SQL query on PostgreSQL database with optional parameters. ⚠️ SECURITY WARNING: Always use parameterized queries ($1, $2, ...) to prevent SQL injection attacks. Never concatenate user input directly into SQL strings.
PostgreSQL: Get Automation Event	Retrieve details of a PostgreSQL automation event that triggered a webhook. Use this after a Webhook Trigger node to get database change information.
PostgreSQL: Get Table Schema	Get detailed schema information for a PostgreSQL table including columns, indexes, and foreign keys
PostgreSQL: Insert Data	Insert a new row into a PostgreSQL table
PostgreSQL: Update Data	Update existing rows in a PostgreSQL table with WHERE conditions. ⚠️ SECURITY: Use parameterized WHERE clauses ($1, $2, ...) to prevent SQL injection. Example: 'id = $1 AND status = $2'

Work with events #

Some services offer separate automation connections or event-retrieval actions. When available, configure the event source and workflow trigger together. A successful account connection alone does not mean that events are being delivered. Test with a new event and check Workflow Activity.

Common problems #

No account in the selector: confirm the organization, service, and connection type.
Access denied: verify access to the exact resource, not just a successful sign-in.
No events: check the automation settings, event type, and trigger configuration.
Duplicate actions: inspect the destination before retrying a failed or timed-out run.
Provider restrictions: available actions, quotas, and permissions depend on the connected provider account.

Continue with App Connections or troubleshooting.

Catalog coverage #

This is the currently documented selection. Chatigram continues to add nodes, triggers, App Connections, and integrations. Use each page’s review date and the current application selectors to check what is available now; this catalog is not a fixed limit on future features.