malloy-patterns

Indexes Malloy documentation topics for lookup via the search_malloy_docs tool.

Updated Jun 3, 2026
One-click install
npx skills add https://github.com/credibledata/credible-plugin --skill malloy-patterns-credibledata
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: malloy-patterns
Source: https://github.com/credibledata/credible-plugin/tree/main/codex/skills/malloy-patterns
Command: npx skills add https://github.com/credibledata/credible-plugin --skill malloy-patterns-credibledata

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? When writing Malloy queries against a semantic model, you often need the exact syntax or pattern for a feature — joins, window functions, percent-of-total, chart rendering — but don't know what to search for. This Skill provides a curated index of Malloy documentation topics mapped to effective search terms for the search_malloy_docs tool. ## Core Features & Use Cases - Topic Index: Organized tables of Malloy language reference topics (sources, queries, views, aggregates, joins, filters, expressions) with recommended search strings. - Common Patterns: Ready-made search terms for analytical patterns like year-over-year comparison, cohort analysis, percent of total, moving averages, histograms, and sessionization. - Rendering & Dialects: Lookup terms for visualization options (bar charts, dashboards, pivots) and dialect-specific SQL functions for BigQuery, DuckDB, Postgres, Snowflake, and more. - Use Case: While composing a Malloy query, you need window function syntax — consult the index, then call search_malloy_docs with "calculations" or "window functions" to retrieve the official documentation. ## Quick Start Ask the assistant to look up how to compute a year-over-year comparison 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 syntax for a specific feature?

Call the search_malloy_docs tool with the topic name or search string listed in the index. For example, search "window functions" for calculations or "join_one" for join syntax, and the tool returns the relevant official documentation.

What Malloy patterns can I look up with search_malloy_docs?

The index covers common analytical patterns including year-over-year comparison, percent of total, cohort analysis, moving averages, histograms, nested subtotals, bucketing with 'other', and sessionization, each with recommended search terms.

Does Malloy support database-specific SQL functions?

Yes, dialect-specific SQL functions are available inside Malloy expressions for BigQuery, DuckDB, PostgreSQL, Snowflake, Presto/Trino, and MySQL. Malloy models themselves are dialect-portable since the connection supplies the dialect.

How do I render Malloy query results as charts?

Search the rendering documentation topics such as "bar charts", "line charts", "dashboards", "big_value", or "pivots" via search_malloy_docs. The docs describe renderer tags and formatting options like number and currency scaling.

Is there an autobin function for Malloy histograms?

No, Malloy has no autobin feature. Histograms are built by binning with arithmetic expressions; search "histogram" in search_malloy_docs for the documented approach.