GenViz queries your databases where they already are. There are two places a query can run, and some databases support both:
- Desktop — the app queries the database directly from a machine that is already inside your network. Nothing to deploy.
- Connector — a small service you host inside your own network does the querying. Use it when the database is not reachable from someone's laptop, when you want scheduled or headless runs, or when you would rather not depend on what is installed on any given machine.
| Database | Runs on | Notes |
|---|---|---|
| PostgreSQL | Desktop or connector | Runs either way — desktop or connector, your call. |
| MySQL | Desktop or connector | Runs either way — desktop or connector, your call. |
| Microsoft SQL Server | Desktop | Desktop today; connector support is planned. |
| MongoDB | Desktop | Desktop today; connector support is planned. |
| Google BigQuery | Desktop | Connects with a project and service-account key rather than a URI. |
| IBM Db2 (LUW) | Connector only | Connector only — these databases usually sit where a laptop cannot reach them. |
| IBM i / AS/400 | Desktop or connector | Over ODBC. The one most tools in this category cannot reach at all. |
Credentials are stored encrypted, and queries are read-only by construction — write-shaped statements are refused before they reach the driver.
If your data is on an IBM i
The AS/400 is the one most tools in this category cannot reach at all, so it has its own page: IBM i and AS/400.
Something missing?
This page lists what ships today, and it is the page we keep current — if a database is not on it, we do not support it yet. If you need one that is not here, tell us on the waitlist and say which.