MySQL
Coming Soon
MySQL support is under active development. This page describes the planned integration.
Overview
MySQL is one of the most widely deployed relational databases. GradientHarbor will support querying MySQL databases directly for teams with data stored in MySQL-based systems.
┌─────────────────┐ ┌──────────────────┐
│ GradientHarbor │────▶│ MySQL │
│ │ SQL │ │
│ AI Agent │◀────│ Query Engine │
│ Dashboards │ │ (InnoDB/etc.) │
└─────────────────┘ └──────────────────┘Planned Configuration
| Field | Description |
|---|---|
| Host | MySQL server hostname or IP |
| Port | Server port (default: 3306) |
| Database | Database name |
| Username | MySQL user |
| Password | User password |
| SSL | Optional SSL certificate for encrypted connections |
Optimization Tips
MySQL is a transactional (row-based) database. For best results with analytical dashboards:
- Add indexes on columns used in WHERE and GROUP BY clauses
- Use summary tables or materialized views for frequently aggregated data
- Consider read replicas — Point GradientHarbor at a read replica to avoid impacting production
- For large-scale analytics (10M+ rows), consider replicating data to a columnar warehouse like Snowflake or BigQuery