Coginiti's AI Assistant is a powerful set of AI-driven features to help you do more with data.
⚠️ Please note that the following features are experimental. It is important to remember that AI-generated code may not always be accurate, complete, or free from bias. The AI Assistant is designed to supplement human insight and judgment, not replace it. As a human, please be aware that you must still click a "run" button and determine whether the generated code is correct.
Getting Started
- Go to the AI Assistant tab, press the setting icon, or to Settings -> AI Assistant, and choose the generative AI model from the top menu.
- Fill in the following credentials to set up a connection.
- Check the Share database metadata with AI Assistant box, it can make your AI-generated code more accurate. Read more about Privacy and security.
- Enable Use Custom Prompt (optional) for crafting highly specific queries, personalize responses, and provide additional context, thereby tailoring your interactions with an AI Assistant to suit your individual needs and preferences.
- Click Apply to access AI Assistant.
OpenAI
To access the AI Assistant, you must have a paid account with OpenAI (to create an OpenAI paid account press here). Once your account is set up, you can connect to OpenAI's ChatGPT in Coginiti.
Credentials to set up a connection:
- API Key - To receive API key register on the OpenAI platform. Open the API Keys section in your profile and click the "Create new secret key" button. Copy and paste the new secret key in the API token field.
- Model – You can select the model that best suits your needs.
Anthropic
To access the AI Assistant, you must have a paid account with Anthropic (to create an Anthropic account press here).
Credentials to set up a connection:
- API Key - To receive the API key, sign up at Claude.ai. Open the API Keys section in your profile and click the "Create Key" button. Please note that the minimum role required is 'developer' to access the API key. Copy and paste the new secret key in the API token field.
- Model – You can select the model that best suits your needs.
Disabling the AI Assistant
- Go to Settings -> AI Assistant and select "None" on the first dropdown option.
Using the AI Assistant
Using AI to Generate Code
- To begin a conversation with the AI Assistant, click the chat and clearly describe your question in plain English.
- Click send
or use Control + Enter (macOS) or Ctrl + Enter (Windows).
- You can observe the AI generating your answer in real time.
- If you receive an unexpected answer and would like to correct your question, simply press the edit icon
and make the necessary changes.
- Click the regenerate button
if you want the AI Assistant to generate a slightly different answer based on our latest question.
- If you receive an unexpected answer and would like to correct your question, simply press the edit icon
- Once the answer is complete, you can insert code into your Query editor in two ways:
- Click the copy
icon next to the code sample, then paste it into your editor where needed.
- Click the insert at cursor
icon next to the code sample. This will automatically insert the code in your editor at the location of your cursor.
- Click the copy
- You can immediately write in the chat to be more specific or ask another question.
Don't skip any detail. The AI learns from your information, and the specificity of the information directly impacts the response's quality. Additionally, it's important to remember that errors can happen, so it's crucial to analyze the information given carefully and double-check it.
Using AI to Explain SQL Code
The AI Assistant can help you understand code, whether it's something you've written or something new you're seeing for the first time.
- Select the section of the code that you would like to receive an explanation for.
- Right-click on the highlighted code and choose AI: Explain SQL Code. Command + E (macOS) or Ctrl + E (Windows) can also be used.
- You can observe the AI generating the explanation in real time.
Using AI to Optimize SQL Code
Our assistant can offer you suggestions for optimizing your code.
- Select the section of the code that you would like to optimize.
- Right-click on the highlighted code and choose AI: Optimize SQL Code. Command + O (macOS) or Ctrl + O (Windows) can also be used.
- You can observe the AI generating your answer in real time.
Using AI to Explain and Fix Error
The AI Assistant can help you to understand and fix your SQL error, whether it's syntax errors, typos, or missed identifiers.
When you encounter an SQL error, simply select the Explain Error button beneath the error message. On the left-hand side of the AI Assistant panel, you will receive an AI-generated explanation along with recommendations for rectifying the query.
How to Clear the Chat
To clear the chat, click the "Clear" icon . Note that this action is permanent and will erase any context you may have provided to the AI Assistant in the chat.
Data Privacy Using AI Assistant
At Coginiti, we prioritize the security and privacy of your data.
Coginiti and its third-party model partner do not utilize customer data for model training purposes. This method eliminates the possibility of intellectual property being leaked due to a shared context. Our models are designed to keep your code private and secure.
Coginiti doesn't send underlying customer data to the models. This means that values of specific rows of a table aren't at risk of leakage through AI Assistant.
If you have selected the option to share metadata, the AI Assistant will use the schema information and project code as model context. It is important to note that any sensitive data in your table, column names, or code could potentially be passed to a model.
Metadata Scanning Limitations with OpenAI's API
Due to processing limitations, only some of your metadata will be used by ChatGPT. This may affect the accuracy of AI Assistant responses.
When using our AI Assistant, be aware that metadata scanning is limited to the first 500 columns of your currently active database - it will only scan up to this limit, even if you are working with larger tables.
Please consider these constraints to ensure the most accurate and efficient use of our AI Assistant.
Coming Soon
OpenAI ChatGPT and Anthropic Claude are supported now, but soon we will implement more AI-powered language models.