selfhost.directory

The index of self-hostable projects — ranked, categorized and served with live updates.
Own your data and stop giving it to big tech.

tellery logo

Self-host tellery

v0.8.8

SQL-based metrics platform for collaborative data analysis

BetaOpen SourceApache-2.0
Updated14 hours ago
LanguageTypescript
Setup difficultyModerate
Stars
360
Ports
8000 (web UI), 50051 (connector gRPC)
Requires
PostgreSQL, Redis
Docker
tellery/tellery
Install with Docker Compose

What is tellery?

Tellery is a self-hosted business intelligence platform that lets data teams define metrics using SQL and share them through collaborative documents and dashboards. It provides a modern SQL editor with auto-complete, a rich-text editor with slash commands and markdown support, drag-and-drop dashboard building, real-time multiplayer collaboration, and the ability to import dbt models and sources. The platform connects to databases through officially supported and community-supported connectors. It runs via Docker Compose with PostgreSQL and Redis as dependencies, exposing the web UI on port 8000 and a connector service on port 50051. The project is licensed under Apache-2.0 and the latest release is v0.8.8 from August 2022.

Should you self-host tellery?

tellery scores 45/100 on selfhost.directory (how scoring works) and ranks #15 of 15 in Business Intelligence. It has 360 GitHub stars.

There was no stable release in the past 12 months, so check the repository's recent activity before you rely on it.

Setup is moderate: expect some configuration beyond a single command. An official Docker image is available. It is Apache-2.0-licensed and written mostly in Typescript.

Its closest alternative on selfhost.directory is Superset (88/100, 75 342 stars). It scores higher overall, so compare the two before you pick. See tellery vs Superset side by side.

Features

  • Collaborative documents and dashboards
  • Database Connectors
  • Dbt model import
  • Modern SQL editor
  • Real-time multiplayer collaboration
  • SQL-based metric definitions

tellery README

How to install tellery

Install tellery with Docker Compose

Environment variables
TELLERY_SERVER_IMAGE, TELLERY_CONNECTOR_IMAGE, CREATE_CONNECTOR_URL, SERVER_PROTO, SERVER_HOST, SERVER_PORT, EMAIL_USE_TLS, EMAIL_USERNAME, EMAIL_PASSWORD, EMAIL_PORT, EMAIL_HOST, EMAIL_FROM, SECRET_KEY, CREATE_USER_EMAIL, CREATE_USER_NAME, CREATE_USER_PASSWORD, POSTGRES_USERNAME, POSTGRES_PASSWORD, POSTGRES_DB

Clone the Tellery repo

git clone https://github.com/tellery/tellery.git

Change directories into the demo directory

cd tellery/deploy/compose

View or edit config file (optional)

vim .env

Run docker compose

docker-compose up

Access on http://localhost:8000 with default admin@tellery.local / tellery

How to configure tellery

  • CREATE_CONNECTOR_URLtellery-connector:50051URL for the connector service

    URL for the connector service

  • CREATE_USER_EMAILadmin@tellery.localInitial admin user email

    Initial admin user email

  • CREATE_USER_NAMEadminInitial admin user name

    Initial admin user name

  • CREATE_USER_PASSWORDtelleryInitial admin user password

    Initial admin user password

  • EMAIL_FROMFrom email address

    From email address

  • EMAIL_HOSTSMTP host

    SMTP host

  • EMAIL_PASSWORDEmail password for SMTP

    Email password for SMTP

  • EMAIL_PORT587SMTP port

    SMTP port

  • EMAIL_USERNAMEEmail username for SMTP

    Email username for SMTP

  • EMAIL_USE_TLSfalseUse TLS for email

    Use TLS for email

  • POSTGRES_DBtelleryPostgreSQL database name

    PostgreSQL database name

  • POSTGRES_PASSWORDZMnyXaVYm8ItOv+vhoh07QPostgreSQL password

    PostgreSQL password

  • POSTGRES_USERNAMEpostgresPostgreSQL username

    PostgreSQL username

  • SECRET_KEYpjfJ2Cbe3sv0Gtz32Krr4ASecret key for application

    Secret key for application

  • SERVER_HOSTlocalhostServer hostname

    Server hostname

  • SERVER_PORT8000Server port

    Server port

  • SERVER_PROTOhttpServer protocol (http/https)

    Server protocol (http/https)

  • TELLERY_CONNECTOR_IMAGEtellery/connectorDocker image for the Tellery connector

    Docker image for the Tellery connector

  • TELLERY_SERVER_IMAGEtellery/telleryDocker image for the Tellery server

    Docker image for the Tellery server

tellery releases & version history

More in Business Intelligence

Rate this project

Click to rate — no account needed.

0 comments

Posting as guest
Loading comments…