index.md

title
Welcome to Evidence

Build polished data products with SQL and Markdown

This demo connects to a local DuckDB file needful_things.duckdb.

Write in Markdown

Evidence renders markdown files into web pages. This page is: [project]/pages/index.md.

Run SQL using Code Fences

select
  date_trunc('month', order_datetime) as order_month,
  count(*) as number_of_orders,
  sum(sales) as sales,
  sum(sales)/count(*) as average_order_value
from orders
where order_datetime >= '2020-01-01'
group by 1 order by 1 desc

In your markdown file, you can include SQL queries in code fences. Evidence will run these queries through your database and return the results to the page.

To see the queries on a page, click the 3-dot menu at the top right of the page and Show Queries. You can see both the SQL and the query results by interacting with the query above.

Visualize Data with Components

Value in Text

Last month customers placed orders. The AOV was .

Big Value

Bar Chart

<BarChart data={orders_by_month} x=order_month y=number_of_orders fillColor="#488f96"

Try: Change the chart to a <LineChart>.

Data Table

More: See all components

Add Interactive Features

The latest version of Evidence includes features that allow you to easily create interactive data visualizations.

Chart with Filter

select
    category
from orders
group by category

select 
    date_trunc('month', order_datetime) as month,
    sum(sales) as sales_usd,
    category
from orders
where category like '${inputs.category}'
and date_part('year', order_datetime) like '${inputs.year}'
group by all
order by sales_usd desc

Share with Evidence Cloud

Evidence Cloud is the easiest way to securely share your project.

• Get your project online
• Authenticate users
• Schedule data refreshes

Deploy to Evidence Cloud →

You can use Netlify, Vercel or another static hosting provider to self-host Evidence.

Get Support

• Message us on Slack
• Read the Docs
• Open an issue on Github