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

DatabaseDatabase typeDefault portAI read-onlyGuide
PostgreSQLPostgreSQL5432Database and parserPostgreSQL
CockroachDBCockroachDB26257Database and parserCockroachDB
TimescaleDBTimescaleDB5432Database and parserTimescaleDB
Google AlloyDBGoogle AlloyDB5432Database and parserGoogle AlloyDB
Amazon RedshiftAmazon Redshift5439Database and parserAmazon Redshift

MySQL protocol

DatabaseDatabase typeDefault portAI read-onlyGuide
MySQLMySQL3306Database and parserMySQL
MariaDBMariaDB3306Database and parserMariaDB
TiDBTiDB4000Database and parserTiDB
OceanBase (MySQL mode)OceanBase (MySQL mode)2881Database and parserOceanBase
StarRocksStarRocks9030Parser onlyStarRocks
Apache DorisApache Doris9030Parser onlyApache Doris

Other engines

DatabaseDatabase typeDefault portAI read-onlyGuide
SQL ServerSQL Server1433Parser onlySQL Server
OracleOracle1521Database and parserOracle
ClickHouseClickHouse8123 (HTTP)Database and parserClickHouse
MongoDBMongoDB27017Parser onlyMongoDB

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.

Was this page helpful?