malloy-patterns

Indexes Malloy documentation topics for lookup via the search_malloy_docs tool.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? When writing Malloy queries, models, or visualizations, you often don't know which documentation topic covers the feature you need. This Skill provides a curated index of Malloy documentation topics mapped to effective search terms, so you can quickly find the right reference material through the search_malloy_docs tool instead of guessing. ## Core Features & Use Cases - Language Reference Index: Maps core Malloy concepts (sources, queries, views, fields, aggregates, joins, filters, expressions, functions) to precise search queries. - Common Patterns Library: Covers analytical patterns like year-over-year comparison, cohort analysis, percent of total, moving averages, histograms, and sessionization. - Rendering & Dialect Coverage: Indexes visualization topics (bar charts, dashboards, big value cards) and dialect-specific SQL functions for BigQuery, DuckDB, PostgreSQL, Snowflake, Presto/Trino, and MySQL. - Use Case: You need to write a year-over-year comparison in Malloy but don't know the syntax. Consult the index, find the "comparing timeframes" topic, and call search_malloy_docs with that term to retrieve the relevant documentation. ## Quick Start Ask the assistant to look up how to compute a percent of total in Malloy using the search_malloy_docs tool.

Frequently Asked Questions about malloy-patterns

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

FAQPage Schema
How do I find Malloy documentation for a specific feature?▼

Use the search_malloy_docs tool with the topic terms listed in this index. For example, search "window functions" for calculations, "joins" for relationship syntax, or "percent of total" for that analytical pattern.

How do I write a year-over-year comparison in Malloy?▼

Search the Malloy docs for "comparing timeframes" or "year over year" using search_malloy_docs. The documentation covers the standard YoY pattern using filtered aggregates over time-based groupings.

Does Malloy support dialect-specific SQL functions?▼

Yes, Malloy expressions can use dialect-specific SQL functions for BigQuery, DuckDB, PostgreSQL, Snowflake, Presto/Trino, and MySQL. Malloy models themselves remain dialect-portable because the connection supplies the dialect.

What rendering options does Malloy support for query results?▼

Malloy supports bar charts, line charts, scatter charts, dashboards, big value KPI cards, transposed and pivoted tables, and shape maps. Search the docs for "rendering" or a specific chart type to see the tag syntax.

Are there experimental Malloy features I should know about?▼

Yes, experimental features include INNER/RIGHT/FULL joins, SQL expressions, window partitions, parameters, composite sources, and access modifiers. Search for these terms in the docs, noting they may change before stabilization.