Supported Databases

Kvery connects to your databases through PDO drivers. The following database engines are supported:

Database	Driver	Notes
MySQL	mysql	The standard MySQL driver.
MariaDB	mysql	MariaDB is wire-compatible with MySQL, so it uses the MySQL driver.
PostgreSQL	pgsql	Full PostgreSQL support.
Microsoft SQL Server	dblib	Connects via FreeTDS / DBLIB.

When you create a database connection you choose one of these drivers and provide the host, port, and credentials.

Securing connections

Each connection can be hardened:

• SSL — upload your client SSL certificate so traffic between Kvery and your database is encrypted.
• SSH tunnel — route the connection through an SSH bastion host. Kvery allocates a dedicated tunnel port per connection.

See Database connections for the full setup.

Query timeouts

To keep the platform responsive, queries run under a timeout (100 seconds by default). This limit is applied at several layers — the PHP execution time, the PDO connection timeout, and the web/FastCGI layer — so very long-running queries are stopped gracefully rather than hanging.

If you need to process large amounts of data, consider:

• Adding pagination or LIMIT to your queries.
• Using scheduled queries that run in the background.
• Running a query in the background instead of waiting for it interactively.

A note on other databases

Only the engines listed above are available today. NoSQL stores (such as MongoDB) are not currently supported. If your data lives elsewhere, a common pattern is to replicate or sync it into one of the supported SQL databases and point Kvery at that.