Evidence
BUSINESS INTELLIGENCE
Evidence is an open-source analytics tool that allows data teams to create and share reports using SQL and Markdown. It is designed to enable seamless collaboration and real-time data analysis, offering features like version control, interactive dashboards, and automated reporting. Evidence leverages a simple, intuitive interface to help analysts and engineers convert raw data into actionable insights without extensive coding.
Evidence + MotherDuck
Evidence integrates with MotherDuck by connecting directly to the MotherDuck cloud data warehouse. This allows users to run SQL queries on their data stored in MotherDuck, enabling them to build and share interactive reports and dashboards with real-time data fetched from the DuckDB-based backend. The integration ensures that data analysts and engineers can leverage the scalability and speed of MotherDuck while using Evidence's user-friendly reporting tools.
FAQS
What is Evidence and how does it work with MotherDuck?
Evidence is an open source, code-based alternative to drag-and-drop BI tools. It lets you build analytics dashboards using SQL queries and markdown formatting. With MotherDuck integration, you can query your cloud data directly from Evidence pages, combining the power of serverless analytics with beautiful, version-controlled reports.
How do I connect Evidence to MotherDuck?
After installing Evidence from their starter template, access settings at http://localhost:3000/settings, select DuckDB as the connection type, and set the filename to 'md:?motherduck_token=xxxx' (replacing xxxx with your access token). Set the extension to 'No extension' and save. See our Evidence documentation for complete setup instructions.
Can I use Evidence for production dashboards with MotherDuck?
Yes, Evidence supports production deployments with MotherDuck. Set two environment variables in your deployment: EVIDENCE_DUCKDB_FILENAME='md:?motherduck_token=xxxx' and EVIDENCE_DATABASE=duckdb. This allows Evidence to connect to your MotherDuck databases in production while keeping your token secure.
What can I build with Evidence and MotherDuck?
You can create markdown-based pages with embedded SQL queries, display query results dynamically, and build polished data products combining code and documentation. Evidence renders your SQL results as formatted lists, tables, and charts—all powered by MotherDuck's fast serverless queries. It's ideal for data teams who prefer code over drag-and-drop interfaces.
