# help Is it possible for the chat bot to query an external databases using API calls

Hey, certainly it is possible to do so using an execute card, you have the axios client available ther

@freezing-elephant-85019 @straight-yacht-31911 so I can have a mongodb db and botpress to use it ?

@thousands-raincoat-37715 yes. You just need your DB to have http-based interface that axios can query. I don't think it comes out of the box with mongodb, but here's an article with a bunch of links on various implementations: https://www.mongodb.com/features/mongodb-rest-api Although a Botpress FR for built-in drivers for the most common DBs sounds like a cool idea.

@limited-gpu-21450 so...my botpress can deduct from what user ask him, what query can do ?

I don't think I understand your question. Please provide your specific example of the functionality that you need to implement.

So…I have in db a collection with cars

(to mods and @straight-yacht-31911: apologies for getting off topic) @thousands-raincoat-37715 1. Feed the customer's query to ChatGPT ("AI Generate Text" node) with instructions explaining your db schema, asking to return query string and inserting user's input. Smth like this:

## Introduction:
I need to generate an SQL query for a database that includes information about cars and their manufacturers.

## Database Schema:
- **Manufacturers Table:**
  - `Manufacturer_ID`: INT, Primary Key
  - `Manufacturer_Name`: VARCHAR(200)
  - `Country`: VARCHAR(200)
  
- **Car_Models Table:**
  - `Model_ID`: INT, Primary Key
  - `Manufacturer_ID`: INT, Foreign Key referencing `Manufacturers(Manufacturer_ID)`
  - `Model_Name`: VARCHAR(200)
  - `Price`: DECIMAL(10,2)
  - `Horsepower`: INT
  - `Color`: VARCHAR(50)
  - `Buy_URL`: VARCHAR(200)
  - Relationship: Each car model is linked to a manufacturer through `Manufacturer_ID`.

## Query:
'I want to see a red car, bmw with 300hp'

## Comment:
Please return SQL query without any additional information or comments. If the query cannot be generated because of unclear insturctions or missing information, return 'null'.

2. Send the query to your DB through whatever interface it has. 3. Process the output: handle invalid values, send valid output back to chatgpt to transform into humand-readable format, insert images/links as markdown or whatever you need to do to make it presentable. 4. Display result in a message.

You are the God 🍩🍩

@DxD thank you so much ,I would also I like to know if this is possible with querying a relational database built using postgres or MySQL databases

@thousands-raincoat-37715 @straight-yacht-31911 Might I suggest tables? https://botpress.com/docs/cloud/studio/tables/

??

Well…I have an api for cars

Does the admin add those cars directly to the database, or is it part of some sort of an inventory system?

I have a crud project in next js

So you have access to the entry to the database when it is added, right?

Yep

So here's what I'd do - One time - download all data from the DB as CSV, upload it to a botpress table - Using webhook integration, send the row to botpress when you do any crud operation This way your botpress tables will always be in sync with your external db

I want to sell it…hard this with csv

I suggest using tables because of the following reasons - - They're optimized for vector search (natural language) - You can query them with ai filters https://botpress.com/docs/cloud/studio/tables/#using-ai-to-generate-filters - You can use them as KBs

Awesome

Great

The client will add his cars and then my bot must help him to sell the cars

They'll have to add the cars manually? Your client might have a db of their own, right?

Yes

Great. So you can write a script that consumes a CSV that your client uploads. And you can upload the data from the csv to both your mongodb instance and botpress tables

Ok

All the best with your project

Thx mate

Well, I work at botpress. We're all bots here

Wow

Unfortunately we only hiring bots at the moment