Database Support
Dory MySQL Database Support
Dory supports MySQL and MariaDB for web application databases, operational analytics, reporting, and production troubleshooting. Use SQL Console, Explorer, AI Chat, result charts, and Saved Queries in one workflow.
Best-Fit Use Cases
- Query users, orders, products, payments, and other application tables.
- Understand unfamiliar application schemas.
- Generate reporting SQL or troubleshooting SQL with AI.
- Save recurring operational queries.
- Visualize aggregated query results.
Supported Capabilities
| Capability | MySQL / MariaDB support |
|---|---|
| Connections | Host, port, database, username, password, SSL, and SSH tunnel. |
| Explorer | Databases, tables, views, and columns. |
| SQL Console | MySQL SQL editing, execution, and results. |
| AI Chat | Schema-grounded SQL generation, explanation, and error fixing. |
| Charts & Results | Visual analysis for aggregated results. |
| Saved Queries | Save reusable MySQL queries. |
Query Tips
Use LIMIT during exploration, add explicit time filters, check indexes before running AI-generated joins, and account for version-specific function support.
Connection Requirements
- Host, port, database name, username, and password.
- Network access from the Dory runtime.
- SSL settings if the server or cloud provider requires them.
- Permissions to read schema metadata and target tables.
FAQ
Does Dory support MariaDB?
Yes. MariaDB has its own connection type and works similarly to MySQL.
Why does my MySQL connection fail?
Check the host, port, database, username, password, network allowlist, and SSL requirement.
What if AI-generated MySQL SQL does not match actual syntax?
Tell AI the MySQL or MariaDB version and paste the exact error. Verify functions, date syntax, and JSON operations before rerunning.