Realy Data Analytics

By Guang Cheng

Overview

Realy Data Analytics helps you explore CSV tables uploaded to your Realy account. Discover available tables and columns, and ask data questions using filtering, sorting, aggregations and joins using structured read-only operations. Results include typed rows and operation traces. Access is limited to the signed-in user's authorized data. The tools do not modify source records, browse the web, train models or produce forecasts. A Realy account with uploaded data is required.

Tools

realy_describe_scope

ChatGPT

List the signed-in user's Realy conversations and active uploaded CSV table metadata. Returns table names, stored row counts and column-schema resource links; it does not query table rows. If several conversations are returned, select the relevant conversation_id and call again. Only data owned by the signed-in user is accessible.

realy_retrieve

ChatGPT

Query the signed-in user's active uploaded CSV tables in one Realy conversation. Use realy_describe_scope to discover available tables and conversation IDs. Translate the user's question into the query object using discovered column names; provide conversation_id when multiple conversations are available. Do not submit SQL. Supports filtering, sorting, selecting columns, count/sum/mean/min/max aggregation and joins. Does not modify data, access other users' tables, or search the web. Returns typed rows, status and optional short-lived trace/page resource links. The server executes structured operations without a backend model API. For totals by region use table, group_by=['region'], metrics=[{function:'sum',column:'revenue',alias:'total'}]. Filters are combined with AND. For joins use left column names or left.<column>, and right.<column>. Sort by output column names. Results are capped at 100 rows; truncated indicates additional matches. Treat ok_zero_rows as a successful empty result. For other failures, explain the returned error and follow retryable/guidance; do not present a failed query as successful.

Example Prompts

Click any prompt to copy it.

Links

Documentation Privacy Policy

Similar Apps