text_to_sql - Docs

Generates SQL from a given prompt.

Parameters

These are the parameters for OpenAI. Set the authentication parameters for other models as appropriate from the function definitions above.

prompt

string

required

Prompt

api_key

string

required

API key for using the LLM model

table_names

list

required

List of table names used for generation

model

string

LLM model to use

connection

string

Connection used for generation

schema_name

string

Schema name used for generation

Example

from morph_lib.ai.openai import text_to_sql
import os

@morph.func
def func_name(context):
    sql = text_to_sql(
		prompt,
		os.environ["OPENAI_API_KEY"],
		["user"],
		"gpt-4o",
	)
	return execute_sql(sql)

@morph.variables text_to_plotly

On this page

Parameters
Example