Invoking: `sql_db_schema` with `Album, Artist`    responded: {content}            CREATE TABLE "Album" (        "AlbumId" INTEGER NOT NULL,         "Title" NVARCHAR(160) NOT NULL,         "ArtistId" INTEGER NOT NULL,         PRIMARY KEY ("AlbumId"),         FOREIGN KEY("ArtistId") REFERENCES "Artist" ("ArtistId")    )        /*    3 rows from Album table:    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),         PRIMARY KEY ("ArtistId")    )        /*    3 rows from Artist table:    ArtistId    Name    1   AC/DC    2   Accept    3   Aerosmith    */    Invoking: `sql_db_query_checker` with `SELECT COUNT(*) FROM Album JOIN Artist ON Album.ArtistId = Artist.ArtistId WHERE Artist.Name = 'Alice In Chains'`    responded: {content}        SELECT COUNT(*) FROM Album JOIN Artist ON Album.ArtistId = Artist.ArtistId WHERE Artist.Name = 'Alice In Chains'    Invoking: `sql_db_query` with `SELECT COUNT(*) FROM Album JOIN Artist ON Album.ArtistId = Artist.ArtistId WHERE Artist.Name = 'Alice In Chains'`            [(1,)]Alice In Chains has 1 album in the database.        > Finished chain.    'Alice In Chains has 1 album in the database.'As we can see, the agent used the name_search tool in order to check how to correctly query the database for this specific artist.Go deeper‚ÄãTo learn more about the SQL Agent and how it works we refer to the SQL Agent Toolkit documentation.You can also check Agents for other document types:Pandas AgentCSV AgentElastic Search‚ÄãGoing beyond the above use-case, there are integrations with other databases.For example, we can interact with Elasticsearch analytics database. This chain builds search queries via the Elasticsearch DSL API (filters and aggregations).The Elasticsearch client must have permissions for index listing, mapping description and search
Open In Colab
Open In Colab ->: Invoking: `sql_db_schema` with `Album, Artist`    responded: {content}            CREATE TABLE "Album" (        "AlbumId" INTEGER NOT NULL,         "Title" NVARCHAR(160) NOT NULL,         "ArtistId" INTEGER NOT NULL,         PRIMARY KEY ("AlbumId"),         FOREIGN KEY("ArtistId") REFERENCES "Artist" ("ArtistId")    )        /*    3 rows from Album table:    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),         PRIMARY KEY ("ArtistId")    )        /*    3 rows from Artist table:    ArtistId    Name    1   AC/DC    2   Accept    3   Aerosmith    */    Invoking: `sql_db_query_checker` with `SELECT COUNT(*) FROM Album JOIN Artist ON Album.ArtistId = Artist.ArtistId WHERE Artist.Name = 'Alice In Chains'`    responded: {content}        SELECT COUNT(*) FROM Album JOIN Artist ON Album.ArtistId = Artist.ArtistId WHERE Artist.Name = 'Alice In Chains'    Invoking: `sql_db_query` with `SELECT COUNT(*) FROM Album JOIN Artist ON Album.ArtistId = Artist.ArtistId WHERE Artist.Name = 'Alice In Chains'`            [(1,)]Alice In Chains has 1 album in the database.        > Finished chain.    'Alice In Chains has 1 album in the database.'As we can see, the agent used the name_search tool in order to check how to correctly query the database for this specific artist.Go deeper‚ÄãTo learn more about the SQL Agent and how it works we refer to the SQL Agent Toolkit documentation.You can also check Agents for other document types:Pandas AgentCSV AgentElastic Search‚ÄãGoing beyond the above use-case, there are integrations with other databases.For example, we can interact with Elasticsearch analytics database. This chain builds search queries via the Elasticsearch DSL API (filters and aggregations).The Elasticsearch client must have permissions for index listing, mapping description and search