DB Connect FAQs

Question 1

What is DB Connect and what is its primary purpose?

Accepted Answer

DB Connect is a multi-database server designed for safe, read-only exploratory data analysis across PostgreSQL, MySQL, and ClickHouse databases, enabling comprehensive insights without risk to your operational data.

Question 2

Which database systems are supported by DB Connect?

Accepted Answer

DB Connect offers comprehensive support for PostgreSQL, MySQL (including MariaDB), and ClickHouse. It provides specific optimizations and advanced metadata capabilities tailored for each database type.

Question 3

How does DB Connect ensure data security and prevent accidental modifications?

Accepted Answer

It enforces read-only access at multiple levels, validates queries to only allow SELECT and WITH statements, automatically limits result sets, and adds safety parameters to all database connection strings, significantly minimizing risk.

Question 4

Can I use DB Connect to analyze data from a database behind a firewall?

Accepted Answer

Yes, DB Connect includes robust SSH Tunnel Support. This feature allows you to securely connect to remote databases through bastion hosts, offering automatic tunnel management and flexible authentication methods (password or private key).

Question 5

What data analysis features does DB Connect offer?

Accepted Answer

DB Connect provides advanced data analysis capabilities such as detailed column profiling (including statistics, value frequency, and cardinality), intelligent data sampling for previews, execution of custom read-only SQL queries, and high-level database profiling.

DB Connect

DB Connect

Key Features

Use Cases

Key Features

Use Cases