I got tired of the increasing gap between the open source and closed source products for business intelligence and data analytics in terms of product quality, performance and AI features. Hence, I started building Sopho.

Currently, Sopho has the following 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

- Documentation: live Fumadocs-based docs site

There is a Docker image with sample data, dashboards and notebook which works out of the box. I am planning to spend some time on the AI features next to get the bases right.

Would love some feedback!