malloy-analyze

Explores data with Malloy queries and builds views, dashboards, and notebooks.

9|Updated Feb 16, 2026
One-click install
npx skills add https://github.com/mathisdrn/orca --skill malloy-analyze-mathisdrn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: malloy-analyze
Source: https://github.com/mathisdrn/orca/tree/main/.agents/skills/malloy-analyze
Command: npx skills add https://github.com/mathisdrn/orca --skill malloy-analyze-mathisdrn

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Turning raw data into validated insights and shareable dashboards requires a structured workflow; this Skill guides exploratory data analysis and view building in Malloy so findings are grounded in real queries rather than guesswork. ## Core Features & Use Cases - Guided EDA workflow: A six-step process (Orient, Profile, Hypothesize, Investigate, Validate, Synthesize) that iteratively queries data, tests hypotheses, and triangulates findings before presenting them. - View and dashboard building: Creates annotated Malloy views (big_value KPIs, line charts, bar charts, nested dashboards) and .malloynb notebooks that combine markdown narrative with executable query cells. - Use Case: Ask the agent to explore a HackerNews dataset for engagement patterns; it profiles the tables, investigates trends and segment differences, validates each finding, and delivers a dashboard view summarizing the top insights. ## Quick Start Ask the agent to analyze the connected Malloy data source and find the most interesting patterns, then summarize them in a dashboard view.

Frequently Asked Questions about malloy-analyze

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

FAQPage Schema
How do I explore data and find insights with Malloy?▼

Start by calling get_context to learn the available sources and fields, then profile columns with aggregate queries, form hypotheses, and investigate them with group_by and nested views. Validate each finding against a second metric before synthesizing results into a dashboard view.

How do I build a dashboard in Malloy?▼

Create a view annotated with # dashboard that nests KPI cards (# big_value), a time trend (# line_chart), and a category breakdown (# bar_chart). Reference existing measures from the base source rather than redefining them inline.

What chart annotations does Malloy support for views?▼

Malloy supports # big_value for KPIs, # line_chart for time trends, # bar_chart for category breakdowns, # dashboard for nested multi-visualization layouts, and # transpose for grouped summaries. Chart views render only the first aggregate, so use one aggregate per chart.

Can I add interactive filters to a Malloy notebook?▼

Notebooks inherit filters declared on the model source via #(filter) annotations; the publisher renders the widgets and injects where clauses server-side. The notebook-level ##(filters) syntax is unsupported legacy and should not be used.

Why are compile errors not showing in my .malloynb notebook?▼

Compile errors in .malloynb files are not surfaced by the linter; they only appear when a cell is executed. Run each malloy cell individually to catch syntax or reference errors during authoring.