/

MongoDB

&

Postgres

Integrate MongoDB and Postgres

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

Node stack

Supported MongoDB and Postgres Nodes

Add any other tools or your preferred database nodes. If an integration is not available generate your own using AI

MongoDB Trigger

Trigger a workflow on data changes in your MongoDB database. Parse the incoming data payload from MongoDB and create a workflow connected to other apps. Check out the [Full Documentation](https://docs.buildship.com/trigger-nodes/mongodb-trigger) on how connect to your MongoDB project.

Delete Document

Deletes a document from a specified collection in MongoDB by document ID and returns the operation response.

Fetch Document

Fetches and returns the entire document data from a MongoDB collection based on the given document ID.

Full Text Search

This performs a full-text search in a specified MongoDB collection, conducts the search, returns matched documents. To enable full-text search (FTS) in MongoDB, follow this [guide](https://docs.buildship.com/tutorials/mongodb-search#full-text-search) on setting up MongoDB Search Index.

Hybrid Search

This performs a hybrid search in a specified MongoDB collection, conducts the search, returns matched documents. To enable semantic search in MongoDB, follow this [guide](https://docs.buildship.com/tutorials/mongodb-search#hybrid-search) on setting up search indexes.

Insert Document

Inserts the given data into a MongoDB collection and returns the ids of the inserted documents.

Query Collection

Queries for multiple documents in a MongoDB collection using connection string, database name, collection name, query, sort, and projection.

Semantic Search

This performs a semantic search in a specified MongoDB collection, conducts the search, returns matched documents. To enable semantic search in MongoDB, follow this [guide](https://docs.buildship.com/tutorials/mongodb-search#semantic-search) on setting up vector search index.

Update Document

Updates a specific document in a MongoDB collection using the updateOne function and returns the operation result.

Delete Row

Deletes a row from a specified table in a Postgres database

Fetch Table Data

Fetch data from a Postgres DB

Fetch Table Schema

Fetch the schema of a specific table in a PostgreSQL database

Insert Data

Inserts data into a specified table in a Postgres database securely

Update Row Data

Updates a specific row in a Postgres database table securely

Quick start

How to integrate MongoDB and Postgres

Step 1 — Add the nodes to your workflow

Create a new workflow in BuildShip, click “Add node”, and select the MongoDB and Postgres actions you want to use.

Step 2 — Configure each node

Go to each node to authenticate (or add your API key) and fill in the required parameters.

Step 3 — Connect the nodes

Each node in BuildShip can connect to others by using their output variables. When you reference a variable from one node in another, BuildShip automatically links them in the workflow.

Step 4 — Test your workflow

Define your starting data in the Inputs node and choose what to do with the result in the Flow Output node. Finally, run a test to see your workflow in action.

blog posts & tutorials

Recommended Reads

Below are recommneded blogs that will help in your journey