> ## Documentation Index
> Fetch the complete documentation index at: https://anaconda.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# anaconda ai create-table

export const GCell = ({children, className}) => <div className={`grid-table-cell ${className || ""}`} role="cell">
    {children}
  </div>;

export const GTH = ({children, className}) => <div className={`grid-table-th ${className || ""}`} role="columnheader">
    {children}
  </div>;

export const GRow = ({children}) => <div className="grid-table-row" role="row">{children}</div>;

export const GBody = ({children}) => <div className="grid-table-body" role="rowgroup">{children}</div>;

export const GHead = ({children}) => <div className="grid-table-head" role="rowgroup">{children}</div>;

export const GTable = ({children, className, cols}) => <div className={`grid-table not-prose overflow-hidden rounded-2xl ${className || ""}`} style={{
  "--grid-table-cols": cols
}} role="table">
    {children}
  </div>;

export const Comments = ({children}) => {
  return <div class="my-4 px-5 py-4 overflow-hidden rounded-2xl flex gap-3 border border-zinc-500/20 bg-zinc-50/50 dark:border-zinc-500/30 dark:bg-zinc-500/10" data-callout-type="comments">
      <div class="w-4">
        <svg width="14" height="14" viewBox="0 0 640 640" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="w-5 h-5" aria-label="Comments">
            <path d="M320 112C434.9 112 528 205.1 528 320C528 434.9 434.9 528 320 528C205.1 528 112 434.9 112 320C112 205.1 205.1 112 320 112zM320 576C461.4 576 576 461.4 576 320C576 178.6 461.4 64 320 64C178.6 64 64 178.6 64 320C64 461.4 178.6 576 320 576zM280 400C266.7 400 256 410.7 256 424C256 437.3 266.7 448 280 448L360 448C373.3 448 384 437.3 384 424C384 410.7 373.3 400 360 400L352 400L352 312C352 298.7 341.3 288 328 288L280 288C266.7 288 256 298.7 256 312C256 325.3 266.7 336 280 336L304 336L304 400L280 400zM320 256C337.7 256 352 241.7 352 224C352 206.3 337.7 192 320 192C302.3 192 288 206.3 288 224C288 241.7 302.3 256 320 256z" />
        </svg>
      </div>
      <div class="text-sm prose min-w-0 w-full">
        {children}
      </div>
    </div>;
};

## Usage

```bash theme={null}
anaconda ai create-table <TABLE> <SCHEMA> [OPTIONS]
```

<Comments>
  Replace \<TABLE> with the name of the table to create.<br />
  Replace \<SCHEMA> with a JSON string defining the table schema.
</Comments>

## Description

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

## Arguments

<GTable cols="25% 25% 50%">
  <GHead>
    <GRow>
      <GTH>Argument</GTH>
      <GTH>Default</GTH>
      <GTH>Description</GTH>
    </GRow>
  </GHead>

  <GBody>
    <GRow>
      <GCell>`TABLE`</GCell>

      <GCell />

      <GCell>Name of the table to create (positional, required)</GCell>
    </GRow>

    <GRow>
      <GCell>`SCHEMA`</GCell>

      <GCell />

      <GCell>JSON string defining the table schema (positional, required)</GCell>
    </GRow>
  </GBody>
</GTable>

## Options

<GTable cols="25% 25% 50%">
  <GHead>
    <GRow>
      <GTH>Option</GTH>
      <GTH>Default</GTH>
      <GTH>Description</GTH>
    </GRow>
  </GHead>

  <GBody>
    <GRow>
      <GCell>`--json`</GCell>
      <GCell>`false`</GCell>
      <GCell>Print output as JSON</GCell>
    </GRow>

    <GRow>
      <GCell>`-h, --help`</GCell>

      <GCell />

      <GCell>Show help for this command</GCell>
    </GRow>
  </GBody>
</GTable>

### Schema format

The schema argument is a JSON string with the following structure:

```json theme={null}
{
  "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**

```bash theme={null}
anaconda ai create-table my_table '{"columns": [{"name": "id", "type": "serial", "constraints": ["PRIMARY KEY"]}, {"name": "embedding", "type": "vector(384)"}]}'
```