Zapier is a workflow automation tool that allows you to connect triggers to actions to create powerful automated processes. By connecting Zapier to, you could have new row inserts in your database trigger a facebook post, for example (read from Postgres). You could also set up a Zap that would trigger when you receive an email from a specific sender, and increment an integer in a specific row in your Postgres database (write to Postgres).

Connecting to with Zapier

In order to connect Zapier with, you'll need to find your PostgreSQL connection credentials from the Connect Tab of the database to which you would like to connect. You can find everything you need to know about your PostgreSQL credentials here

To get started, first select PostgreSQL as a trigger.


Select PostgreSQL as a trigger

Next, select and event type.


Select an event type

Enter your Postgres credentials, which can be found on the Connect Tab


Enter your credentials. Please see note below about database name change.


You must change the database name!

Database names on are typically in the format [username]/[database_name]. Zapier's Postgres client does not support "/"'s in the database name, so you must change this to [username].[database_name].

Once the "/" is replaced with a ".", all other credential's from's connect tab should work unchanged

Lastly, test your trigger. You're now ready to start working with actions.


Test your trigger and start playing with actions!

For more info on Zapier's PostgreSQL integrations, check out their docs