Skip to main content

Other connectors

Besides REST APIs, the APIs section can connect to several non-SQL datasources. Each is configured with its connection details, after which you build queries that your apps can use.

Firestore

Connect to Google Cloud Firestore to read and write documents in your collections. Provide your project credentials, then create queries to fetch, filter, create, and update documents.

MongoDB

Connect to a MongoDB database using a connection string. The MongoDB connector is the most fully-featured of the non-SQL connectors and supports most common collection operations.

SettingDescription
Connection stringThe MongoDB URI, including host, credentials and options.
DatabaseThe database to query.

Building a query

Each MongoDB query targets a collection and a query type, then takes the relevant arguments (filter, document(s), update, options) as JSON. The available query types are:

CategoryOperations
Readfind, findOne, findOneAndUpdate, count, distinct
CreateinsertOne, insertMany
UpdateupdateOne, updateMany
DeletedeleteOne, deleteMany
Aggregateaggregation pipelines (json or pipeline)

Arguments are written as JSON and support bindings. Bindings in a query are placeholders that are filled in later from the app — you define them in the query's Data section and supply their values in the Design section.

For example, in the Data section a find filter might reference an owner binding:

{ "status": "active", "owner": {{ owner }} }

You then declare the owner binding (with an optional default value) alongside the query:

BindingDefault value
owner(optional)

When you bind this query to a component in the Design section, you map owner to a value that only exists in the app context — such as the logged-in end user:

{{ Current User._id }}

This separation keeps the query reusable while still letting it filter or update documents based on user input or app state.

Redis

Connect to a Redis instance to use it as a fast key/value store or cache. Configure the host, port, and password, then create queries that run Redis commands.

SettingDescription
Host / PortThe Redis server address.
PasswordThe Redis auth password, if set.

MinIO

MinIO is an S3-compatible object store. Connect it to read and write objects in buckets. MinIO also powers the file upload component, letting end users upload files directly to a bucket from your apps.

SettingDescription
EndpointThe MinIO server URL.
Access key / Secret keyCredentials for the bucket.
RegionThe bucket region, if applicable.

Using queries

Like REST queries, queries against these connectors can include bindings so they respond to user input and app state, and each query can be protected with a role.