Skip to main content

​
Usage

anaconda ai create-table <TABLE> <SCHEMA> [OPTIONS]

​
Description

Creates a new table in the vector database with the specified schema. Only works with the ai-navigator and anaconda-desktop backends.

​
Arguments

​
Options

​
Schema format

The schema argument is a JSON string with the following structure: 
{
  "columns": [
    {
      "name": "column_name",
      "type": "type_name",
      "constraints": ["constraint1", "constraint2"]
    }
  ]
}
Each column requires a name and type. The constraints field is optional and accepts a list of SQL constraint strings.

​
Examples

Create a table with an ID and embedding column 
anaconda ai create-table my_table '{"columns": [{"name": "id", "type": "serial", "constraints": ["PRIMARY KEY"]}, {"name": "embedding", "type": "vector(384)"}]}'