# List Records

> List records from a NocoDB table with optional filtering Arguments: <table-name> [where-filter].

- Skill: `agents-store/list-records` (Agent Skill)
- Install (CLI): `npx get-skill add agents-store/list-records`
- Raw SKILL.md: https://api.skillmd.com/api/skills/agents-store/list-records/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: agents-store (https://skillmd.com/u/agents-store)
- Updated: 2026-11-16
- Page: https://skillmd.com/skills/agents-store/list-records

---


# List Records

Query records from a NocoDB table with optional filtering and sorting.

Listing, counting and paging rules are written down in `${CLAUDE_PLUGIN_ROOT}/skills/record-management/SKILL.md`; read it before the first step.

## Arguments

Parse from "$ARGUMENTS":
- `table-name` (required): Name or ID of the table
- `where-filter` (optional): Filter in NocoDB `where` syntax, e.g. `(Status,eq,Active)` (translate it to the structured `filter` when it has dates or special characters)

## Process

1. Run `getTablesList` to resolve the table name to an ID.
2. Run `getTableSchema` to discover field names and types.
3. Run `queryRecords` with the table ID and the optional filter. If the user names an order, pass `sort` as an **array of objects**: `[{ "field": "Created", "direction": "desc" }]` (not `"-Created"`). `pageSize` defaults to 50 and is capped at 200.
4. Date comparisons need a sub-operator -- `(Due,gte,exactDate,2026-06-01)`; ranges are two bounds, never `btw`.
5. Display results in a formatted table showing key fields.
6. Report total count (`countRecords` with the same filter) and pagination info if more records exist.

## Example Usage

```
/list-records Contacts
/list-records Orders (Status,eq,Pending)
/list-records Deals (Amount,gt,5000)~and(Stage,eq,Negotiation)
```
