Supported databases
QueryDesk connects to the databases below. Choose the matching Database type when you add a database, as in Connect a database. Each engine's guide covers its connection details and what works differently on it.
PostgreSQL protocol
| Database | Database type | Default port | AI read-only | Guide |
|---|---|---|---|---|
| PostgreSQL | PostgreSQL | 5432 | Database and parser | PostgreSQL |
| CockroachDB | CockroachDB | 26257 | Database and parser | CockroachDB |
| TimescaleDB | TimescaleDB | 5432 | Database and parser | TimescaleDB |
| Google AlloyDB | Google AlloyDB | 5432 | Database and parser | Google AlloyDB |
| Amazon Redshift | Amazon Redshift | 5439 | Database and parser | Amazon Redshift |
MySQL protocol
| Database | Database type | Default port | AI read-only | Guide |
|---|---|---|---|---|
| MySQL | MySQL | 3306 | Database and parser | MySQL |
| MariaDB | MariaDB | 3306 | Database and parser | MariaDB |
| TiDB | TiDB | 4000 | Database and parser | TiDB |
| OceanBase (MySQL mode) | OceanBase (MySQL mode) | 2881 | Database and parser | OceanBase |
| StarRocks | StarRocks | 9030 | Parser only | StarRocks |
| Apache Doris | Apache Doris | 9030 | Parser only | Apache Doris |
Other engines
| Database | Database type | Default port | AI read-only | Guide |
|---|---|---|---|---|
| SQL Server | SQL Server | 1433 | Parser only | SQL Server |
| Oracle | Oracle | 1521 | Database and parser | Oracle |
| ClickHouse | ClickHouse | 8123 (HTTP) | Database and parser | ClickHouse |
| MongoDB | MongoDB | 27017 | Parser only | MongoDB |
AI read-only says what refuses an AI write when a database is set to Read only: QueryDesk's parser always does, and where the database has a read-only mode QueryDesk runs the query in it too. See AI governance.
Managed services
A managed service connects with the database type of the engine it runs. Amazon RDS and Amazon Aurora connect as PostgreSQL, MySQL or MariaDB. Cloud SQL and Azure Database connect as PostgreSQL, MySQL or SQL Server. Timescale Cloud connects as TimescaleDB. Use the endpoint the service gives you as the hostname, and turn on Encryption when the service requires TLS.
A database in a private network is reached through a Tunnel.