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.
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.
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.
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.
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.
