Database Support
Dory MariaDB Database Support
Dory supports MariaDB as a dedicated connection type for web applications, internal systems, reporting, and operational analytics. MariaDB feels similar to MySQL in Dory, but version-specific SQL behavior can differ.
Best-Fit Use Cases
- Query users, orders, products, payments, and other application tables.
- Explore unfamiliar MariaDB schemas.
- Generate reporting SQL with AI.
- Investigate production or staging data issues.
- Save reusable MariaDB queries for the team.
Supported Capabilities
| Capability | MariaDB support |
|---|---|
| Connections | Host, port, database, username, password, SSL, and SSH tunnel. |
| Explorer | Databases, tables, views, and columns. |
| SQL Console | MariaDB SQL editing, execution, and results. |
| AI Chat | Schema-grounded SQL generation, explanation, and fixing. |
| Charts & Results | Visual analysis for aggregated results. |
| Saved Queries | Save reusable MariaDB SQL. |
Tips
Tell AI that the target database is MariaDB, especially when JSON functions, window functions, or system tables matter. Use readonly accounts and explicit time ranges in production.
Connection Requirements
- Host, port, database name, username, and password.
- Network access from the Dory runtime.
- SSL settings if required by your deployment.
- A user with permission to read target schemas and tables.
FAQ
Can I use the MySQL page recommendations for MariaDB?
Yes, most connection and query practices overlap. Still check MariaDB-specific version behavior for functions, JSON features, and SQL modes.
What should I check first when connection fails?
Check host, port, credentials, firewall rules, database name, and whether the user can access the target schema.