Get Help

CAT Pilot

CAT Pilot is your AI assistant in CAT Studio.

What is CAT Pilot

CAT Pilot is an AI assistant that can help you with many things

  • get tips what CAT can do for you

  • set up new data sources

  • author tests

  • add descriptions, test name and tags based on SQL / DAX query

  • create query based on name / description of your tests or based on instructions you provide in the chat window

  • help to identify why a test failed

  • help with performance tuning of a query

  • and many other things, just anything data testing related.

Where do I find CAT Pilot

Click CAT Pilot icon in the top right side area of the CAT Studio window:

CAT icon in a highlight square, then icon of amplion and minimize/maximize/close buttons

Clicking the icon shows/hides the CAT Pilot.

CAT Pilot is by default docked to the main CAT Studio window. Clicking the unpin button the CAT Pilot will move outside to a separate window. Close button just hides it.

CAT pilot logo, text CAT Pilot, on the right side unpin button and close button

When CAT Pilot is undocked, you can use pin button to move it back to the main CAT Studio window:

CAT Pilot window with pin button

How do I setup CAT Pilot

In this version of CAT Studio, CAT Pilot needs two things:

  • an open project (just open your project or create a new empty project)

  • at least one “provider” must be configured.

Go to Settings page in CAT studio left menu and find CAT Pilot section:

CAT Pilot settings section with buttons and list of already configured providers and Enter behavior setting

OpenAI and Anthropic

To use OpenAI and Anthropic models, you need to have an API key. If you have a paid subscription for chat, it does not help. API is a separate service for both OpenAI and Anthropic.

You can obtain API key here:

  • https://platform.openai.com/

  • https://platform.claude.com/settings/keys

There is some “starter” credit, enough for trying out CAT Pilot. Or if you spent it already, send a few dollars, it is enough for using CAT Pilot.

Once you have your API key, click Add OpenAI or Add Anthropic button:

Add OpenAI Client dialog

Leave default name (you can have more providers of the same type, such as one for work and one can be your private key). We recommend using default environment variable name - that is where you API key will be stored. If it exists already, you see the key value in “API key” field. Choose default model and click Add.

And that’s it. You can say hello to your CAT Pilot :)

GitHub Copilot

For GitHub Copilot there are more prerequisites as it works different way:

  • You must have an active GitHub copilot subscription (https://github.com/features/copilot/plans), start with Free plan
  • You must have GitHub Copilot CLI installed (do NOT confuse with GitHub CLI). E.g., you can run winget install GitHub.Copilot
  • Verify it is available: copilot --version (restart your terminal if not, or restart your computer if needed)
  • If you are not logged in (check copilot auth status), run copilot auth login
  • and then just add provider on CAT Studio settings page (Add GitHub Copilot) - if copilot.exe is on your PATH, all will work

CAT Pilot chat

CAT Pilot chat looks like this:

CAT Pilot chat, tabs with names of chat, content of chat with Hi message from CAT Pilot, comboboxes for selecting provider and model

First, select provider (if you set up more) and model. Once you start chatting, the selection is locked — this will be improved in upcoming versions.

Notice you can have more chats at the same time. You can add a chat or close existing one. Chats are not persisted in this version, once you close it or close project or close CAT studio, it will be lost.

The gauge icon next to models combobox shows how many tokens you spent in the current chat.

We plan to persist the chats in upcoming versions - they will be always tied to a project.