In simple English
This tool lets you build dashboards and charts from your databases. You can connect it to PostgreSQL, ClickHouse, or Snowflake to see your numbers in one place. It gives you a web interface to query data and share reports with your team. Running it requires a server with at least four gigabytes of memory and Docker installed. It costs nothing to download and use under an open-source licence.
What it is
DataLens is a scalable business intelligence and data visualization platform originally developed at Yandex. It includes a user interface, a Python backend for data processing, and authentication services.
What it is good for
Solo builders who want to create internal dashboards, query multiple data sources through a single web interface, and share visual reports without paying for commercial cloud tools.
- Connects to many popular databases like PostgreSQL, MySQL, ClickHouse, and Snowflake.
- Includes a web-based interface for building charts and managing user permissions.
- Can be deployed easily using Docker Compose or Kubernetes.
- Requires at least 4 GB of RAM and 2 CPU cores to run smoothly.
- Initial setup involves managing multiple containers and secret keys.
- Some visualization types rely on Highcharts, which has its own commercial licence restrictions.
Paid business intelligence software and manual spreadsheet reporting.
PostgreSQL (a robust open-source relational database to store application state and user data)
- apache/superset75k stars
A popular open-source data exploration and visualization platform with broad database support.
- metabase/metabase50k stars
An open-source business intelligence tool designed for fast setup and simple querying.
- lightdash/lightdash6.2k stars
An open-source business intelligence tool built directly on top of dbt models.
- meilisearch/meilisearch59k stars
A search engine you run yourself, built for fast answers and forgiving spelling.
- beekeeper-studio/beekeeper-studio24k stars
A desktop window onto a database, so you can read and edit rows without writing commands.
- sqliteai/sqlite-vector1.1k stars
An add-on that gives the single-file SQLite database meaning-based search, with its own accuracy figures printed in the README.
git clone https://github.com/datalens-tech/datalens && cd datalens HC=1 docker compose up