MySQL

​
Connection Details

FieldDescriptionExample
HostYour MySQL server addressdb.example.com
PortMySQL port (default 3306)3306
DatabaseDatabase nameproduction_db
UsernameMySQL userreadonly_user
PasswordUser password••••••••

​
Setting Up

1

Go to Connectors → Database

Select MySQL as the database type.
Selecting MySQL
2

Enter connection details

Fill in the host, port, database name, username, password, and SSL CA certificate.
MySQL connection form
3

Test connection

Click Test Connection to verify.
Testing MySQL connection
4

Select tables

Choose which tables Generate should have access to.
Selecting MySQL tables
5

Save

Your MySQL database is now queryable in conversations.

​
Example Questions

  • “How many orders were placed this month?”
  • “Show me the top 10 customers by revenue”
  • “What’s the average order value by region?”
For best results, use a read-only database user to prevent accidental data modifications.