Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Model

Functions related to model management. Models are necessary for engines to make inference calls.

Models must support at least one of two capabilities, text encoding or chat. For more information about what each model interface supports, See Model Configs for supported interfaces.

All model names must be in snake case.


models

List model profiles currently active.

Usage

SELECT * FROM sqlgen.models;

model_descriptions

List available models usable by add_model.

Usage

SELECT * FROM sqlgen.model_descriptions;

add_model

Creates a new model profile.

Returns

  • Type: VOID

Parameters

model_name
  • Description: Name of model
  • Type: TEXT
  • Optional: false
config_str
  • Description: Model configuration
  • Type: Model config
  • Optional: false

Example

SELECT sqlgen.add_model(
    'openai_chat',
    sqlgen.openai_completions_config(api_key => 'sk-proj-12345')
);

remove_model

Deletes a model profile.

Returns

  • Type: VOID

Parameters

model_name
  • Description: Name of model
  • Type: TEXT
  • Optional: false

Example

SELECT sqlgen.remove_model('openai_chat');