Deleting Records - Githubissues

alex-wolf-ps / dbchatpro

MIT License

13 stars 14 forks source link

Open Mark-Phillipson opened 1 month ago

Mark-Phillipson commented 1 month ago

If the AI is asked to create a Delete or Update SQL Statement, It may be best to not run directly.

alex-wolf-ps commented 1 month ago

That's true, you could implement this through a couple options:

Check the SQL query returned from the AI for keywords like "Drop" or "Delete" and don't run it if it contains those
Make sure the user you're connecting to the DB only has read permissions You'd probably want to implement both actually, so that you don't have to rely on authentication exceptions.