Open-source business intelligence tool from Frappe for building queries, charts and dashboards without writing SQL.
- Stars
- 104
- Forks
- 14
- Open issues
- 6
- Last commit
- 19 hours ago
What is it?
Visivo is a business intelligence tool where dashboards are defined as code. Data sources, models, a semantic layer of metrics and dimensions, insights, charts and dashboards are all written as YAML files that live in git. Changes can be reviewed as branches and pull requests, and a CI workflow can run queries and publish a preview stage.
Running visivo serve starts a local server that watches project files and rebuilds on save, with a browser workspace for exploring sources, drafting insights, laying out dashboards and committing changes back to YAML. Interactive inputs such as dropdowns and sliders filter charts in the browser through DuckDB-WASM, without querying the warehouse again.
Visivo also exposes an MCP server and a built-in agent. Both work over the same project definitions, and every write they make lands as a draft for the user to review before committing. The project supports PostgreSQL, MySQL, Snowflake, BigQuery, DuckDB, CSV and other sources, and offers dozens of Plotly chart types.
Key features
- 01Defines sources, models, metrics and dashboards in YAML files stored in git.
- 02Local dev server rebuilds and reloads on file save.
- 03Browser workspace for drag-and-drop dashboard layout and editing.
- 04Browser-side interactive filters powered by DuckDB-WASM.
- 05MCP server and built-in agent that write drafts for user review.
- 06Supports many SQL sources and dozens of Plotly chart types.
Use cases
- Versioning BI dashboards and reviewing changes in pull requests.
- Letting analysts or AI agents draft charts against a shared metric definition.
- Building dashboards on top of an existing dbt project.
- Publishing static dashboards to a web host from pre-computed query results.
Quick start
- 1
Install the Python package
pip install visivo - 2
Create an example project and start the dev server
visivo init --example ev-sales
Things to know
- Requires Python 3.12 or newer for the pip install route.
- Licensed under GPL-3.0, a copyleft license that requires derivative works to be open-sourced under the same terms.
- Telemetry is collected by default and must be turned off manually if unwanted.
Topics
FAQ
- What is visivo?
- BI as code: define data sources, a semantic layer and dashboards in YAML, with local dev server, PR review and an MCP server for AI agents. Visivo is a business intelligence tool where dashboards are defined as code. Data sources, models, a semantic layer of metrics and dimensions, insights, charts and dashboards are all written as YAML files that live in git. Changes can be reviewed as branches and pull requests, and a CI workflow can run queries and publish a preview stage.
- Is visivo free to use? What license does it have?
- visivo is open source under the GPL-3.0 license. Check the license terms before using it in commercial products.
- Is visivo still maintained?
- Actively maintained. The last commit to visivo was on Oct 21, 2026.
- What can I use visivo for?
- Versioning BI dashboards and reviewing changes in pull requests. Letting analysts or AI agents draft charts against a shared metric definition. Building dashboards on top of an existing dbt project. Publishing static dashboards to a web host from pre-computed query results.
- How do I install visivo?
- Install the Python package: pip install visivo Create an example project and start the dev server: visivo init --example ev-sales
- Where can I get visivo?
- The source code and installation instructions are on GitHub: https://github.com/visivo-io/visivo
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
Open-source business intelligence tool that lets anyone in a company ask questions of their data without writing SQL, with dashboards and embedded analytics.
Open-source browser-based BI tool for querying, visualizing, and sharing data from many SQL and NoSQL data sources.
Apache Superset is a self-service business intelligence web app for exploring data, building charts, dashboards and running SQL against many databases.
Open-source, code-based BI tool that builds interactive data reports and dashboards from SQL and markdown.
Open-source, self-hosted tool for building SQL-based metrics and shareable documents and dashboards for teams.