Hey everyone! I'm currently running an application on AWS with a MySQL RDS database and an EC2 server. My apps are built using Laravel, and I'm looking to enable AI to assist users in generating various reports. For instance, users might ask how much they've spent, and I'd like to pass that information along to the AI to generate the necessary queries. However, I'm concerned about preventing any mishaps, like accidentally deleting data or pulling in the wrong customer details. I was considering using a read-only RDS instance for this but am unsure if that's the best approach. Any advice or recommendations?
3 Answers
You could definitely set up a separate database user with read-only access to avoid any accidental changes. Just be cautious because complex queries might slow down your database. A read replica could help with that if you expect a lot of traffic from the AI queries. Just remember, there's nothing stopping a wrong query from pulling the wrong info, so you have to be super careful about the queries you execute.
Using read-only credentials for the master node or querying from a read replica is a sensible solution. It really depends on your specific needs and how high the load might be. Keeping things simple is sometimes the best route!
If you're looking for something a bit more advanced, check out the Strands SDK. It looks like you might need an AI agent to help manage the queries effectively.
Related Questions
How to Build a Custom GPT Journalist That Posts Directly to WordPress
Cloudflare Origin SSL Certificate Setup Guide
How To Effectively Monetize A Site With Ads