dr-query

Query Datarails Finance OS tables with filters and SQL-like custom queries.

3|3|Updated Feb 1, 2026
One-click install
npx skills add https://github.com/Datarails/dr-claude-code-plugins-re --skill dr-query
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dr-query
Source: https://github.com/Datarails/dr-claude-code-plugins-re/tree/main/skills/query
Command: npx skills add https://github.com/Datarails/dr-claude-code-plugins-re --skill dr-query

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill allows users to query Datarails Finance OS tables, enabling them to fetch specific records, retrieve samples, or execute custom queries for in-depth data investigation.

Core Features & Use Cases

  • Table Querying: Retrieve data from specified tables within Datarails Finance OS.
  • Filtering: Apply various filter expressions to narrow down results based on field values, comparisons, and logical operators.
  • Sampling: Obtain a random sample of records for quick data inspection.
  • Custom Queries: Execute SQL-like queries for complex data retrieval and aggregations.
  • Use Case: Investigate all transactions in the 'GL Transactions' table where the amount is greater than $100,000 and the department is 'Sales'.

Quick Start

Use the dr-query skill to get a sample of records from the 'GL Transactions' table.

Frequently Asked Questions about dr-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Datarails Finance OS tables to fetch specific financial records?

To query Datarails Finance OS tables, you can fetch specific records by applying flexible filtering expressions based on field values, comparisons, and logical operators to narrow down your financial data results.

Can I run custom SQL queries for financial data analysis in Datarails?

Yes, you can execute custom SQL-like queries in Datarails for complex financial data retrieval and aggregations, enabling in-depth investigation across tables such as GL Transactions.

How do I filter financial data tables to find high-value transactions?

You filter financial data tables by applying comparison and logical operators to specified fields, allowing you to retrieve records like transactions where the amount exceeds $100,000 in a specific department.

What is the best way to inspect a Datarails table without querying the entire dataset?

The best way to quickly inspect a Datarails table is to retrieve a random sample of records, which provides a subset of data for fast inspection without loading the entire dataset.

Do I need a specific database setup to retrieve the schema for Datarails tables?

No specific external database setup is required; the Skill utilizes built-in tools for schema retrieval, allowing you to understand table structures and fields directly within the Datarails Finance OS.

Are there limitations to the SQL-like query execution for Datarails financial data?

The custom query execution supports SQL-like syntax for complex data retrieval and aggregations, but it operates within the Datarails Finance OS environment and relies on the available schema and table structures.