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

# Generate SQL

> Turn a plain-language audience idea into a draft SQL query you can review and refine.

## Best Use Cases

Generate SQL is useful when a marketer knows the cohort they want but does not want to start from a blank query editor.

## Good Prompt Inputs

The strongest prompts usually include:

* The protocol, brand, or collection name
* The chain or contract focus when relevant
* The business goal, such as win-back, VIP targeting, or lifecycle follow-up
* The audience behavior you want to isolate

## Example Prompts

* Find recent minters on Base who have not clicked a campaign in the last 30 days.
* Show high-value wallets with declining activity that should enter a churn win-back flow.
* Build a report of users who clicked a governance reminder but did not vote.

## Review Checklist

* Does the query match the intended lifecycle question?
* Are joins likely to duplicate rows?
* Is the output shaped for a report or a segment?
* Is the date window explicit enough to review confidently?

## Recommendation

Treat generated SQL as a first draft. Review it, test it on a limited window, then save the final version for your team.