query_builder

Generates structured Rierino query JSON objects from natural language data requests.

1|Updated Mar 27, 2026
One-click install
npx skills add https://github.com/rierino-open/rierino-claude-plugin --skill query-builder-rierino-open
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query_builder
Source: https://github.com/rierino-open/rierino-claude-plugin/tree/main/development/skills/query_builder
Command: npx skills add https://github.com/rierino-open/rierino-claude-plugin --skill query-builder-rierino-open

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Writing valid query definitions for the Rierino low-code platform requires knowing its exact JSON schema, query types, and condition operators. This Skill translates plain-language data requests into complete, schema-compliant query objects, removing manual JSON authoring errors. ## Core Features & Use Cases - Query Type Inference: Automatically selects SIMPLE, AGGREGATION, BUNDLE, or PIPELINE types based on the request, across MongoDB, SQL, Elasticsearch, and other database systems. - Structured Filter Trees: Builds recursive where conditions with logical combinators (AND/OR/NOT), comparison operators, set membership, and unary checks. - Aggregations and Pipelines: Produces grouped metrics (COUNT, SUM, AVG, MAX, MIN) and multi-stage pipeline steps for complex transformations. - Use Case: Ask to "get average and total revenue per country from sales where year is 2024" and receive a ready-to-save AGGREGATION query JSON, which can then be persisted to the Rierino platform via the MCP server after your approval. ## Quick Start Ask the assistant to build a Rierino query that finds all shipped orders with totals above 100 sorted by date descending.

Frequently Asked Questions about query_builder

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

FAQPage Schema
How do I create a Rierino query from a natural language request?▼

Describe the data you want in plain language, such as "find all orders where status is shipped and total is greater than 100". The Skill infers the query type and returns a single complete JSON object matching the Rierino query schema.

What query types does the Rierino query builder support?▼

It supports SIMPLE for basic find and filter queries, AGGREGATION for grouped metrics like COUNT, SUM, and AVG, BUNDLE for combining a SIMPLE query with bundled aggregations, and PIPELINE for multi-stage transformations.

Does the query builder work with SQL and Elasticsearch or only MongoDB?▼

It supports multiple database systems including MongoDB, SQL, and Elasticsearch. Custom expressions in conditions, fields, and pipeline steps use the target database syntax provided in context, defaulting to MongoDB when unspecified.

Can the query builder save queries directly to the Rierino platform?▼

Yes, it can create, update, or delete queries through the Rierino MCP server tools, but only after you approve the generated query. It provides a browser URL to view the saved query in the Rierino UI.

When should I use a PIPELINE query instead of SIMPLE or AGGREGATION?▼

Use PIPELINE only for complex multi-stage transformations that cannot be expressed with SIMPLE or AGGREGATION types. PIPELINE queries contain only name, description, type, from, limit, skip, and steps, with no where, fields, or orderBy clauses.