Mock DB API Console — JSONBin (Basic + Advanced)

Enter a PUBLIC BIN_ID for your seeded doc, then run commands. This console uses GET/PUT with an optimistic rev check and auto-fills IDs to avoid broken examples.

Boot

On boot, we ensure a demo todo and a demo tag exist and auto-fill the cards below.

Basic CRUD

getDoc (no input)

findMany { "col": "todos", "where": { "field": "assignedTo", "op": "eq", "value": "u-alice" } }

findOne { "col": "users", "where": { "field": "name", "op": "eq", "value": "Alice" } }

insertOne { "col": "todos", "data": { "title": "From console", "done": false, "assignedTo": "u-bob", "projectId":"p-1", "tagIds":[], "subtasks":[], "commentIds":[] } }

updateOne // id will be filled with a valid demo todo

deleteOne // id will be filled with a valid demo tag; re-Boot to recreate it

Advanced CRUD

findManyBy { "col": "todos", "filter": { "assignedTo": "u-alice", "done": false } }

findOneBy // name will be filled with the demo tag's name

find { "col":"todos", "args":{"filter":{"done":false},"sort":{"title":1},"limit":3,"fields":{"id":1,"title":1}} }

updateOneOps // id will be filled with the demo todo id

upsertOne { "col":"tags","filter":{"name":"priority"},"data":{"name":"priority"} }

transact // JS body to run inside transact(doc => { ... })

API Console — JSONBin Adapter

Boot

Basic CRUD

Advanced CRUD