DEV Community

Use ChatGPT to Explore Your Database Schema

Sualeh Fatehi on July 03, 2023

SchemaCrawler is a relational database exploration tool. It obtains database schema metadata such as tables, stored procedures, foreign keys, trigg...
Collapse
 
adriens profile image
adriens

Looks like we have a rainy week-end here... so asking for my favorit database assistant some help about a little database :

Image description

This is pretty exciting... and I have some fdedback/improvements : where would like me to drop them to you ?

Collapse
 
adriens profile image
adriens

Dedciated blog post on its way 🚀

Collapse
 
adriens profile image
adriens

AWESOME @sualeh , I'll give it a try very soon. I have to purchase a key.
BTW : would you share with us :

  • Which model you used undehood ? gpt-3.5 turbo like ?
  • How many tokens were used to standard database exploration ?
Collapse
 
sualeh profile image
Sualeh Fatehi

The default model is gpt-3.5-turbo. I spent $0.07 during development, so you can imagine that it does not use too many tokens.

Collapse
 
d3n_57 profile image
d-3-n

You probably didn't spend 0.07$. I was wondering why I still didn't get access to gpt4, b/c allegedly they have opened the access to everyone they have billed. It turns out they have never billed me anything. My guess is b/c trx costs would outweigh the value of the trx.

Collapse
 
adriens profile image
adriens

Guess I'll create a dedicated story telling, I already a target database I could inspect this way.
BtW, is the duckdb driver fixed ?

Thread Thread
 
sualeh profile image
Sualeh Fatehi

That will be great!

The DuckDB driver is not fixed yet.

Thread Thread
 
adriens profile image
adriens

ARFF ;-(

Collapse
 
vijai_bishnoi profile image
Info Comment hidden by post author - thread only accessible via permalink
Vijay Bishnoi
Collapse
 
mohanrajlearn profile image
Info Comment hidden by post author - thread only accessible via permalink
Mohanraj

I am unable to access uploaded .csv file for chatbot process by using openai api key in nextjs project.Kindly suggest me any libraries or logic to moveahead.

Some comments have been hidden by the post's author - find out more