| title | Classify Business-Critical Data with Collate AI SQL Agent |
|---|---|
| slug | /collate-ai/sql-agent |
| sidebarTitle | Collate AI SQL Agent |
| collate | true |
Quickly understand and improve the performance of the queries that are executed in your system via a chat interface!
- Query explanation and breakdown
- Query performance improvements
- Open a Database
-
Navigate to the database section in the platform.
-
Open any database.
Example: In our case, we opened Customers.
- Go to the Queries Tab
Inside the database view, locate and click the Queries tab.
- Click the Ask Collate Icon
In the Queries tab, click on the Ask Collate icon.
- Redirect to Ask Collate
After clicking the icon, you will be redirected to the Ask Collate interface.
- Ask Anything Related to SQL Queries
In Ask Collate, type your question or request.
You can ask anything related to SQL query creation, optimization, explanations, or filters.
- Navigate to Applications: Go to
Settings > Applications.
- Install the Agent: Click on "Add Apps" to access the marketplace and install the Collate AI Tier Agent.
- Configure the Agent:
- Filter: Use the UI Query Filter builder to select assets for tier classification.
- Patch Tier If Empty: Enable this option to automatically assign a tier to assets that currently lack one.
- Scheduling: Set up regular intervals for the agent to run and update metadata.
