Caspio AI Assistant is our new AI-powered solution designed to revolutionize how you create your applications. In this initial release, you can use AI Assistant to create a table structure by entering textual prompts with your requirements in any language. Using the power of AI, AI Assistant interprets and transforms your prompt into a proposed table structure, making database management more accessible and efficient. We will be enhancing AI Assistant with additional features in the future to make your application development even easier and faster. 
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:

A series of images showing the process of generating a table using AI Assistant.

Instructive prompting

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. 

Prompt quality

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. 

Response probability

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.  

Response time

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. 

A series of views showing a list of tables with the AI Assistant panel available on the side and a sample table generated based on the prompt.

Best practices

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. 

Sample prompts

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.