ShotPulled

List coffees

list_beans

Read-onlyIdempotent

List the coffees registered for the account, with status filter. Each coffee carries its bags[] (every purchase, with its own freshness and grams left) and current_bag_id; the row's top-level roast_date, state, grams_remaining and age fields are the current bag's. The id on each row is the number this account knows that coffee by, counting from 1: safe to show, and what other tools expect back; bag ids are a separate series.

Input Schema

TableJSON Schema

Name	Required	Description	Default
`status`	No	Filter by status: current, archived, or all. Defaults to current.

Output Schema

TableJSON Schema

Name	Required	Description	Default
`beans`	Yes

Schema Changelog

Changes observed during successful MCP inspections.

Changed10 schema fields changedOct 22, 2026

addedOutput schema / properties / beans / items / properties / age_verdict_code
```
Added value: +{
+  "type": "string"
+}
```
addedOutput schema / properties / beans / items / properties / bags / items / properties / age_verdict_code
```
Added value: +{
+  "type": "string"
+}
```
addedOutput schema / properties / beans / items / properties / bags / items / properties / lot_revision_id
```
Added value: +{
+  "type": [
+    "string",
+    "null"
+  ]
+}
```
addedOutput schema / properties / beans / items / properties / bags / items / properties / product_id
```
Added value: +{
+  "type": [
+    "string",
+    "null"
+  ]
+}
```

changedOutput schema / properties / beans / items / properties / bags / items / required

Previous value: -[
-  "id",
-  "bean_id",
-  "roast_date",
-  "buy_date",
-  "opened_date",
-  "best_by_date",
-  "bag_weight_g",
-  "weight_adjustment_g",
-  "cost",
-  "currency",
-  "state",
-  "finished",
-  "frozen_at",
-  "unfrozen_at",
-  "frozen_storage",
-  "frozen_note",
-  "storage",
-  "ean",
-  "qr_code",
-  "bag_notes",
-  "archived",
-  "effective_age_days",
-  "age_verdict",
-  "grams_remaining",
-  "days_since_opened",
-  "days_off_roast",
-  "frozen_days_excluded"
-]New value: +[
+  "id",
+  "bean_id",
+  "roast_date",
+  "buy_date",
+  "opened_date",
+  "best_by_date",
+  "bag_weight_g",
+  "weight_adjustment_g",
+  "cost",
+  "currency",
+  "state",
+  "finished",
+  "frozen_at",
+  "unfrozen_at",
+  "frozen_storage",
+  "frozen_note",
+  "storage",
+  "ean",
+  "qr_code",
+  "bag_notes",
+  "archived",
+  "product_id",
+  "lot_revision_id",
+  "effective_age_days",
+  "age_verdict",
+  "age_verdict_code",
+  "grams_remaining",
+  "days_since_opened",
+  "days_off_roast",
+  "frozen_days_excluded"
+]

addedOutput schema / properties / beans / items / properties / catalog_coffee_id
```
Added value: +{
+  "type": [
+    "string",
+    "null"
+  ]
+}
```
addedOutput schema / properties / beans / items / properties / origins / items / properties / country_code
```
Added value: +{
+  "type": [
+    "string",
+    "null"
+  ]
+}
```

changedOutput schema / properties / beans / items / properties / origins / items / required

Previous value: -[
-  "country",
-  "region",
-  "farm",
-  "farmer",
-  "variety",
-  "processing",
-  "elevation_m",
-  "elevation_max_m",
-  "harvest",
-  "percentage"
-]New value: +[
+  "country",
+  "country_code",
+  "region",
+  "farm",
+  "farmer",
+  "variety",
+  "processing",
+  "elevation_m",
+  "elevation_max_m",
+  "harvest",
+  "percentage"
+]

changedOutput schema / properties / beans / items / properties / roaster / type
```
Previous value: -"string"New value: +[
+  "string",
+  "null"
+]
```

changedOutput schema / properties / beans / items / required

Previous value: -[
-  "id",
-  "name",
-  "roaster",
-  "roast_level",
-  "archived",
-  "favourite",
-  "decaffeinated",
-  "process_type",
-  "dial_category",
-  "rest_window_days_min",
-  "rest_window_days_max",
-  "rating",
-  "aromatics",
-  "cupping_points",
-  "roasting_type",
-  "variety",
-  "origin",
-  "url",
-  "notes",
-  "arabica_pct",
-  "body",
-  "acidity",
-  "sweetness",
-  "roast_date",
-  "buy_date",
-  "opened_date",
-  "best_by_date",
-  "bag_weight_g",
-  "weight_adjustment_g",
-  "cost",
-  "currency",
-  "state",
-  "finished",
-  "frozen_at",
-  "unfrozen_at",
-  "frozen_storage",
-  "frozen_note",
-  "storage",
-  "ean",
-  "qr_code",
-  "bag_notes",
-  "effective_age_days",
-  "age_verdict",
-  "grams_remaining",
-  "days_since_opened",
-  "days_off_roast",
-  "frozen_days_excluded",
-  "current_bag_id",
-  "bags",
-  "origins"
-]New value: +[
+  "id",
+  "name",
+  "roaster",
+  "catalog_coffee_id",
+  "roast_level",
+  "archived",
+  "favourite",
+  "decaffeinated",
+  "process_type",
+  "dial_category",
+  "rest_window_days_min",
+  "rest_window_days_max",
+  "rating",
+  "aromatics",
+  "cupping_points",
+  "roasting_type",
+  "variety",
+  "origin",
+  "url",
+  "notes",
+  "arabica_pct",
+  "body",
+  "acidity",
+  "sweetness",
+  "roast_date",
+  "buy_date",
+  "opened_date",
+  "best_by_date",
+  "bag_weight_g",
+  "weight_adjustment_g",
+  "cost",
+  "currency",
+  "state",
+  "finished",
+  "frozen_at",
+  "unfrozen_at",
+  "frozen_storage",
+  "frozen_note",
+  "storage",
+  "ean",
+  "qr_code",
+  "bag_notes",
+  "effective_age_days",
+  "age_verdict",
+  "age_verdict_code",
+  "grams_remaining",
+  "days_since_opened",
+  "days_off_roast",
+  "frozen_days_excluded",
+  "current_bag_id",
+  "bags",
+  "origins"
+]

Changed41 schema fields changedSep 28, 2026
- removedOutput schema / properties / beans / items / properties / acidity / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / arabica_pct / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / aromatics / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / best_by_date / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / buy_date / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / days_since_opened / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / ean / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / frozen_at / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / frozen_note / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / frozen_storage / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / opened_date / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / qr_code / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / storage / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / bags / items / properties / unfrozen_at / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / best_by_date / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / body / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / buy_date / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / cost / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / cupping_points / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / currency / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / days_since_opened / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / ean / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / frozen_at / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / frozen_note / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / frozen_storage / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / opened_date / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origin / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origins / items / properties / elevation_m / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origins / items / properties / elevation_max_m / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origins / items / properties / farm / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origins / items / properties / farmer / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origins / items / properties / harvest / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / origins / items / properties / processing / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / qr_code / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / rating / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / roasting_type / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / storage / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / sweetness / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / unfrozen_at / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / url / type
```
Removed value: -"null"
```
- removedOutput schema / properties / beans / items / properties / variety / type
```
Removed value: -"null"
```

Changed25 schema fields changedSep 12, 2026

addedOutput schema / properties / beans / items / properties / acidity
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / arabica_pct
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / aromatics
```
Added value: +{
+  "type": "null"
+}
```

addedOutput schema / properties / beans / items / properties / bags

Added value: +{
+  "items": {
+    "additionalProperties": true,
+    "properties": {
+      "age_verdict": {
+        "type": "string"
+      },
+      "archived": {
+        "type": "integer"
+      },
+      "bag_notes": {
+        "type": [
+          "null",
+          "string"
+        ]
+      },
+      "bag_weight_g": {
+        "type": [
+          "integer",
+          "null"
+        ]
+      },
+      "bean_id": {
+        "type": "integer"
+      },
+      "best_by_date": {
+        "type": "null"
+      },
+      "buy_date": {
+        "type": "null"
+      },
+      "cost": {
+        "type": [
+          "null",
+          "integer"
+        ]
+      },
+      "currency": {
+        "type": [
+          "null",
+          "string"
+        ]
+      },
+      "days_off_roast": {
+        "type": "integer"
+      },
+      "days_since_opened": {
+        "type": "null"
+      },
+      "ean": {
+        "type": "null"
+      },
+      "effective_age_days": {
+        "type": "integer"
+      },
+      "finished": {
+        "type": "integer"
+      },
+      "frozen_at": {
+        "type": "null"
+      },
+      "frozen_days_excluded": {
+        "type": "integer"
+      },
+      "frozen_note": {
+        "type": "null"
+      },
+      "frozen_storage": {
+        "type": "null"
+      },
+      "grams_remaining": {
+        "type": [
+          "integer",
+          "null"
+        ]
+      },
+      "id": {
+        "type": "integer"
+      },
+      "opened_date": {
+        "type": "null"
+      },
+      "qr_code": {
+        "type": "null"
+      },
+      "roast_date": {
+        "type": "string"
+      },
+      "shots_remaining": {
+        "type": "integer"
+      },
+      "shots_remaining_basis": {
+        "type": "string"
+      },
+      "shots_remaining_dose_g": {
+        "type": [
+          "integer",
+          "number"
+        ]
+      },
+      "shots_remaining_sample": {
+        "type": [
+          "integer",
+          "null"
+        ]
+      },
+      "state": {
+        "type": "string"
+      },
+      "storage": {
+        "type": "null"
+      },
+      "unfrozen_at": {
+        "type": "null"
+      },
+      "weight_adjustment_g": {
+        "type": "integer"
+      }
+    },
+    "required": [
+      "id",
+      "bean_id",
+      "roast_date",
+      "buy_date",
+      "opened_date",
+      "best_by_date",
+      "bag_weight_g",
+      "weight_adjustment_g",
+      "cost",
+      "currency",
+      "state",
+      "finished",
+      "frozen_at",
+      "unfrozen_at",
+      "frozen_storage",
+      "frozen_note",
+      "storage",
+      "ean",
+      "qr_code",
+      "bag_notes",
+      "archived",
+      "effective_age_days",
+      "age_verdict",
+      "grams_remaining",
+      "days_since_opened",
+      "days_off_roast",
+      "frozen_days_excluded"
+    ],
+    "type": "object"
+  },
+  "type": "array"
+}

addedOutput schema / properties / beans / items / properties / best_by_date
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / body
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / buy_date
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / cupping_points
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / current_bag_id
```
Added value: +{
+  "type": [
+    "integer",
+    "null"
+  ]
+}
```
addedOutput schema / properties / beans / items / properties / ean
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / frozen_at
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / frozen_note
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / frozen_storage
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / notes
```
Added value: +{
+  "type": [
+    "null",
+    "string"
+  ]
+}
```
addedOutput schema / properties / beans / items / properties / origin
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / origins / items / properties / elevation_max_m
```
Added value: +{
+  "type": "null"
+}
```

changedOutput schema / properties / beans / items / properties / origins / items / required

Previous value: -[
-  "country",
-  "region",
-  "farm",
-  "farmer",
-  "variety",
-  "processing",
-  "elevation_m",
-  "harvest",
-  "percentage"
-]New value: +[
+  "country",
+  "region",
+  "farm",
+  "farmer",
+  "variety",
+  "processing",
+  "elevation_m",
+  "elevation_max_m",
+  "harvest",
+  "percentage"
+]

addedOutput schema / properties / beans / items / properties / qr_code
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / roasting_type
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / sweetness
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / unfrozen_at
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / url
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / variety
```
Added value: +{
+  "type": "null"
+}
```
addedOutput schema / properties / beans / items / properties / weight_adjustment_g
```
Added value: +{
+  "type": "integer"
+}
```

changedOutput schema / properties / beans / items / required

Previous value: -[
-  "id",
-  "name",
-  "roaster",
-  "roast_date",
-  "roast_level",
-  "state",
-  "opened_date",
-  "archived",
-  "finished",
-  "favourite",
-  "decaffeinated",
-  "bag_weight_g",
-  "process_type",
-  "dial_category",
-  "rest_window_days_min",
-  "rest_window_days_max",
-  "storage",
-  "bag_notes",
-  "cost",
-  "currency",
-  "rating",
-  "effective_age_days",
-  "age_verdict",
-  "grams_remaining",
-  "days_since_opened",
-  "days_off_roast",
-  "frozen_days_excluded",
-  "origins"
-]New value: +[
+  "id",
+  "name",
+  "roaster",
+  "roast_level",
+  "archived",
+  "favourite",
+  "decaffeinated",
+  "process_type",
+  "dial_category",
+  "rest_window_days_min",
+  "rest_window_days_max",
+  "rating",
+  "aromatics",
+  "cupping_points",
+  "roasting_type",
+  "variety",
+  "origin",
+  "url",
+  "notes",
+  "arabica_pct",
+  "body",
+  "acidity",
+  "sweetness",
+  "roast_date",
+  "buy_date",
+  "opened_date",
+  "best_by_date",
+  "bag_weight_g",
+  "weight_adjustment_g",
+  "cost",
+  "currency",
+  "state",
+  "finished",
+  "frozen_at",
+  "unfrozen_at",
+  "frozen_storage",
+  "frozen_note",
+  "storage",
+  "ean",
+  "qr_code",
+  "bag_notes",
+  "effective_age_days",
+  "age_verdict",
+  "grams_remaining",
+  "days_since_opened",
+  "days_off_roast",
+  "frozen_days_excluded",
+  "current_bag_id",
+  "bags",
+  "origins"
+]

First observedSep 6, 2026

TDQS

Score is being calculated.

All ShotPulled tools Inspect

Try in Browser

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources

Need Help?