Data and databases · Edition No. 8 · 2 Sep 2026

evidence-dev/evidence

Business intelligence as Markdown files with SQL in them, building to a static site — a dashboard Claude Code can write.

← Data and databasesRead the whole edition →

6.9k stars · MIT · @evidence-dev/evidence@40.1.8 (2026-02-06)

Business intelligence as Markdown files with SQL in them, building to a static site — a dashboard Claude Code can write.

Repo detailsthe review · specs · pros & cons · install

What it is

A business-intelligence tool where each page is a Markdown file containing SQL queries and chart components, and the build produces a fast static website. It connects to PostgreSQL, SQLite, CSV files and more.

Why it matters

By the end of this edition your numbers live in four places: Umami's tables, Listmonk's tables, the research SQLite file from 05, and Grasppy's own application database. The question you will actually want to answer — did the video that went out on Tuesday produce signups on Wednesday — spans all of them, and no single tool's dashboard will ever show it. Evidence is the one shape of BI tool that suits you specifically: the whole dashboard is text files in a git repository, which means Claude Code can write and revise it the same way it writes your application, and the output is a static site you can drop on the same nginx that serves everything else.

Stars6.9k
LicenceMIT
Latest@evidence-dev/evidence@40.1.8 (2026-02-06)checked 7 Sep 2026
Written inTypeScript
RunsSelf-hosted on your own server
Setup effort
3 / 5
Payoff
3 / 5
Good
  • Text files in git. No dragging widgets, no clicking through a builder, no state trapped in someone's UI.
  • Static output — nothing to keep running, nothing to secure beyond a password on a directory.
  • Talks to PostgreSQL and SQLite natively, which is exactly the two databases you will have.
Watch for
  • The Node/npm build toolchain is a second ecosystem to keep working next to your Python one, and version drift there is a familiar tax.
  • It queries at build time, so a "live" dashboard means a scheduled rebuild — fine daily, wrong for anything you want to watch in real time.
  • Honestly premature until 04 and Umami are producing data. Read this entry, do not install it this week.
How to get it

Reads your existing PostgreSQL directly (a read-only user, please) and the research.db from 05.

Get the next edition in your inbox

A dozen repositories, opened and checked. The licence read, the last release dated, and the ones that did not make it named with the reason. It is the half most lists leave out.

No tracking pixels. One click to leave. The archive stays free either way.

We use your address to send the edition and nothing else. Confirm by email, leave in one click. How we handle it.