---
title: "SQL Rainmaker Assistant"
slug: "sql-rainmaker-assistant"
updated: 2025-03-12T16:07:01Z
published: 2025-03-12T16:07:01Z
canonical: "docs.interprose.com/sql-rainmaker-assistant"
---

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

# SQL Rainmaker Assistant

The SQL Rainmaker Assistant in SQL Designer helps you create, optimize, and troubleshoot SQL queries by providing suggestions, feedback, and performance improvements.

## How to Use the SQL Rainmaker Assistant

#### Accessing SQL Designer

1. Navigate to **Reports → SQL Designer**.
2. Click New to start creating a report.
3. Complete required fields:
4. Label: Descriptive report name.
5. Identifier: Typically the same as the label.
  1. When first tabbing to the Identifier field from the Label field, after a SQL Report is created, the Identifier field is automatically populated with the contents of the Label field.

#### Evaluating New or Existing Queries

1. Click **Ask** and do one of the following:
  1. request that the SQL Rainmaker Assistant create a new query based on specific criteria.
  2. request the SQL Rainmaker Assistant evaluate an existing query or request the assistant improve a query based on specific criteria.
2. Review any explanations and suggested SQL provided by the SQL Rainmaker Assistant.
3. Click **Replace SQL** to apply the query directly into the SQL Window.
4. Click **Test** to preview results:
  1. If the results are as expected, save your report.
  2. If not:
    1. If you received an error message, paste the error in the **Ask** section and request feedback.
    2. Continue to use the assistant to refine your query or manually adjust your query until it meets your needs.
    3. Consider using the **Optimize** option to further improve your query.

(See screenshots below for examples.)

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Screenshot 2025-03-12 115400.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A03Z&se=2026-10-31T19%3A40%3A03Z&sr=c&sp=r&sig=%2FShUnj7%2BZug3RqjrVEGMgVa1WFNwsNQci%2BwGM5d3Cc8%3D)

Image Displays Sample Query Request and Ask Button

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Screenshot 2025-03-11 173906.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A03Z&se=2026-10-31T19%3A40%3A03Z&sr=c&sp=r&sig=%2FShUnj7%2BZug3RqjrVEGMgVa1WFNwsNQci%2BwGM5d3Cc8%3D)

Image Displays Reviewing Rainmaker Assistant's Response

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Screenshot 2025-03-12 115640.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A03Z&se=2026-10-31T19%3A40%3A03Z&sr=c&sp=r&sig=%2FShUnj7%2BZug3RqjrVEGMgVa1WFNwsNQci%2BwGM5d3Cc8%3D)

Image Displays Clarifying Prompts in the Ask Section

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Screenshot 2025-03-12 115926.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A03Z&se=2026-10-31T19%3A40%3A03Z&sr=c&sp=r&sig=%2FShUnj7%2BZug3RqjrVEGMgVa1WFNwsNQci%2BwGM5d3Cc8%3D)

Image Displays Using the Optimize Button for a Query

## Rainmaker Assistant Buttons and Functions

- **Replace SQL:** Applies the SQL Rainmaker Assistant’s suggested query.
- **Copy to Clipboard:** Copies the query for external use or manual edits.
- **Ask:** Submit questions or request clarification and alternative solutions.
- **Optimize:** Refine queries.
- **Test:** Preview query results with sample data.
- **Run:** Execute the final query to generate your report.

## Testing and Validating SQL Queries

- When testing always use a LIMIT in the WHERE Clause. For example, best practice is to limit returned rows to 10 while testing.
- Click Test to preview and verify the data.
- Remove the limit, produce the report and validate all data.
- Validate results thoroughly to ensure accuracy.

## Best Practices

- Start with simple queries and test after each change.
- Review all SQL Rainmaker Assistant recommendations before applying.
- Familiarize yourself with PostgreSQL.
- Consider reporting misidentified fields to Support.
- Validate all suggestions and changes to ensure accuracy.