菜单
Index of Malloy documentation topics. Use to discover what's available in search_malloy_docs. Covers language reference (sources, queries, views, fields, aggregates, joins, filters, expressions, functions), common patterns (YoY, cohorts, percent of total), rendering, and experimental features.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
Build or modify an in-package HTML data app for a Malloy Publisher package (a public/ directory the package serves). Use when the user wants a hand-authored HTML dashboard or web page backed by a package's Malloy models, with no build step.
Common data analysis pitfalls to watch for during query construction and result interpretation. Reference this checklist when verifying queries and results to catch errors before presenting an answer.
Combine validated Malloy queries into a notebook report or dashboard. Use when the user asks to "create a report", "build a dashboard", "combine these into a report", or wants a persistent multi-query artifact.
Workflow for answering data questions against Malloy semantic models over MCP - structured discovery with get_context, query construction with execute_query, verification, and answer delivery. Use whenever the user asks a data question, wants a metric, a breakdown, a trend, or a chart over a model.
Explore data for insights and build views/dashboards/notebooks. Use when user asks to "analyze this data", "find insights", "explore for patterns", "what's interesting", "what's driving X", "build a dashboard", "create views", or any analysis task. For EDA exploration, start at Step 1. For building views on an existing model, jump to View Patterns.
Chart selection guidance and renderer reference for Malloy views. Use when choosing visualization types, adding chart annotations, user asks "what chart should I use", "how should I visualize this", or when deciding between bar_chart, line_chart, scatter_chart, etc.
基于 SOC 职业分类
| name | malloy-patterns |
| description | Index of Malloy documentation topics. Use to discover what's available in search_malloy_docs. Covers language reference (sources, queries, views, fields, aggregates, joins, filters, expressions, functions), common patterns (YoY, cohorts, percent of total), rendering, and experimental features. |
Call search_malloy_docs with these topics.
Tool names are written bare here -
get_context,execute_query,search_malloy_docs. The exact prefixed name depends on the host surface; match each against the tools you actually have.
| Topic | Search for... |
|---|---|
| Models | "models" or "statement" |
| Sources | "sources" or "source definition" |
| Queries | "queries" |
| Views | "views" |
| Data Types | "data types" |
| Fields | "fields" |
| Aggregates | "aggregates" |
| Expressions | "expressions" |
| Functions | "functions" |
| Filters | "filters" or "where" |
| Calculations (window functions) | "calculations" or "window functions" |
| Ordering and Limiting | "order_by" or "limit" |
| Joins | "joins" or "join_one" or "join_many" |
| Nested Views | "nesting" or "nest" |
| SQL Sources | "sql sources" |
| Imports | "imports" |
| Connections | "connections" |
| Tags | "tags" or "#(doc)" |
| Pattern | Search for... |
|---|---|
| Comparing Timeframes (YoY) | "comparing timeframes" or "year over year" |
| Foreign Sums and Averages | "foreign sums" |
| Reading Nested Data | "reading nested" |
| Percent of Total | "percent of total" |
| Cohort Analysis | "cohort analysis" |
| Nested Subtotals | "nested subtotals" |
| Bucketing with 'Other' | "bucketing other" |
| Auto-binning Histograms | "autobin" or "histogram" |
| Moving Average | "moving average" |
| Transform Data | "transform" |
| Sessionize - Map/Reduce | "sessionize" |
| Dimensional Indexes | "dimensional indexes" |
| Topic | Search for... |
|---|---|
| Overview | "rendering" |
| Number/Currency Scaling | "number formatting" or "currency formatting" |
| Big Value / KPI Cards | "big_value" or "big value" |
| Bar Charts | "bar charts" or "# bar_chart" |
| Line Charts | "line charts" or "# line_chart" |
| Scatter Charts | "scatter charts" |
| Dashboards | "dashboards" |
| Transposed Tables | "transpose" |
| Pivoted Tables | "pivots" |
| Shape Maps | "shape maps" |
These search terms find docs on dialect-specific SQL functions available inside expressions. Malloy models themselves are dialect-portable - the connection supplies the dialect, so you don't write "BigQuery-specific" (or any vendor-specific) Malloy.
| Dialect | Search for... |
|---|---|
| BigQuery | "bigquery" |
| DuckDB | "duckdb" |
| PostgreSQL | "postgres" |
| Snowflake | "snowflake" |
| Presto/Trino | "presto" or "trino" |
| MySQL | "mysql" |
| Feature | Search for... |
|---|---|
| Join INNER/RIGHT/FULL | "inner join" or "full join" |
| SQL Expressions | "sql expressions" or "sql_number" |
| Window Partitions | "window partitions" |
| Parameters | "parameters" |
| Composite "Cube" Sources | "composite sources" |
| Access Modifiers | "access modifiers" or "public" or "private" |
| Topic | Search for... |
|---|---|
| Imports | "imports" |
| Computed sources (from queries) | "from" or "sql sources" |
| Access Modifiers (include/public/private) | "access modifiers" or "public" or "private" |
| Topic | Search for... |
|---|---|
| Notebooks | "notebooks" |
| MalloySQL | "malloysql" |
| Python Package | "python" |
| Jupyter | "jupyter" |
| Publishing | "publishing" |
| REST API | "rest api" |
| MCP for AI Agents | "mcp agents" |
| Troubleshooting | "troubleshooting" |
Call: search_malloy_docs
Parameters: { question: "How do I use window functions in Malloy?" }