# dr-query

> Claude/Codex skill by [@datarails](https://omgskills.com/library/datarails/index.md) · 3 stars · Updated 2026-09-22

Query Datarails Finance OS tables with filters. Fetch specific records or page through rows for investigation. The filter API supports value-list AND advanced operators — comparisons, ranges, text matching, null checks, and date ranges all work.

## Install

```sh
git clone https://github.com/Datarails/dr-claude-code-plugins-re /tmp/dr-claude-code-plugins-re && ln -s /tmp/dr-claude-code-plugins-re/skills/query ~/.claude/skills/dr-query
```

## From README

Datarails Data Query Query Finance OS tables — fetch records by filter, sample rows, or page through data. The filter API supports both value-list and advanced (comparison / range / text / null / date-range) operators, so most questions can be answered with a single getdataby call. Workflow Step 1: Verify Authentication If any tool call fails with an authentication or connection error, guide the user to connect via the Connectors UI ("+" → Connectors → Datarails → Connect). Step 2: Resolve the table and its fields listdatamodels to find the table by name or alias. Prefer the alias path when the table has an alias: listaliasedfields( ) gives friendly field names and you query with getdatabyalias. Otherwise getfieldsbyid( ) gives numeric field ids and you query with getdatabyid (select and filters are field-id based). Always select only the columns you need — raw tables can be hundreds of columns wide in some orgs. Alias coverage is per field, not per table.

## Links

- HTML page: https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/query/
- GitHub: https://github.com/Datarails/dr-claude-code-plugins-re
- Author: [@datarails](https://omgskills.com/library/datarails/index.md)

## More from this repo

- [datarails-excel-agent](https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/datarails-excel-agent/index.md) — Datarails operations on the OPEN Excel workbook.
   - [@datarails](https://omgskills.com/library/datarails/index.md) · 3 stars
- [dr-anomalies](https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/anomalies/index.md) — Detect data anomalies in one Datarails Finance OS table and answer IN CHAT — severity-ranked outliers, duplicates,...
   - [@Datarails](https://omgskills.com/library/datarails/index.md) · 3 stars
- [dr-anomalies-report](https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/anomalies-report/index.md) — Detect data anomalies and generate a comprehensive data-quality Excel WORKBOOK from Finance OS tables, computed over...
   - [@Datarails](https://omgskills.com/library/datarails/index.md) · 3 stars