Download for MacApple silicon, macOS 14+
Skill

dr-query

@datarails 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

With your agent

Install OMGSkills skill "datarails/dr-claude-code-plugins-re:skills/query" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.

Manual command

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.