AI.Studio

AI Studio is a tool that enables users to create database-specific SQL queries from text queries using any LLM model in their collection.

LLM models, such as the OpenAI GPT model, can be stored in the Datasource section just like any other datasource. Objects related to each model can be viewed in this section. Any LLM model from this collection can be used on the go within AI Studio.

How It Works

1. AI chat session

Users can switch to text-based queries in the editor to start an AI chat session.

\
\

2. Querying

A natural language text-based query can be fed to the AI to generate a well-formed SQL query.

3. Query execution

The generated SQL query can be edited and executed to perform the desired operation.

\
\

4. Results

After executing the query, results are displayed in the bottom section with multi-graphical representation capabilities.

Benefits

Customization and Flexibility

Provides the flexibility to utilize the required LLM model without concerns about data privacy and cost. Additionally, users can switch between datasources on the go without losing the query and chat session.

Datasource specific

Queries are highly specific to the selected datasource, minimizing the need for syntax modifications.

Metadata inclusion

Queries are more precise as the LLM model utilizes the metadata from the datasource.

Follow up

Users can ask follow-up questions without needing to provide context from previous queries.

Features

Customization and Flexibility

Users can select any supported datasource and LLM model from their collection.

Datasource specific

AI-generated queries are tailored for the specific datasource selected.

Metadata inclusion

Metadata from the datasource is used to generate more accurate queries.

Follow up

Follow-up questions are supported in chat sessions.