Tables

Active

Your agent has no database to put records in; this gives it the capability to store, filter, and semantically search records.

6 tools

Spin up a collection and store/query JSON records without a database: insert rows, filter them with simple structured queries, sort, count, update, and delete. Add an embedding to a record to enable semantic search, so it doubles as lightweight agent memory.

Developer Toolstablesrecordsquerymemorysearchembeddingsdatabase

Tools (6)

▶search

Semantic search a collection by meaning (needs records inserted with an embedding). Returns scored matches.

Free

Example prompts

“What did we decide about pricing?”
“Recall notes related to the onboarding flow”

Parameters

limitintegeroptionaldefault: 10

whereobjectoptional

Optional structured pre-filter (same grammar as query).

min_scorenumberoptionaldefault: 0.2

collectionstringrequired

query_textstringrequired

Natural-language query to match by meaning.

API Usage

curl -X POST "https://skill.askfaro.com/skills/tables/run" \
  -H "Authorization: Bearer faro_<your_key>" \
  -H "Content-Type: application/json" \
  -d '{
  "intent": {
    "prompt": "What did we decide about pricing?"
  }
}'

CLI Usage

askfaro describe tables/tables.search

Install pip install askfaro-cli, then askfaro auth login.

▶update

Update a record by id: merge a patch into its data, or replace it entirely.

Free

Example prompts

“Mark that task as done”

Parameters

idstringrequired

patchobjectrequired

Fields to merge (or the full record when replace=true).

replacebooleanoptionaldefault: false

collectionstringrequired

API Usage

curl -X POST "https://skill.askfaro.com/skills/tables/run" \
  -H "Authorization: Bearer faro_<your_key>" \
  -H "Content-Type: application/json" \
  -d '{
  "intent": {
    "prompt": "Mark that task as done"
  }
}'

CLI Usage

askfaro describe tables/tables.update

Install pip install askfaro-cli, then askfaro auth login.

▶count

Count records in a collection, optionally matching a filter.

Free

Example prompts

“How many open tasks do I have?”

Parameters

whereobjectoptional

collectionstringrequired

API Usage

curl -X POST "https://skill.askfaro.com/skills/tables/run" \
  -H "Authorization: Bearer faro_<your_key>" \
  -H "Content-Type: application/json" \
  -d '{
  "intent": {
    "prompt": "How many open tasks do I have?"
  }
}'

CLI Usage

askfaro describe tables/tables.count

Install pip install askfaro-cli, then askfaro auth login.

▶query

Query records in a collection with a structured filter, sort, limit, and offset.

Free

Example prompts

“List my todo tasks sorted by due date”
“Find records where status is done”

Parameters

sortobjectoptional

{field, dir} where dir is asc or desc.

limitintegeroptionaldefault: 50

whereobjectoptional

Structured filter: {field: value} or {field: {op: gt|lt|gte|lte|in|contains, value}}.

offsetintegeroptionaldefault: 0

collectionstringrequired

API Usage

curl -X POST "https://skill.askfaro.com/skills/tables/run" \
  -H "Authorization: Bearer faro_<your_key>" \
  -H "Content-Type: application/json" \
  -d '{
  "intent": {
    "prompt": "List my todo tasks sorted by due date"
  }
}'

CLI Usage

askfaro describe tables/tables.query

Install pip install askfaro-cli, then askfaro auth login.

▶insert

Insert a JSON record into a collection (created on first insert). Optionally embed text for semantic search.

Free

Example prompts

“Add a task: title 'Email the client', status 'todo'”
“Save this note to my memory collection so I can recall it later”

Parameters

recordobjectrequired

The JSON record (max 64 KB).

ttl_hoursintegeroptional

Optional expiry.

collectionstringrequired

Collection (table) name.

embed_textstringoptional

Text to embed for semantic search (max 8 KB).

embed_fieldstringoptional

Name of a record field to embed instead of embed_text.

API Usage

curl -X POST "https://skill.askfaro.com/skills/tables/run" \
  -H "Authorization: Bearer faro_<your_key>" \
  -H "Content-Type: application/json" \
  -d '{
  "intent": {
    "prompt": "Add a task: title 'Email the client', status 'todo'"
  }
}'

CLI Usage

askfaro describe tables/tables.insert

Install pip install askfaro-cli, then askfaro auth login.

▶delete

Delete a record by id. Free.

Free

Example prompts

“Delete that record”

Parameters

idstringrequired

collectionstringrequired

API Usage

curl -X POST "https://skill.askfaro.com/skills/tables/run" \
  -H "Authorization: Bearer faro_<your_key>" \
  -H "Content-Type: application/json" \
  -d '{
  "intent": {
    "prompt": "Delete that record"
  }
}'

CLI Usage

askfaro describe tables/tables.delete

Install pip install askfaro-cli, then askfaro auth login.