# Tables

> Skill `tables` on Faro. Free. 6 sub-skills.

Stores, queries, and manages records in named collections without needing a database. Insert records, filter by field values, search by meaning, update or delete by id, and count matches. Collections are scoped to your session and require no setup or schema definition.

**Category:** Developer Tools  
**Tags:** tables, records, query, memory, search, embeddings, database  
**Use when:** You need a small structured store you can query by field or search by meaning.  
**Not for:** A single value by key (use the key-value store), or a file (use the file share).  
**Returns:** information

## How to run
Skills run through one gateway with your Faro token. Hand it an `intent` in plain language; Faro routes to the right sub-skill, runs it, and bills per call. Raw tools are internal plumbing and are not directly callable.

```
POST https://skill.askfaro.com/skills/tables/run
Authorization: Bearer faro_<your_key>
Content-Type: application/json

{"intent":{"prompt":"Add this item to my products collection"}}
```

Or from the CLI:

```bash
pip install askfaro-cli && askfaro auth login
askfaro run tables "Add this item to my products collection"
```

Full run reference: https://askfaro.com/llms/run.md — Agent recipe: https://askfaro.com/llms/skill.md

## Example requests

- Add this item to my products collection
- Find all records in the products collection where category is electronics
- Find notes about project planning in my notes collection
- Update the status field of task id abc123 to completed

## Sub-skills

### Insert a record

Inserts a record into a collection.

**Cost:** Free

**Details:** https://askfaro.com/llms/skills/tables/insert.md

---

### Query records

Returns records matching a filter, with sort, limit, and offset.

**Cost:** Free

**Details:** https://askfaro.com/llms/skills/tables/query.md

---

### Search records

Returns records ranked by semantic similarity to a query.

**Cost:** Free

**Details:** https://askfaro.com/llms/skills/tables/search.md

---

### Update a record

Patches or replaces a record by id.

**Cost:** Free

**Details:** https://askfaro.com/llms/skills/tables/update.md

---

### Delete a record

Deletes a record by id.

**Cost:** Free

**Details:** https://askfaro.com/llms/skills/tables/delete.md

---

### Count records

Counts records matching a filter.

**Cost:** Free

**Details:** https://askfaro.com/llms/skills/tables/count.md

---

---
On the web: https://askfaro.com/search/tables