langchain.js
    Preparing search index...

    Function createSqlQueryChain

    • Create a SQL query chain that can create SQL queries for the given database. Returns a Runnable.

      Parameters

      Returns Promise<any>

      A runnable sequence representing the chain.

      Example: ```typescript const datasource = new DataSource({ type: "sqlite", database: "../../../../Chinook.db", }); const db = await SqlDatabase.fromDataSourceParams({ appDataSource: datasource, }); const llm = new ChatOpenAI({ model: "gpt-4o-mini", temperature: 0 }); const chain = await createSqlQueryChain({ llm, db, dialect: "sqlite", }); ```

    Settings

    Member Visibility