Connect ChatGPT to your SQL Database

Connect ChatGPT to your SQL Database

With our latest real time information release, we're now able to connect ChatGPT to any SQL database you have, and transmit the result of your SQL to ChatGPT, for then to have it analyse your data, answer your question, and return an answer accordingly.

Edit - We now have multiple better ways to achieve this. You can find some of these below.

However, before I start explaining the process, let's first enjoy a screenshot 😁

Connect ChatGPT with your SQL database

What you're looking at

The above ChatGPT answer was created by executing the following SQL

select f.title as Film, count(fa.actor_id) as Actors
	from film as f
  	join film_actor as fa on f.film_id = fa.film_id
	group by f.title
    order by Actors desc
    limit 10

The above SQL of course is a part of a Hyperlambda snippet, that looks as follows;

data.connect:[generic|sakila]
   data.select:@"select f.title as Film, count(fa.actor_id) as Actors
	from film as f
  	join film_actor as fa on f.film_id = fa.film_id
	group by f.title
    order by Actors desc
    limit 10;"
   .result:
   for-each:x:@data.select/*
      set-value:x:@.result
         strings.concat
            get-value:x:@.result
            .:"Film "
            get-value:x:@.dp/#/*/Film
            .:" "
            .:"Actor count "
            get-value:x:@.dp/#/*/Actors
            .:"\r\n"
   return:x:@.result

The above Hyperlambda snippet again is using the Hyperlambda [strings.mixin] slot, which combines natural language text with the result of executing Hyperlambda code. Below is a screenshot of the complete training snippet if you're interested.

Executin SQL to create ChatGPT context data

Once the context is semantically matched towards the query, being e.g.

How many actors played in the movie MUMMY CREATURES?

The SQL extracts the following data;

Film MUMMY CREATURES Actor count 11
Film BOONDOCK BALLROOM Actor count 11
Film LAMBS CINCINATTI Actor count 10
Film HELLFIGHTERS SIERRA Actor count 10
Film ARABIA DOGMA Actor count 10
Film WIZARD COLDBLOODED Actor count 9
Film SUBMARINE BED Actor count 9
Film RANDOM GO Actor count 9
Film LESSON CLEOPATRA Actor count 9
Film IMAGE PRINCESS Actor count 9

Then our OpenAI machine learning functions submits the above data to OpenAI's APIs, which then uses the above as its "real time data foundation for answering the question", the end result being something such as follows;

There was 11 actors playing in the movie MUMMY CREATURES

In the video below I am walking you through the entire process

Pretty kick ass if you ask me 😁

Thomas Hansen

Thomas Hansen I am the CEO and Founder of AINIRO.IO, Ltd. I am a software developer with more than 25 years of experience. I write about Machine Learning, AI, and how to help organizations adopt said technologies. You can follow me on LinkedIn if you want to read more of what I write.

Published 3. Jul 2023

ChatGPT with Real Time Information

We've just added support for real time information, allowing ChatGPT to access real time information, such as today's date.

Read More

How ChatGPT makes your business 10x better

According to ChatGPT all of our clients and partners are amongst the best of the best of the best. Don't believe us? Ask ChatGPT!

Read More

Discover, design and personalize your perfect AI chatbot

We've got 20+ UI themes to pick from which I'll show you in this article, but with AINIRO you can also personalize it completely by making your own design.

Read More