Analytics and data APIs
Tools for analyzing data, building dashboards, and exposing databases as APIs. Project → Catalog
At a glance
| Open source | Good for | Prepared along with it |
|---|---|---|
| ClickHouse | Large-scale analytical queries | — |
| Metabase | Dashboards · reports | PostgreSQL · mail delivery |
| Hasura | PostgreSQL as a GraphQL API | PostgreSQL |
| Directus | Admin UI · API on top of a database | PostgreSQL · Redis |
ClickHouse
A column-oriented analytical database that aggregates large volumes of data quickly. It is installed as a single node.
| Item | Details |
|---|---|
| License | Apache-2.0 |
| Storage | Minimum 10Gi · recommended 50Gi |
| Usage | clickhouse.com/docs |
Metabase
A BI tool for querying databases and building charts and dashboards without knowing SQL.
| Item | Details |
|---|---|
| License | AGPL-3.0 |
| Usage | metabase.com/docs |
Dashboards, questions, and user information are all stored in the connected PostgreSQL. Mail delivery is used for dashboard subscriptions, alerts, and user invitations.
Hasura
Exposes PostgreSQL tables directly as a GraphQL API. Permissions are defined through configuration instead of code.
| Item | Details |
|---|---|
| License | Apache-2.0 |
| Usage | hasura.io/docs/2.0 |
Use the admin key only on the server
Hasura's admin key (admin secret) bypasses all permissions. Don't put it in the browser; when calling from the browser, use JWT authentication.
Directus
A headless CMS that puts an admin UI and REST/GraphQL APIs directly on top of a database.
| Item | Details |
|---|---|
| License | MSCL-1.0 — check the terms |
| Storage | Minimum 5Gi · recommended 20Gi (uploaded files) |
| Usage | directus.com/docs |
The Directus license may carry paid terms depending on organization size. Check the official license before installing.