MySQL is a widely used open-source relational database management system that allows for efficient data storage and retrieval. It’s commonly used for web applications, data analysis, and more.

The MySQL data connector enables you to connect your MySQL database to Formula Bot for custom queries, analysis, and reporting.

Features

• Secure connection to MySQL databases

• Custom query execution and analysis

• Table and database selection for detailed reporting

Instructions

1. Connect Your MySQL Database

   • Input the following details in Formula Bot:

     • Username: Your MySQL database username.

     • Password: The corresponding password.

     • Host: The server where your MySQL database is hosted.

     • Port: Typically, this is 3306, unless your database is set up with a different port.

2. Select Database and Table

   • After successfully connecting, select the database you want to work with.

   • Choose the specific table from the database for analysis.

3. Generating Queries and Reports

   • Once connected, you can use the AI Chat to generate reports. For example:

     • "Show me the total sales from the orders table."

     • "What are the top 10 customers based on purchase value?"

Troubleshooting

• Ensure that the correct Username, Password, Host, and Port are provided.

• Verify that your database allows remote access if you encounter connection issues.

For further assistance, contact us at hello@formulabot.com.