Open Source Business Intelligence
Description
Sopho is an open source Business Intelligence (BI) platform rethought from scratch to be simple, performant, secure and AI-native.
Features
Beautiful
Sopho is designed to be beautiful and intuitive. Sopho strives to be the best quality product in its category. Deeply inspired by Conversations on Quality.
Integrated Notebook and Dashboard
You no longer have to move between different SQL queries, charts, and dashboards open in different browser tabs to explore data and to create your dashboards. Sopho simplifies this by putting everything in one place using a new abstraction called Canvas, preventing the loss of context and the endless switching.
Shortcuts
Shortcuts are a first-class citizen in the roadmap of Sopho. Currently, Sopho supports shortcuts for global search (Cmd+K), creation of various assets, and for editing cells in the notebook. Shortcuts are integrated wherever possible to save precious time.
Performant
Sopho is built using the latest technologies in the frontend and the backend world. Sopho uses Rust for the backend, React + Vite for the frontend, and PostgreSQL for data storage. Maintainability and performance are the core pillars for the choices of technologies.
Installation
The preferred way for installing and using Sopho is through Docker.
- Run the following command to pull the Docker image:
docker pull ghcr.io/sopho-tech/sopho/sopho:latest
- After the image has been pulled, run the container:
docker run -d -p 8000:8000 \
--name sopho \
-e ADMIN_USERNAME="admin" \
-e ADMIN_PASSWORD="password" \
-e ADMIN_EMAIL="[email protected]" \
-e ADMIN_FULL_NAME="admin admin" \
ghcr.io/sopho-tech/sopho/sopho:latest
The container will use SQLite as the backend database by default. SQLite is not recommended for production usage. Use PostgreSQL for production.
Documentation
For setup guides, configuration, and API reference, see the official documentation.
License
This project is licensed under the GNU Affero General Public License v3.0. See the LICENSE file for details.
Community
Join our Discord server for help with issues, questions, and community discussions.