Class that represents a SQL database in the LangChain framework.

Security Notice This class generates SQL queries for the given database. The SQLDatabase class provides a getTableInfo method that can be used to get column information as well as sample data from the table. To mitigate risk of leaking sensitive data, limit permissions to read and scope to the tables that are needed. Optionally, use the includesTables or ignoreTables class parameters to limit which tables can/cannot be accessed.

See https://js.langchain.com/docs/security for more information.

Hierarchy (view full)

Implements

Constructors

Properties

allTables: SqlTable[] = []
appDataSource: DataSource
appDataSourceOptions: DataSourceOptions
customDescription?: Record<string, string>
ignoreTables: string[] = []
includesTables: string[] = []
sampleRowsInTableInfo: number = 3

Methods

  • Get information about specified tables.

    Follows best practices as specified in: Rajkumar et al, 2022 (https://arxiv.org/abs/2204.00498)

    If sample_rows_in_table_info, the specified number of sample rows will be appended to each table description. This can increase performance as demonstrated in the paper.

    Parameters

    • OptionaltargetTables: string[]

    Returns Promise<string>

  • Execute a SQL command and return a string representing the results. If the statement returns rows, a string of the results is returned. If the statement returns no rows, an empty string is returned.

    Parameters

    • command: string
    • fetch: "all" | "one" = "all"

    Returns Promise<string>