What is the maximum number of rows I can retrieve with this skill?

The skill supports different limits based on the method: up to 20 rows for samples, 500 rows for filtered records, and 1,000 rows for custom SQL queries.

Can I run complex SQL aggregations like GROUP BY?

Yes, by using the --sql flag, you can execute custom queries that include GROUP BY, ORDER BY, and other standard SQL-like aggregations.

How do I identify records with missing values?

You can use the 'IS NULL' or 'IS NOT NULL' syntax within your filter expressions to target records with missing or present data in specific fields.

Does this skill require manual authentication setup?

If a connection is not active, Claude will automatically guide you to the Connectors UI to authenticate your Datarails account safely.

Datarails Data Query

Name: Datarails Data Query
Author: Datarails

byDatarails

0•

Database Management

Queries Datarails Finance OS tables using filters, samples, and custom SQL-like expressions to investigate financial data.

The Datarails Data Query skill empowers Claude to interact directly with Datarails Finance OS tables, enabling deep data exploration and investigative analysis within the development workflow. Users can perform everything from quick 20-row sampling to understand data structures to complex SQL-style aggregations and filtered record retrieval of up to 1,000 rows. With built-in support for pattern matching, logical operators, and NULL checks, it serves as a powerful bridge between raw financial data and actionable insights, allowing for rapid debugging of anomalies and detailed trend analysis directly through Claude Code.

Key Features

01High-capacity data retrieval with limits up to 1,000 rows for complex analysis

02Integrated schema verification to ensure accurate query construction

03Automated result formatting into readable tables with summary statistics

040 GitHub stars

05Flexible filter syntax supporting logical operators, ranges, IN lists, and pattern matching

06Multi-method querying including sampling, filtered retrieval, and custom SQL execution

Use Cases

01Sampling General Ledger data to understand table schemas and record formatting before development

02Performing SQL aggregations to calculate totals by department, account code, or vendor

03Investigating financial anomalies by filtering for specific transaction thresholds or date ranges

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add datarails/dr-claude-code-plugins-re query

For use in Claude.ai and ChatGPT

Key Features

01High-capacity data retrieval with limits up to 1,000 rows for complex analysis

02Integrated schema verification to ensure accurate query construction

03Automated result formatting into readable tables with summary statistics

040 GitHub stars

05Flexible filter syntax supporting logical operators, ranges, IN lists, and pattern matching

06Multi-method querying including sampling, filtered retrieval, and custom SQL execution

Use Cases

01Sampling General Ledger data to understand table schemas and record formatting before development

02Performing SQL aggregations to calculate totals by department, account code, or vendor

03Investigating financial anomalies by filtering for specific transaction thresholds or date ranges