Integrate Firestore and MySQL to automate workflows with scalable backend

Connect Firestore and MySQL 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 Firestore and MySQL

Supported Triggers & Actions

Firestore NODES

Add Object to Firestore Array

Adds an object to an existing array in a Firestore document

Collection Query

Get documents of a query in Firestore with multiple filters (with support for document reference).

Create Document

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

Delete Firestore Document

Delete a document from a Firestore collection

Firestore Document Count

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

Firestore Field Average

This is blank script node to help you get started. [Full Documentation](https://docs.buildship.com/core-nodes/script).

Firestore Field Sum

Sum of field in collection for given filter

Firestore Query Count

Get server count of a query in Firestore with multiple filters

script

Get Document Field Value

Fetches a specific field value from a document in a Firestore collection

script

Get Firestore Document

Fetch a document from Firestore by its collection name and ID

script

Get User Data With Email

Fetch user data from Firebase Auth based given their email

script

Update Document

Updates an entire Firestore document with a given object

script

Update Field Value

Updates a field value in a Firestore document with a given object

script

MySQL NODES

Delete Row

Deletes row(s) from a MySQL table based on a filter

script

Insert Row

Inserts a row into a MySQL database table

script

Select Query

Perform Select query from a MySQL table

script

SQL Query

Executes an SQL query on a specified database

script

Update Row

Updates row(s) in a MySQL table based on a filter.

script

blog posts & tutorials

Recommended Reads

Below are recommneded blogs that will help in your journey