Text to SQL Node
Last updated
Last updated
The Text To SQL node generates sql queries from natural language queries.
Natural language query: The query in natural language
Type: Text
Schema: The schema you want the SQL query to follow
Type: Text
Face of the node:
SQL Database: Choose the SQL database the data is in. The available options are: MySQL, PostgreSQL, Snowflake and SQLite3. The default database is MySQL.
In the gear:
LLM model: The llm model you want to use to generate the query. The available options are: o3-mini, o1, o1-mini, o1-preview, chatgpt-4o-latest, gpt-4o, gpt-4o-2024-08-06, gpt-4o-mini, gpt-4-turbo, gpt-4-turbo-2024-04-09, gpt-4 and gpt-3.5-turbo. The default value is gpt-4o.
Sql_query: The sql query generated by the llm
Type: Text
Example usage: {{nl_to_sql_0.sql_query}}
