dr-query
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.
More from this repo
datarails-excel-agent
Datarails operations on the OPEN Excel workbook.
dr-anomalies
Detect data anomalies in one Datarails Finance OS table and answer IN CHAT — severity-ranked outliers, duplicates,...
dr-anomalies-report
Detect data anomalies and generate a comprehensive data-quality Excel WORKBOOK from Finance OS tables, computed over...

