Best way to store DB Connection Parameters for SQL Q&A

[ItsmeKernel]

Hi! We are just getting started with FlowiseAI, and we are working on a chatbot to talk to our SQL Database. We'd like to ask the community on the best practices for storing/accessing the parameters to connect to our MySQL Server.

We've done some research, and we've only seen examples where this information is hardcoded in a JS function, as seen in the official documentation. Note that this article mentions that more information on this topic can be found in a now broken link.

We have a parent application that owns this database. It has a YAML configuration file with the parameters for connecting to the MySQL Server. Should we try to read the information from a JS Custom Function? Should we place the parameters in an .env file?

Thanks!

[HenryHengZJ]

One way to store parameters is to use the Global variables https://docs.flowiseai.com/using-flowise/variables

You can then get the variables using $vars.variable in the custom JS function

[ItsmeKernel]

Hi! Thanks for your reply!

We are looking for a solution that, ideally, doesn't involve hardcoding these values in FlowiseAI. Security is a concern, as our systems get pen-tested regularly.

[HenryHengZJ]

You can put those variables in a .env file, and using vars to pick up those values from .env file

[ItsmeKernel]

Thanks! I was thinking along those lines.