The first version of Sopho is out: Open Source Business Intelligence Platform
Started building an open source Business Intelligence (BI) platform around March, 2025. Yesterday, I finally released a fully working version of it. It can be used out of the box with its Docker image. It is free with no licensing catches and can be hosted anywhere.
Why ?
Existing closed source Business Intelligence (BI) platforms are very nicely tailored products but is expensive and not open source.
Existing open source BI platforms are not so nicely tailored compared to their close source competitors. They also have dual licenses even though they are open source.
Wanted to introduce a new paradigm where Dashboards and Notebooks live together.
Features
Canvas: integrated notebook and dashboard in one place
Chart Cells: configurable bar, line, pie, and metric charts for data visualization
SQL Cells: write and execute SQL powered by CodeMirror editor and TanStack Table
Keyboard Shortcuts: global search (Cmd+K) and notebook editing shortcuts
Connections: PostgreSQL, Supabase, and SQLite with encrypted credential storage
Authentication: username/password with session-based access and refresh tokens
Deployment: Docker image with configurable environment variables
Demo: pre-built demo data and canvas
Future Plan
Now, I am going to focus on some much needed AI features now so you can talk to your data in natural language, and build dashboards with any AI provider of your choice.
Links
Website: sopho.io
