AppsPricingBlogTry it
Salesforce logo
PostgreSQL logo

Connect Salesforce to PostgreSQL

Build an AI agent that works across Salesforce and PostgreSQL, on a schedule or when you click Run.

24 source actions
9 target actions
Reverse direction supported

Why Connect Salesforce & PostgreSQL?

Read what you need from Salesforce

Your agent uses Salesforce's documented actions to pull the records it needs, each time it runs.

Run a PostgreSQL action

Then it uses one of 9 documented actions, such as Execute SQL Query, Delete Row(s), Find Row.

Test it, then put it on a schedule

Run it once on your own data and check the result. Then set it to run daily, on weekdays or weekly.

Available Triggers & Actions

Salesforce logo

Salesforce

Triggers (10)

Case Updated (Instant, of Selectable Type)

Emit new event when a case is updated. See the documentation

webhook
Email Template Updated (Instant, of Selectable Type)

Emit new event when an email template is updated. See the documentation

webhook
Knowledge Article Updated (Instant, of Selectable Type)

Emit new event when a knowledge article is updated. See the documentation

webhook
New Case (Instant, of Selectable Type)

Emit new event when a case is created. See the documentation

webhook
New Deleted Record (Instant, of Selectable Type)

Emit new event when a record of the selected object type is deleted. See the documentation

webhook
New Email Template (Instant, of Selectable Type)

Emit new event when an email template is created. See the documentation

webhook
New Knowledge Article (Instant, of Selectable Type)

Emit new event when a knowledge article is created. See the documentation

webhook
New Outbound Message (Instant)

Emit new event when a new outbound message is received in Salesforce.

webhook
New Record (Instant, of Selectable Type)

Emit new event when a record of the selected object type is created. See the documentation

webhook
New Updated Record (Instant, of Selectable Type)

Emit new event when a record of the selected type is updated. See the documentation

webhook

Actions (24)

Add Contact to Campaign

Adds an existing contact to an existing campaign. See the documentation

Add Lead to Campaign

Adds an existing lead to an existing campaign. See the documentation

Convert SOAP XML Object to JSON

Converts a SOAP XML Object received from Salesforce to JSON

Create Account

Creates a Salesforce account. See the documentation

Create Accounts (Batch)

Create multiple Accounts in Salesforce using Bulk API 2.0. See the documentation

Create Attachment

Creates an Attachment on a parent object. See the documentation

Create Campaign

Creates a marketing campaign. See the documentation

Create Case

Creates a Case, which represents a customer issue or problem. See the documentation

Create Case Comment

Creates a Case Comment on a selected Case. See the documentation

Create Contact

Creates a contact. See the documentation

Create Content Note

Creates a content note. See the documentation and Set Up Notes.

Create Event

Creates an event. See the documentation

Create Lead

Creates a lead. See the documentation

Create Note

Creates a note. See the documentation

Create Opportunities (Batch)

Create multiple Opportunities in Salesforce using Bulk API 2.0. See the documentation

Create Opportunity

Creates an opportunity. See the documentation

Create Record

Create a record of a given object. See the documentation

Create Record

Create a new Salesforce record of any object type. Use **Describe Object** first if you're unsure what fields are available or required. For picklist fields, use the API value from **Describe Object**, not the display label. **Common required fields:** - Account: Name - Contact: LastName - Lead: LastName, Company - Opportunity: Name, StageName, CloseDate - Case: Subject - Task: Subject - Event: Subject, StartDateTime, EndDateTime To add a Contact/Lead to a Campaign, create a CampaignMember: {"CampaignId": "701xxx", "ContactId": "003xxx"} or {"CampaignId": "701xxx", "LeadId": "00Qxxx"}.

Create Task

Creates a task. See the documentation

Create User

Creates a Salesforce user. See the documentation

Delete Note Or Content Note

Delete a note or content note from a Salesforce record. See the documentation

Delete Opportunity

Deletes an opportunity. See the documentation

Delete Record

Permanently deletes a Salesforce record (moves to Recycle Bin for 15 days). Use **SOQL Query** to find the record ID if you only have the record name.

Delete Record

Deletes an existing record in an object. See the documentation

PostgreSQL logo

PostgreSQL

Triggers (5)

New Column

Emit new event when a new column is added to a table. See the documentation

polling
New or Updated Row

Emit new event when a row is added or modified. See the documentation

polling
New Row

Emit new event when a new row is added to a table. See the documentation

polling
New Row Custom Query

Emit new event when new rows are returned from a custom query that you provide. See the documentation

polling
New Table

Emit new event when a new table is added to the database. See the documentation

polling

Actions (9)

Execute SQL Query

Execute a custom PostgreSQL query. See our docs to learn more about working with SQL in Mazaal AI.

Delete Row(s)

Deletes a row or rows from a table. See the documentation

Find Row

Finds a row in a table via a lookup column. See the documentation

Find Row With Custom Query

Finds a row in a table via a custom query. See the documentation

Insert Row

Adds a new row. See the documentation

List Schema Options

Retrieves available options for the Schema field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Update Row

Updates an existing row. See the documentation

Upsert Row

Adds a new row or updates an existing row. See the documentation

Integration Features

24 documented Salesforce actions
9 documented PostgreSQL actions
Plain-English agent instructions
Daily, weekday or weekly schedule, or run on demand
Execution monitoring
A supported PostgreSQL to Salesforce direction

Capability Examples

Salesforce trigger → PostgreSQL action

Catalog example
SalesforceSalesforce

Case Updated (Instant, of Selectable Type)

PostgreSQLPostgreSQL

Execute SQL Query

PostgreSQL trigger → Salesforce action

Reverse direction
PostgreSQLPostgreSQL

New Column

SalesforceSalesforce

Add Contact to Campaign

How It Works

1

Connect Apps

Authenticate your Salesforce and PostgreSQL accounts

2

Describe the Job

Say what to read from Salesforce and what to do in PostgreSQL

3

Choose an Action

Select the documented PostgreSQL operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Scheduled or On-demand Runs

Runs daily, on weekdays or weekly at a set time, or when you click Run. It does not fire on live Salesforce events yet.

Automated Actions

Use 9 documented PostgreSQL actions each time the agent runs.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Describe the job in plain English. The agent picks theSalesforce and PostgreSQL actions it needs.

Your Own Accounts

You connect your own Salesforce and PostgreSQL accounts. App connections need a paid plan.

Execution Review

Test the workflow and review provider responses before relying on it in production.

PostgreSQL logoSalesforce logo

Reverse Integration Available

Also connect PostgreSQL to Salesforce for bidirectional automation

View Integration
Salesforce logo

All Salesforce Integrations

Explore all available Salesforce connections

View All Integrations
PostgreSQL logo

All PostgreSQL Integrations

Explore all available PostgreSQL connections

View All Integrations

Ready to Connect Salesforce & PostgreSQL?

Build this agent in Mazaal AI and test it on your ownSalesforce and PostgreSQL data.

Start building

Rather not build it yourself? We set up one Salesforce to PostgreSQL agent on your accounts for A$490: a 30-minute call, a test on your real data, and 14 days of fixes. Plan billed separately. Email Enod