evidenceBusiness intelligence as code: build fast, interactive data visualizations in SQL and markdown

evidence

Evidence is an open-source business intelligence platform that lets you build interactive data visualizations and reports using SQL and markdown. It offers a code-based alternative to traditional drag-and-drop BI tools, enabling faster development and version control of data products.

Key Features

• SQL-Driven Queries: Write SQL statements directly in markdown files to query your data sources
• Interactive Components: Render charts and visualizations automatically from query results
• Templated Pages: Generate multiple pages from single markdown templates with loops and conditional logic
• Self-Hosted Deployment: Deploy to Netlify, Vercel, or your own infrastructure as a static site

Use Cases

• Exploratory Data Analysis: Quickly investigate and visualize data patterns without complex setup
• Internal Dashboards: Create version-controlled, collaborative BI reports for teams
• Data Storytelling: Combine SQL insights with markdown narratives for comprehensive reports
• Rapid Dashboard Development: Build and iterate on dashboards using familiar tools like VSCode

Who Is It For

Evidence is designed for data engineers, analysts, and developers who prefer writing code over using visual builders. It's ideal for teams that value version control, reproducibility, and the flexibility of code-based workflows.