evidence-dev/evidence
Evidence
Features
- SQL-Embedded Static Sites - Compiles markdown with embedded SQL queries into a static website of interactive data reports.
- US State - Displays a color-coded map of US states based on a numeric column, with options for color scales, legends, and clickable links.
- Markdown Page Directories - Converts markdown files in the pages directory into web pages with file-path-based URLs.
- SQL-Embedded Markdown Processors - Transforms markdown files with embedded SQL queries into static HTML pages during the build process.
- Static Site Generation - Generates a full HTML site from markdown and SQL queries for instant page loads.
- Data-Cached Static Site Generators - Builds a full HTML site from markdown and SQL queries, caching query results for fast page loads.
- SQL-Embedded Static Site Generators - Compiles markdown with embedded SQL queries into a static website with interactive charts and tables.
- Choropleth Maps - Displays a choropleth map that shades geographic areas based on a numeric metric, enabling visual comparison across regions.
- Multi-Value Column Filters - Lets users pick several rows within the same column, producing a combined filter condition for more flexible data exploration.
- Data Query Filters - Provides dropdowns, sliders, checkboxes, and date pickers to filter query results dynamically.
- UI-Driven SQL Filters - Accepts user selections from UI components and injects them into SQL WHERE clauses to dynamically change query results.
- URL-Path Query Injections - Injects a value from the page's URL path into SQL queries so each generated page shows filtered data.
- Data Reporting - Builds data-driven reports and dashboards by running SQL queries and rendering results as visual components.
- SQL-Powered Static Site Generators - Combines markdown documents with embedded SQL queries to produce static websites serving as interactive data reports.
- Data Source Connectivity Tools - Connects to SQL databases, flat files, and APIs by entering credentials through a settings UI or a configuration file.
- Multi-Source Data Integration - Connecting to SQL databases, CSV files, and APIs from a single project to feed reports with data from multiple sources.
- Field Definitions - Defines the configuration fields a data source exposes, including type, validation, and UI hints, so users can connect to their database.
- Bubble Charts - Plots data points where x position, y position, and bubble size each represent a different metric for a category.
- Sized Bubble Maps - Displays proportional circles at geographic coordinates, with size and color driven by query values.
- Scatter Charts - Plots two numeric columns against each other as points on a Cartesian grid to reveal correlation or distribution patterns.
- Time-Series Chart Renderers - Plots one or more metrics over time on a shared x-axis, supporting large datasets and multiple series.
- Markdown-Embedded SQL Executions - Runs SQL code inside fenced code blocks and displays the results as a table on the page.
- Extractions - Runs a command to pull data from connected sources and stores it in a common Parquet format for SQL querying.
- Query Result Visualizers - Displays the output of SQL queries as interactive charts, graphs, and tables using a built-in component library.
- Embedded SQL Query Engines - Runs SQL queries directly against connected data sources using DuckDB as the embedded query engine.
- SQL Query Sources - Defines which data to extract from SQL sources by placing .sql files in the source folder.
- SQL Charting - Creates bar charts and other chart types from SQL query results to show trends and distributions.
- Version Control - Manages report source code with standard IDE, version control, and CI/CD tools for collaborative development.
- Hot Reloading - Provides automatic browser reload on markdown file saves for instant development feedback.
- SQL-Executing - Creates BI dashboards from markdown files that execute SQL queries and generate charts and tables.
- Open Source Tooling - Provides an open-source platform for building data reports and dashboards using SQL and markdown.
- Data-Driven Page Generators - Creates one page per row in a SQL query result using a markdown template with bracketed filenames.
- Template-Based Page Generators - Creates multiple pages from a single markdown template by iterating over query results and dynamic file name segments.
- Data-Driven Visibility Toggles - Shows or hides sections of a report based on data values using if/else logic.
- Plugin Installations - Adds a new data source type by installing and registering a plugin, then configuring connection settings in the UI.
- Environment Switching - Reads environment variables to connect to different databases, schemas, or accounts per deployment target.
- Multi-Layer Map Compositions - Combines area, point, and bubble layers on a single map to visualize geographic data from SQL queries.
- Point Maps - Renders a set of geographic points on an interactive map, optionally color-coded by a metric value.
- Overlaid Chart Combinations - Overlays bars, lines, areas, scatter points, and bubbles on a single chart to compare different metrics together.
- Svelte Component Plugins - Packages reusable UI components into an installable npm plugin so other projects can import and use them.
- Database Credential Configurations - Configures secure database connection strings for production using prefixed environment variables.
- Svelte Component Plugin Systems - Extends the application by registering installable npm packages that provide reusable Svelte components.
- Query-Bound Chart Renderers - Uses built-in components to create charts and visual elements directly from query results.
- Click-to-Filter Dimension Selectors - Generates a SQL WHERE clause from selected dimension values, allowing users to filter query results by clicking on table rows.
- Line Charts - Plots one or more data series as connected points to show trends over a continuous axis.
- Query Result Iterators - Repeats content for each row of a dataset, enabling dynamic lists or tables.
- Interactive Table Components - Renders query results as an interactive data table that can be filtered, sorted, and have columns selected.
- SQL-Bound Dropdown Filters - Creates a dropdown that lets users pick from a list of options, and the selected value can filter SQL queries or appear in markdown.
- Apache ECharts Integrations - Renders interactive charts by passing query results to the ECharts library with customizable options and theming.
- File-System Based Routers - Maps the file system structure under the pages directory directly to URL paths for page organization.
- Heatmap Visualization - Visualizes a matrix of values as colored cells to reveal patterns across two categorical axes.
- Box Plots - Summarizes data distribution using boxes and whiskers to show quartiles and outliers.
- Axis Label Formatters - Applies custom number and date formats to x, y, and size axes independently.
- Scale and Range Configurations - Sets linear or logarithmic scale and explicit min/max bounds for either axis.
- Column Value Aggregations - Computes and displays summary statistics like sum, average, min, median, or max from a query column.
- Funnel Visualizations - Displays a single metric across sequential stages to show how values change through a process.
- Bar Charts - Displays categorical data as vertical or horizontal bars with stacking and grouping.
- Bar Value Labels - Shows numeric labels on or beside bars with configurable font size, color, and format.
- Chart Annotations - Provides reference lines and shaded regions to highlight thresholds and ranges on charts.
- Histogram Plotters - Displays how a metric's values are spread across continuous buckets, aggregating raw data into a histogram chart.
- Data Refresh Scheduling - Runs the deployment workflow on a recurring schedule defined by a cron expression in the workflow file.
- Bubble Style Customizers - Controls the shape, opacity, outline, and color of bubbles, including per-series color assignment.
- Geographic - Plots data points as scaled bubbles on an interactive map for metric comparison across locations.
- Categorical Comparison Charts - Compares a numeric metric across categorical groups with single and multi-series layouts.
- Compact Inline Charts - Displays a single metric over time in a small, inline chart using line, area, or bar styles.
- SQL Query Execution - Runs SQL queries whose text is fixed at component creation time and executes when the query loader mounts.
- Dynamic SQL Query Executions - Runs SQL queries whose text changes in response to user input or component state for interactive components.
- Flow Diagrams - Displays how a metric moves between categories using linked nodes and weighted connections.
- Multi-Level - Links nodes across multiple levels by unioning query results so flows chain through intermediate categories
- Funnel Charts - Shows sequential reduction across stages with side-aligned layout for comparing step values.
- Data Source Environment Configurations - Separates development and production data sources for safe query testing.
- Site Redeployment Schedulers - Triggers a redeployment on a recurring schedule by adding a cron trigger to the workflow file.
- Markdown Snippet Inclusions - Includes partial markdown files to share common content across multiple report pages.
- Query Error Build Failures - Fails the build on SQL query errors to prevent broken reports from deploying.
- Data-Driven Report Generators - Generates report sections by looping over data and applying conditions and templates to produce structured output.
- Basemap Integrations - Replaces default map tile layers with custom basemap URLs for visual styling.
- Area Charts - Renders multi-series area charts emphasizing changes over time.
- Mixed Chart Types - Supports combining multiple chart types within a single coordinate system.
- Individual Series Customizations - Overrides visual properties like color and line style per series in mixed-type charts.
- Custom ECharts Embedders - Embeds arbitrary ECharts configurations for chart types not covered by built-in components.
- Categorical Point Groupers - Splits data points into colored series based on a categorical column for visual distinction.
- Map Legend Styling - Displays categorical or scalar map legends with configurable position and color palettes.
- Map Tile Configurations - Configures custom map tile URLs and attribution text for basemap rendering.
- Geographic Visualization Tools - Plots points, bubbles, and choropleth layers on interactive maps for geographic metric comparison.
- Choropleth Maps - Renders a choropleth layer by binding query data to GeoJSON features using a matching identifier.
- Environment Variable-Based Configuration - Reads database credentials and other settings from prefixed environment variables at build time for secure configuration.
- Plugin Component Aliases - Maps a component from a plugin to a different name for use in markdown files.
- Data-Fetching SPAs - Renders reports as client-side SPAs that fetch data on demand for faster builds.
- Metric Value Comparisons - Displays a percentage change or raw difference alongside the primary value to show performance against a prior period.
- App Visual Identity Customizers - Replaces the default logo, title, and favicon with custom assets to match the organization's visual identity.
- Activity Heatmaps - Displays daily values as colored cells on a calendar grid, supporting multi-year spans.
- Chart Axis Configurations - Controls axis titles, tick marks, gridlines, scale type, and label formatting for both primary and secondary axes.
- Dual Axis Configurations - Provides a dual-axis chart configuration that plots series on independent secondary y-axes.
- Chart Legends - Displays a title, subtitle, and a legend to identify series within the chart.
- Data Value Labels - Displays numeric labels on chart series with configurable font size, position, color, and format.
- Bar Style Customizers - Sets bar fill color, opacity, outline width and color, and applies custom color palettes or per-series colors.
- Palette Configurations - Configures a list of colors for data series in charts, with automatic reuse for extra series.
- Scale Configurations - Configures a gradient of colors for continuous data ranges in charts.
- Conditional Rendering Logic - Uses loops and conditionals in markdown to show or hide content based on query results and user context.
- Contextual Note Displays - Shows styled text alongside content to provide supplementary information or clarification without disrupting the main narrative.
- Content Embedding Tools - Displays third-party media like videos or maps inside a page by wrapping a URL in a responsive container with configurable dimensions and borders.
- Chart Synchronization - Connects multiple charts so their tooltips synchronize when hovering over data points.
- Multi-Series Charting - Supports stacking, grouping, and percentage-stacking multiple series in bar charts.
- Axis Label Formatters - Applies number, date, or custom string formatting to x-axis and y-axis tick labels independently.
- Plugin - Replaces a component from one plugin with a component from another plugin to customize the user interface.
- Tooltip Configurations - Provides configurable tooltip fields, formatting, and styling for map markers.
- Interactive Tooltips - Provides interactive tooltips that show data details on hover, with a static SVG fallback.
- Map Point Navigators - Opens a URL when a user clicks a point on a map, enabling drill-down navigation.
- Map Click Navigations - Navigates to specified URLs when users click map regions or bubbles.
- Map Display Options - Configures map initial center, zoom, height, title, and subtitle for display.
- Map Point Detail Navigations - Opens URLs when clicking map bubbles for drill-down navigation to related reports.
- Map Report Inputs - Sets named input variables from map clicks to drive downstream queries and content.
- Map Selection Inputs - Uses map clicks as input to set page variables and filter other components.
- Numeric Value Displays - Shows a formatted value from a specified row and column of a query result with aggregation support.
- Dashboard Metric Displays - Shows a prominent numeric value on a dashboard card with optional comparison indicator and sparkline chart.
- Separate Light and Dark Palettes - Defines separate color palettes, scales, and UI tokens for light and dark appearance modes.
- Multi-Select Dropdowns - Allows users to select multiple options from a dropdown, returning a list that can be used with SQL's IN operator for filtering.
- Visibility Controls - Controls which pages appear in the sidebar, hides the sidebar entirely, or sets the depth of nested pages shown.
- CSS Styling - Applies Tailwind CSS classes to HTML elements in markdown to override default styling.
- Default Appearance Modes - Chooses between light, dark, or system-preferred appearance for the application.
- Tabs - Groups related content into tabbed sections for switching between views without leaving the page.
- Chart Appearance Customizers - Adjusts colors, axis labels, gridlines, padding, and series-specific palettes to control chart visual style.
- Map Appearance Customizations - Customizes map appearance including basemap tiles, bubble colors, borders, and legend position.
- Point Appearance Customizers - Adjusts shape, size, opacity, outline, and fill color of scatter plot points.
- Text Filters - Accepts user-typed text and applies it as a filter to narrow down displayed data.
- UI Color Managers - Modifies a fixed set of color tokens for all application UI components.
- Value Formatting Tags - Applies Excel-style, built-in, or custom number formats to control how values appear in reports.
- Custom ECharts Rendering Options - Ships a component that accepts arbitrary ECharts options for advanced chart customization.
- Custom ECharts Overrides - Passes custom ECharts options to override or extend the default chart configuration for fine-grained visual customization.
- Custom Domain Hosting - Maps a personal domain name to the deployed site so it is accessible at a branded URL.
- Nested Templated Page Generators - Organises generated pages into subdirectories using bracketed folder names for multi-level URL structures.
- Dashboards and BI - BI platform using SQL and Markdown for reports.
- Database Management - Code-based BI tool for rendering SQL reports as websites.
- Data Visualization - Business intelligence system built with SQL and Markdown.
