Database Hub
Database Hub is your database manager — an intuitive system to connect to your databases and manage records through a simplified UI.
Key Features
Connect to different types of databases
Seamlessly connect to different types of databases like Postgres, MySQL, MongoDB, ClickHouse and more, without migrating your data into DashX.
Visualize and Modify records
Automatic analysis of the database structure gives you the ability to create, read, update, and delete records straight away, with no schema definition to write by hand. ClickHouse tables are read-only.
Establish checks and balances over data
With a comprehensive system of roles and permissions, and granular control at the record level, control who can access what. See Permissions.
Supported databases
| Database | Integration |
|---|---|
| PostgreSQL | PostgreSQL |
| MySQL | MySQL |
| MongoDB | MongoDB |
| BigQuery | BigQuery |
| ClickHouse | ClickHouse |
How it fits with the data layer
Database Hub is the app; the individual database integrations are the connections.
- Install the integration for your database and give it connection details.
- Open Data > Overview and choose Sync Database.
- Pick the tables you want. Each becomes a Resource, with its columns mapped to attributes.
From that point the tables are queryable through the DashX GraphQL and REST APIs, and their records are browsable and editable in the dashboard.
ClickHouse tables can't be synced into Resources. Its databases and tables appear in Database Hub as soon as you save the integration, read-only, and you query them with SQL or saved operations. See ClickHouse.
Getting Started
- Install the Database Hub app in your workspace.
- Install the integration for your database.
- Sync the schema and start working with your records. For ClickHouse, saving the integration reads the schema, so there is nothing to sync.
Connect DashX with a dedicated database user that has only the privileges you actually want to expose. Read-only access is enough if you only intend to query.