Getting Started

[Zertz]

Get the app

Mac App Store

Connecting to MongoDB

1. Find the connection string to your database
2. Launch Spruce and select "Connect to MongoDB" or click the + icon in the upper right corner
3. Enter your connection string
4. Optionally enter a label to identify the connection (and not get mixed up!)
5. Pick a color (you may want a blue or green tint for your development database and a red tint for your production database)

---

Here's a few tips for the common providers:

MongoDB Atlas

1. Select your project
2. Click "Connect"
3. Select "Connect your application"
4. Copy the connection string, replacing the username, password, and database placeholders

Local installation

White this may vary depending on your particular set up, the default connection URI typically is mongodb://localhost:27017

---

Querying

Queries in Spruce have a slightly different syntax that you may be used to, here's how it works:

• By ObjectId:

{
  "_id": "ObjectId(60a46e47d43bb5bb283720f6)"
}

• With an arbitrary field:

{
  "hello": "world"
}

• Using operators:

{
  "population": {
    "$gte": 42
  }
}

Sorting

Select the + Sort button below the query to show the sort input. Here's an example of sort options to get the latest documents in a collection (this will vary depending on your data structure):

{
  "created_at": -1
}