LangChain db.getTableInfo

README.md

LangChain db.getTableInfo

If you follow the LangChain recipe for "Querying a SQL DB" you'll note that it calls db.getTableInfo

I was trying to implement this in an unsupported typeorm database.

The format it is using is from the paper Evaluating the Text-to-SQL Capabilities of Large Language Models

It contains the create table statement and some sample lines. I included the example, thinking someone else might need this in the future.

chinook-db-get-table-info.txt

CREATE TABLE Album (
AlbumId INTEGER NOT NULL, Title NVARCHAR(160) NOT NULL, ArtistId INTEGER NOT NULL) 
SELECT * FROM "Album" LIMIT 3;
 AlbumId Title ArtistId
 1 For Those About To Rock We Salute You 1
 2 Balls to the Wall 2
 3 Restless and Wild 2
CREATE TABLE Artist (
ArtistId INTEGER NOT NULL, Name NVARCHAR(120) ) 
SELECT * FROM "Artist" LIMIT 3;
 ArtistId Name
 1 AC/DC
 2 Accept
 3 Aerosmith
CREATE TABLE Customer (
CustomerId INTEGER NOT NULL, FirstName NVARCHAR(40) NOT NULL, LastName NVARCHAR(20) NOT NULL, Company NVARCHAR(80) , Address NVARCHAR(70) , City NVARCHAR(40) , State NVARCHAR(40) , Country NVARCHAR(40) , PostalCode NVARCHAR(10) , Phone NVARCHAR(24) , Fax NVARCHAR(24) , Email NVARCHAR(60) NOT NULL, SupportRepId INTEGER ) 
SELECT * FROM "Customer" LIMIT 3;
 CustomerId FirstName LastName Company Address City State Country PostalCode Phone Fax Email SupportRepId
 1 Luís Gonçalves Embraer - Empresa Brasileira de Aeronáutica S.A. Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 +55 (12) 3923-5555 +55 (12) 3923-5566 [email protected] 3
 2 Leonie Köhler null Theodor-Heuss-Straße 34 Stuttgart null Germany 70174 +49 0711 2842222 null [email protected] 5
 3 François Tremblay null 1498 rue Bélanger Montréal QC Canada H2G 1A7 +1 (514) 721-4711 null [email protected] 3
CREATE TABLE Employee (
EmployeeId INTEGER NOT NULL, LastName NVARCHAR(20) NOT NULL, FirstName NVARCHAR(20) NOT NULL, Title NVARCHAR(30) , ReportsTo INTEGER , BirthDate DATETIME , HireDate DATETIME , Address NVARCHAR(70) , City NVARCHAR(40) , State NVARCHAR(40) , Country NVARCHAR(40) , PostalCode NVARCHAR(10) , Phone NVARCHAR(24) , Fax NVARCHAR(24) , Email NVARCHAR(60) ) 
SELECT * FROM "Employee" LIMIT 3;
 EmployeeId LastName FirstName Title ReportsTo BirthDate HireDate Address City State Country PostalCode Phone Fax Email
 1 Adams Andrew General Manager null 1962-02-18 00:00:00 2002-08-14 00:00:00 11120 Jasper Ave NW Edmonton AB Canada T5K 2N1 +1 (780) 428-9482 +1 (780) 428-3457 [email protected]
 2 Edwards Nancy Sales Manager 1 1958-12-08 00:00:00 2002-05-01 00:00:00 825 8 Ave SW Calgary AB Canada T2P 2T3 +1 (403) 262-3443 +1 (403) 262-3322 [email protected]
 3 Peacock Jane Sales Support Agent 2 1973-08-29 00:00:00 2002-04-01 00:00:00 1111 6 Ave SW Calgary AB Canada T2P 5M5 +1 (403) 262-3443 +1 (403) 262-6712 [email protected]
CREATE TABLE Genre (
GenreId INTEGER NOT NULL, Name NVARCHAR(120) ) 
SELECT * FROM "Genre" LIMIT 3;
 GenreId Name
 1 Rock
 2 Jazz
 3 Metal
CREATE TABLE Invoice (
InvoiceId INTEGER NOT NULL, CustomerId INTEGER NOT NULL, InvoiceDate DATETIME NOT NULL, BillingAddress NVARCHAR(70) , BillingCity NVARCHAR(40) , BillingState NVARCHAR(40) , BillingCountry NVARCHAR(40) , BillingPostalCode NVARCHAR(10) , Total NUMERIC(10,2) NOT NULL) 
SELECT * FROM "Invoice" LIMIT 3;
 InvoiceId CustomerId InvoiceDate BillingAddress BillingCity BillingState BillingCountry BillingPostalCode Total
 1 2 2009-01-01 00:00:00 Theodor-Heuss-Straße 34 Stuttgart null Germany 70174 1.98
 2 4 2009-01-02 00:00:00 Ullevålsveien 14 Oslo null Norway 0171 3.96
 3 8 2009-01-03 00:00:00 Grétrystraat 63 Brussels null Belgium 1000 5.94
CREATE TABLE InvoiceLine (
InvoiceLineId INTEGER NOT NULL, InvoiceId INTEGER NOT NULL, TrackId INTEGER NOT NULL, UnitPrice NUMERIC(10,2) NOT NULL, Quantity INTEGER NOT NULL) 
SELECT * FROM "InvoiceLine" LIMIT 3;
 InvoiceLineId InvoiceId TrackId UnitPrice Quantity
 1 1 2 0.99 1
 2 1 4 0.99 1
 3 2 6 0.99 1
CREATE TABLE MediaType (
MediaTypeId INTEGER NOT NULL, Name NVARCHAR(120) ) 
SELECT * FROM "MediaType" LIMIT 3;
 MediaTypeId Name
 1 MPEG audio file
 2 Protected AAC audio file
 3 Protected MPEG-4 video file
CREATE TABLE Playlist (
PlaylistId INTEGER NOT NULL, Name NVARCHAR(120) ) 
SELECT * FROM "Playlist" LIMIT 3;
 PlaylistId Name
 1 Music
 2 Movies
 3 TV Shows
CREATE TABLE PlaylistTrack (
PlaylistId INTEGER NOT NULL, TrackId INTEGER NOT NULL) 
SELECT * FROM "PlaylistTrack" LIMIT 3;
 PlaylistId TrackId
 1 3402
 1 3389
 1 3390
CREATE TABLE Track (
TrackId INTEGER NOT NULL, Name NVARCHAR(200) NOT NULL, AlbumId INTEGER , MediaTypeId INTEGER NOT NULL, GenreId INTEGER , Composer NVARCHAR(220) , Milliseconds INTEGER NOT NULL, Bytes INTEGER , UnitPrice NUMERIC(10,2) NOT NULL) 
SELECT * FROM "Track" LIMIT 3;
 TrackId Name AlbumId MediaTypeId GenreId Composer Milliseconds Bytes UnitPrice
 1 For Those About To Rock (We Salute You) 1 1 1 Angus Young, Malcolm Young, Brian Johnson 343719 11170334 0.99
 2 Balls to the Wall 2 2 1 null 342562 5510424 0.99
 3 Fast As a Shark 3 2 1 F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman 230619 3990994 0.99