Collections

Structured records — your tables.

11 tools — 4 read, 7 write.

Tool		What it does
add_items	write	Add items to a collection.
create_collection	write	Create a new collection (structured database).
delete_collection	write	Delete a collection and all its items.
delete_items	write	Delete items from a collection by item IDs or filters.
get_collection	read	Read one collection's shape — its fields, their types, and how many rows it holds — without reading the rows.
get_collection_items	read	Fetch one or more collection items by id.
list_collections	read	List the collections you can see in this org, with each one's field schema and row count.
modify_collection	write	Add or remove field definitions from a collection, reorder how columns appear, or rename the collection (name/description).
query_collection	read	Query items from a collection with optional filters, sorting, projection, and pagination.
update_items	write	Update items in a collection by item IDs or filters.
upsert_items	write	Upsert items into a collection by a natural key — use this for idempotent imports (e.g.

Calling these

Over MCP, find one with search_tools, then run it with execute_tool. Over REST, POST /api/capabilities/<tool> with the arguments as the JSON body. Either way, fetch the input schema for the tool you're about to call rather than guessing — get_tool_schema over MCP, or GET /api/capabilities?name=<tool> over REST.

See How the API works for auth, errors and the shared envelope.