Note: If you want to use AI Assistant on a HIPAA or Compliance account, please contact us to explore your options.
How it works
Our AI Assistant uses advanced natural language processing (NLP) algorithms to understand your input and respond to your queries. The process involves analyzing your prompt, identifying relevant data attributes, and organizing them into a coherent schema to either generate objects in your app or provide answers to your questions.
For example, if you ask AI Assistant to create a table, the result is a structured table with fields and data types that align with your input:
Regardless of whether your prompt is valid or not, AI’s objective is always to try and provide the best response that matches your requirements. In other words, for AI Assistant, the goal is always to generate the most accurate and relevant response based on your input, even if that input might not align with conventional or sensible requests.
This feature allows you to experiment with creative, imaginative, or even nonsensical prompts to observe how the model generates responses based on those instructions. Note that the same prompt provided several times might generate different responses.
The quality of your prompt is crucial in obtaining the desired response from such AI-powered solutions as AI Assistant. A clear, specific, and well-informed prompt provides the necessary guidance to steer the AI toward generating a relevant and meaningful output that aligns with your expectations. In general, the better the quality of your prompt, the better aligned the response.
Because AI Assistant uses an NLP model, it relies on the concept of probability that is central to response generation. The model calculates the likelihood of words and phrases based on the input context, using this probability to determine the most likely and coherent response. It generates responses that are statistically probable based on the given input and the vast amount of training data it has been exposed to.
The response time depends on the complexity of your prompt, and it might take up to one minute to get an answer to your request. If you receive a response after that time, it typically means that the request is too complex and that a table cannot be generated. In such cases, you receive an error message asking you to revise the prompt.
Accessing AI Assistant
AI Assistant is available on either the Data > Tables view or in the list of tables for any application.
Review the following best practices for creating AI Assistant prompts to make sure that the generated table structure meets your requirements:
|Be clear and specific: Provide clear and specific prompts to ensure accurate interpretation and generation of the desired table structure.||Use ambiguous language: Avoid using vague or ambiguous language in your prompts, as it may lead to misunderstandings and inaccurate schema generation.|
|Include necessary information: Include all the essential details and attributes needed for your table to ensure a comprehensive result.||Omit vital attributes: Ensure you include all necessary attributes and characteristics for your table. Omitting crucial details can result in an incomplete or ineffective table structure.|
|Review proposal: Review both the proposed and the generated table structure to confirm accuracy and relevance before implementing it in your application.||Ignore review: Always review the proposal and the generated table structure. Skipping this step might lead to overlooked errors or inadequate structures that could affect your application's functionality.|
|Experiment and iterate: Test different prompts to refine and optimize the generated table structures based on your app requirements.||Rely solely on AI interpretation: While AI Assistant is a powerful tool, use your knowledge and expertise to validate the generated structures and make necessary adjustments as needed.|
To help you get started and make the most of the power that AI Assistant provides, analyze the following sample prompts. You can use these examples as the baseline for your own interactions with AI Assistant:
- List of fields that are needed
“A table to store customer information for a CRM, including the customer ID, first name, last name, email address, phone number, and the date they became a customer.”
- List of fields that are needed and a request for further suggestions
“Create a table for patient records including the patient ID, name, date of birth, medical history, and appointment dates. Propose some more fields you think are useful.”
- Information about the app type
“I want to build an online store app.”
- Information about the app type and some context
“I want to build an online store app and I need to store my customers' feedback.”
You can adapt and modify these prompts based on your specific database needs, and then let AI Assistant transform your ideas into functional tables.
Frequently asked questions (FAQ)
- Is my table data accessible by AI Assistant?
No, data in your Caspio tables is not accessed. At this time, AI Assistant is limited to new object creation based on instructional prompts. To protect sensitive information, do not include it in your prompts.
- What AI model does AI Assistant use?
AI Assistant utilizes OpenAI as the underlying technology for natural language processing (NLP). OpenAI uses your prompts to generate suggestions for database schema, table relations, and so on.
- Is my data used to train AI models?
No, per our signed agreement, data transferred through OpenAI’s API services is not used for model training or to develop AI products. Data is automatically deleted after 30 days.