Integrate BuildShip Database and Postgres to automate workflows with scalable backend

Connect BuildShip Database and Postgres nodes to in your workflow. Integrate with any tool or database and ship powerful backend logic and APIs instantly - No code required!

getting started

How To Connect BuildShip Database and Postgres

Supported Triggers & Actions

BuildShip Database NODES

Add Object to Array

Adds an object to an existing array in a Firestore document

BuildShip Document Count

Get the count of documents in a collection for a given filter

Collection Query

Get documents of a query in Firestore with multiple filters. See [documentation](https://docs.buildship.com/basics/buildship-tables#querying-collection) for full details.

Create Document

Creates or updates a document in a specified Firestore collection (with Document Reference field type support).

Delete Document

Delete a document from a BuildShip's Firestore collection

Field Average

Average of field in collection for given filter

Field Sum

Sum of field in collection for given filter

Get Document

Fetch a document from BuildShip's Firestore DB by its collection name and ID

script

Get Field Value

Fetches a specific field value from a document in a BuildShip's Firestore collection

script

Query Count

Get server count of a query in Firestore with multiple filters

script

Update Field Value

Updates a field value in BuildShip's Firestore document with a given object

script

Postgres NODES

Delete Row

Deletes a row from a specified table in a Postgres database

script

Fetch Table Data

Fetch data from a Postgres DB

script

Fetch Table Schema

Fetch the schema of a specific table in a PostgreSQL database

script

Insert Data

Inserts data into a specified table in a Postgres database securely

script

Update Row Data

Updates a specific row in a Postgres database table securely

script

blog posts & tutorials

Recommended Reads

Below are recommneded blogs that will help in your journey