> ## Documentation Index
> Fetch the complete documentation index at: https://docs.textql.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Prompt Cookbook

## Getting oriented

```text Prompt theme={null}
What data do I have access to here, and what are 5 good questions I could ask it?
```

```text Prompt theme={null}
Describe the [orders] table in business terms: what's a row, what are the key fields, how fresh is it?
```

## Everyday questions

```text Prompt theme={null}
What was [metric] [last week / last month / this quarter]? Compare to the previous period and tell me if the change is meaningful or noise.
```

```text Prompt theme={null}
Top 10 [customers / products / pages] by [metric] this [period], with each one's share of the total.
```

```text Prompt theme={null}
[Metric] by [day/week/month] for the last [N] [periods], as a chart, with a trend line.
```

## Verifying and trust

```text Prompt theme={null}
Explain exactly how you calculated that: source table, filters, time window, definition. What assumptions did you make?
```

```text Prompt theme={null}
Give me a methodology footnote for that answer: source, window, filters, governed vs ad hoc, data freshness.
```

```text Prompt theme={null}
I expected [value] based on [reference report]. Why might your number differ?
```

## Segmentation and drivers

```text Prompt theme={null}
Segment [metric] by [dimension]. Which segments drive the total, which are growing or shrinking fastest?
```

```text Prompt theme={null}
[Metric] moved from [A] to [B] between [period 1] and [period 2]. Decompose the change by [dimension] and rank the contributors.
```

```text Prompt theme={null}
Compare [segment A] vs [segment B] on [metrics]. Where are they most different, and is the difference statistically meaningful?
```

## Trends, anomalies, forecasts

```text Prompt theme={null}
Plot [metric] weekly for the past year. Flag anomalies and tell me if the trend is changing after seasonality.
```

```text Prompt theme={null}
Did anything unusual happen in our data [yesterday / last week]? Check the main metrics and flag outliers.
```

```text Prompt theme={null}
Project [metric] through [horizon] with uncertainty bands. State the assumptions and what would break them.
```

## Charts and formatting

```text Prompt theme={null}
Make that a [bar / line / stacked area / scatter] chart. Show top [N] only, group the rest as "Other," sort descending.
```

```text Prompt theme={null}
Add a target line at [value] and annotate the months we missed it.
```

## Reports, dashboards, exports

```text Prompt theme={null}
Turn this thread into an executive report: summary up top, charts with takeaways, methodology appendix. PDF please.
```

```text Prompt theme={null}
Build a dashboard with [chart 1], [chart 2], and [table], with filters for [date range] and [dimension].
```

```text Prompt theme={null}
Export that table as CSV.
```

## Automation

```text Prompt theme={null}
Create a playbook "[name]" that runs [every Monday 9am]: [contents]. Email it to [me / list] and post to [#channel].
```

```text Prompt theme={null}
Create a feed agent that watches [domain] daily and posts only when something genuinely changes. Build on prior findings.
```

```text Prompt theme={null}
Remind me [when] to [do thing].
```

## Teaching the platform

```text Prompt theme={null}
Our official definition of [metric] is [definition]. Save it to the ontology (propose the patch).
```

```text Prompt theme={null}
Vocabulary: "[term]" means [meaning]. Save to the ontology.
```

```text Prompt theme={null}
Remember my preferences: [concise answers / timezone / default windows / what "my accounts" means].
```

## When something looks wrong

```text Prompt theme={null}
That number looks off. Walk me through the calculation step by step, and list everything that was excluded.
```

```text Prompt theme={null}
Recalculate using [other definition] and show both side by side.
```

```text Prompt theme={null}
What data would we need to answer this properly?
```