MySQL Connector
Connect to MySQL and MariaDB databases for natural language queries.
Overview
The MySQL connector supports:
- MySQL 5.7+ and 8.x
- MariaDB 10.x+
- Natural language to SQL
- Schema discovery
Prerequisites
- MySQL/MariaDB database
- Read access credentials
- Network connectivity
Configuration
| Setting | Description |
|---|---|
| Host | Database hostname |
| Port | Database port (3306) |
| Database | Database name |
| Username | DB user |
| Password | User password |
| TLS | Enable TLS encryption |
Setup Steps
- Add Connector: Knowledge → Add Data Source → MySQL
- Enter Connection: Host, port, database
- Provide Credentials: Username and password
- Configure TLS: If required
- Test & Create: Verify and save
Best Practices
- Use a dedicated read-only user
- Enable TLS for production
- Add table comments for NL understanding
- Limit to necessary tables
Troubleshooting
Access denied: Check user privileges
Connection timeout: Verify network/firewall
SSL errors: Configure TLS settings