# edp963/davinci

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/edp963-davinci).**

5,002 stars · 1,816 forks · TypeScript · Apache-2.0

## Links

- GitHub: https://github.com/edp963/davinci
- Homepage: https://edp963.github.io/davinci
- awesome-repositories: https://awesome-repositories.com/repository/edp963-davinci.md

## Topics

`dashboard` `data-visualization` `davinci` `display` `react` `typescript`

## Description

Davinci is a business intelligence and data visualization platform used for building interactive dashboards and reports. It functions as a SQL-based dashboard builder and multi-tenant analytics service that connects to databases via JDBC and CSV files to transform raw data into visual components.

The platform is distinguished by its granular security model, which includes row-level and column-level permissions integrated with LDAP and OAuth2 authentication. It also provides an embedded visualization tool that allows secure, parameterized charts and dashboards to be inserted into external applications via URLs and frames.

The system covers a broad range of capabilities, including data modeling with SQL templates, a drag-and-drop layout engine for responsive dashboards, and a wide variety of visualization types such as Sankey diagrams, radar charts, and geographic maps. It further includes automation for scheduling email-based reports and utilizes key-value caching to optimize query performance.

## Tags

### Data & Databases

- [Reporting Tools](https://awesome-repositories.com/f/data-databases/reporting-tools.md) — Provides a complete business intelligence solution for creating visual dashboards and automated data-driven reports.
- [Multiple Y-Axis Configurations](https://awesome-repositories.com/f/data-databases/chart-axes/scale-and-range-configurations/multiple-y-axis-configurations.md) — Supports displaying multiple independent Y-axes on a single chart to compare metrics with different scales. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Connection Establishment](https://awesome-repositories.com/f/data-databases/connection-establishment.md) — Establishes connections to diverse databases using JDBC URLs and credentials for data retrieval. ([source](https://edp963.github.io/davinci/docs/zh/1.1-deployment))
- [Bar Charts](https://awesome-repositories.com/f/data-databases/data-analysis-visualization/analytical-platforms-engines/data-analysis-tools/bar-charts.md) — Includes visual widgets for representing data as vertical or horizontal bar charts with stacking and percentage options. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Pie Charts](https://awesome-repositories.com/f/data-databases/data-analysis-visualization/visualization-frameworks-libraries/chart-components-utilities/pie-charts.md) — Represents proportional distributions using standard pie, doughnut, and Nightingale rose charts. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Data Modeling](https://awesome-repositories.com/f/data-databases/data-modeling.md) — Enables the definition of data models by categorizing fields as dimensions or metrics for visual rendering. ([source](https://edp963.github.io/davinci/docs/zh/2.2-view))
- [SQL Templating Engines](https://awesome-repositories.com/f/data-databases/data-querying/sql-templating-engines.md) — Utilizes SQL templating engines to inject variables into queries for flexible dataset extraction. ([source](https://edp963.github.io/davinci/docs/zh/2.2-view))
- [SQL Data Loading and Transformation](https://awesome-repositories.com/f/data-databases/data-transformation-rules/load-time-transformations/sql-data-loading-and-transformation.md) — Provides a SQL editor to process, convert, and transform data into shared models for consistent analysis. ([source](https://edp963.github.io/davinci/))
- [Data Series Grouping](https://awesome-repositories.com/f/data-databases/data-visualization-charts/data-series-linking/data-series-grouping.md) — Categorizes data into series based on discrete fields to distinguish groups using visual legends. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))
- [Radar Chart Renderers](https://awesome-repositories.com/f/data-databases/data-visualization-charts/radar-chart-renderers.md) — Plots multiple metrics on a radial axis to compare characteristics across different dimensions. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Scatter Charts](https://awesome-repositories.com/f/data-databases/data-visualization-charts/scatter-charts.md) — Visualizes correlations between two metrics across dimensions using two-dimensional scatter plots. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Data Visualization Dashboards](https://awesome-repositories.com/f/data-databases/data-visualization-dashboards.md) — Integrates data visualization widgets into dashboards with options for manual synchronization or automatic polling. ([source](https://edp963.github.io/davinci/docs/zh/2.4-dashboard))
- [Logical Tenant Isolation](https://awesome-repositories.com/f/data-databases/database-orchestration/tenant/database-level-tenant-isolations/data-tenant-isolators/logical-tenant-isolation.md) — Maintains strict data and resource boundaries by grouping users, roles, and projects into isolated organizational units.
- [Dynamic SQL Generators](https://awesome-repositories.com/f/data-databases/dynamic-sql-generators.md) — Generates dynamic SQL by embedding conditional logic and session variables into database templates at runtime.
- [File-Based Data Import](https://awesome-repositories.com/f/data-databases/file-based-data-import.md) — Imports data from diverse JDBC databases and CSV files to serve as the foundation for visualizations. ([source](https://edp963.github.io/davinci/))
- [Flow Diagrams](https://awesome-repositories.com/f/data-databases/flow-diagrams.md) — Visualizes flow and connections between multiple dimensions based on a specific metric using weighted connections. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Funnel Charts](https://awesome-repositories.com/f/data-databases/funnel-charts.md) — Visualizes linear processes and conversion rates by comparing metrics across sequential stages. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Interactive Data Charting](https://awesome-repositories.com/f/data-databases/interactive-data-charting.md) — Provides tools for transforming datasets into interactive visual charts and graphs via a drag-and-drop interface. ([source](https://edp963.github.io/davinci/docs/zh/1.2-quick_start))
- [Multi-Tenant Analytics](https://awesome-repositories.com/f/data-databases/multi-tenant-analytics.md) — Offers a multi-tenant analytics service with isolated organizations and role-based access control.
- [Analytics Drill-Down](https://awesome-repositories.com/f/data-databases/path-configuration/drill-down-paths/analytics-drill-down.md) — Enables data exploration through filtering chart elements and pivoting views across different dimensions. ([source](https://edp963.github.io/davinci/docs/zh/2.4-dashboard))
- [Query Parameterization](https://awesome-repositories.com/f/data-databases/query-parameterization.md) — Provides mechanisms to inject dynamic variables and conditional logic into SQL templates to modify database query results. ([source](https://edp963.github.io/davinci/docs/zh/2.2-view))
- [SQL Query Editors](https://awesome-repositories.com/f/data-databases/sql-query-editors/sql-query-editors.md) — Provides a dedicated SQL editor with syntax highlighting and templates to define data views. ([source](https://cdn.jsdelivr.net/gh/edp963/davinci@dev-0.3/README.md))
- [Dataset](https://awesome-repositories.com/f/data-databases/view-definitions/dataset.md) — Allows users to write and execute SQL queries to define specific datasets for visualization. ([source](https://edp963.github.io/davinci/docs/zh/1.2-quick_start))
- [JDBC Abstraction Layers](https://awesome-repositories.com/f/data-databases/virtual-table-querying/external-table-querying/jdbc-external-table-connectors/jdbc-abstraction-layers.md) — Connects to diverse databases using a common JDBC interface to execute SQL templates and retrieve datasets.
- [Cross-Source Data Integration](https://awesome-repositories.com/f/data-databases/cross-source-data-integration.md) — Integrates and merges datasets from both CSV files and JDBC sources into unified results for visualization. ([source](https://cdn.jsdelivr.net/gh/edp963/davinci@dev-0.3/README.md))
- [Query Result Caching](https://awesome-repositories.com/f/data-databases/data-engineering-infrastructure/caching-performance/caching-strategies/query-result-caching.md) — Saves the output of expensive database queries in a temporary store to reduce latency. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))
- [Cascading Selection Filters](https://awesome-repositories.com/f/data-databases/data-filtering/data-cascade-filters/cascading-selection-filters.md) — The product links multiple controllers so that parent selections filter the available options in dependent child controllers. ([source](https://edp963.github.io/davinci/docs/zh/2.4-dashboard))
- [Query Execution Control](https://awesome-repositories.com/f/data-databases/database-query-execution/query-execution-control.md) — Controls whether data loads automatically or via manual trigger to prevent database overload. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))
- [Dataset Filtering](https://awesome-repositories.com/f/data-databases/dataset-filtering.md) — Restricts datasets using fixed values, conditional logic, and dynamic date ranges to refine visual information. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))
- [Expensive Result Caches](https://awesome-repositories.com/f/data-databases/expensive-result-caches.md) — Caches expensive database query outputs in a temporary layer to reduce latency for repeated requests.
- [Redis Caching Layers](https://awesome-repositories.com/f/data-databases/redis-caching-layers.md) — Utilizes a Redis key-value store to cache commonly accessed data for improved system speed. ([source](https://edp963.github.io/davinci/docs/zh/1.1-deployment))
- [Pivot Table Visualizations](https://awesome-repositories.com/f/data-databases/table-data-processing/pivot-table-aggregators/pivot-table-visualizations.md) — Implements pivot tables that transform data through row and column swapping with color-grouped metrics. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [CSV Data Loaders](https://awesome-repositories.com/f/data-databases/tabular-data-frameworks/csv-data-loaders.md) — Supports uploading CSV files to create new database tables or append data to existing structures. ([source](https://edp963.github.io/davinci/docs/zh/2.1-source))

### User Interface & Experience

- [Interactive Dashboards](https://awesome-repositories.com/f/user-interface-experience/interactive-dashboards.md) — Builds interactive dashboards by arranging visual components with advanced filtering, component linking, and pagination. ([source](https://edp963.github.io/davinci/))
- [Parallel Coordinate Charts](https://awesome-repositories.com/f/user-interface-experience/chart-components/multi-chart-coordination/parallel-coordinate-charts.md) — Plots high-dimensional data across multiple parallel vertical axes to visualize correlations. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Visualization Dashboards](https://awesome-repositories.com/f/user-interface-experience/cross-platform-ui-frameworks/visualization-dashboards.md) — Provides an interactive builder to construct data visualization dashboards using pre-defined components and layouts. ([source](https://cdn.jsdelivr.net/gh/edp963/davinci@dev-0.3/README.md))
- [Line Charts](https://awesome-repositories.com/f/user-interface-experience/data-visualization-tools/data-visualization/specific-chart-types/line-charts.md) — Visualizes trends using a single dimension and one or more metrics with smooth or stepped lines. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Waterfall Charts](https://awesome-repositories.com/f/user-interface-experience/data-visualization-tools/data-visualization/specific-chart-types/stacked-charts/waterfall-charts.md) — Shows the cumulative effect of sequentially introduced positive or negative values via waterfall plots. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Data Visualization Widgets](https://awesome-repositories.com/f/user-interface-experience/data-visualization-widgets.md) — Transforms data models into interactive visualization widgets by applying secondary aggregation and grouping. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))
- [Component Layout Engines](https://awesome-repositories.com/f/user-interface-experience/flexible-grid-layouts/component-layout-engines.md) — Implements a flexible coordinate-based grid system for arranging visual widgets across various screen sizes.
- [Radial Gauge Charts](https://awesome-repositories.com/f/user-interface-experience/gauge-widgets/radial-gauge-charts.md) — Visualizes single metrics against target values using radial dial and pointer gauge charts. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Global Dashboard Controllers](https://awesome-repositories.com/f/user-interface-experience/global-dashboard-controllers.md) — Provides centralized input fields that apply conditional constraints or variable values across multiple components. ([source](https://edp963.github.io/davinci/docs/zh/2.4-dashboard))
- [Dashboard Component Linking](https://awesome-repositories.com/f/user-interface-experience/link-components/dashboard-component-linking.md) — Connects visual components through filtering and group controls to enable coordinated data exploration across a dashboard. ([source](https://cdn.jsdelivr.net/gh/edp963/davinci@dev-0.3/README.md))
- [Flip-Style](https://awesome-repositories.com/f/user-interface-experience/numeric-value-displays/dashboard-metric-displays/flip-style.md) — Displays critical key metrics using customizable fonts and flip-style visual animations. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Unified Visualization Interfaces](https://awesome-repositories.com/f/user-interface-experience/unified-visualization-interfaces.md) — Builds interactive charts and reports to visualize data through a unified interface. ([source](https://github.com/edp963/davinci/blob/master/README-CH.md))
- [Automatic Layout Arrangements](https://awesome-repositories.com/f/user-interface-experience/dashboard-layout-components/automatic-layout-arrangements.md) — Positions and resizes visual elements using a layout that adapts automatically to different screen widths. ([source](https://edp963.github.io/davinci/docs/zh/2.4-dashboard))
- [Dashboard Data Filters](https://awesome-repositories.com/f/user-interface-experience/dashboard-widgets/dashboard-data-filters.md) — Implements local filtering panels on widgets that work in conjunction with global filters to narrow queried data. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))
- [Data Tables](https://awesome-repositories.com/f/user-interface-experience/data-tables/table-data-syncers/data-tables.md) — Provides interactive data tables with multi-level headers, conditional formatting, and pagination for visualizing datasets. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Embedded Data Visualizations](https://awesome-repositories.com/f/user-interface-experience/data-visualization-tools/data-visualization/interactive-presentation-tools/embedded-data-visualizations.md) — Enables inserting secure, parameterized charts and dashboards into external applications via URLs, frames, or scripts. ([source](https://edp963.github.io/davinci/))
- [High-Impact Displays](https://awesome-repositories.com/f/user-interface-experience/high-impact-displays.md) — Creates high-impact displays using free-form layouts and custom styles for presentation and monitoring. ([source](https://edp963.github.io/davinci/docs/zh/2.5-display))
- [Snap-to-Grid Draggable Layouts](https://awesome-repositories.com/f/user-interface-experience/interactive-widgets/draggable-layout-elements/snap-to-grid-draggable-layouts.md) — Provides a drag-and-drop layout engine where elements snap to a grid for precise alignment across different screen sizes. ([source](https://edp963.github.io/davinci/docs/zh/2.5-display))
- [Large Screen Layouts](https://awesome-repositories.com/f/user-interface-experience/responsive-layout-adapters/adaptive-ui-layouts/large-screen-layouts.md) — Creates high-fidelity displays with custom layering and adaptive layouts for specialized large-screen monitoring scenarios. ([source](https://edp963.github.io/davinci/))
- [Chart Visual Style Customizations](https://awesome-repositories.com/f/user-interface-experience/visual-style-customization/chart-visual-style-customizations.md) — Allows customization of chart aesthetics through form-based settings and coordinate system reference lines. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))

### Web Development

- [Drag-and-Drop Builders](https://awesome-repositories.com/f/web-development/report-designers/drag-and-drop-builders.md) — Features a web-based designer that allows building complex reports by dragging components and binding data via SQL. ([source](https://edp963.github.io/davinci/))
- [Dashboard Builders](https://awesome-repositories.com/f/web-development/report-designers/drag-and-drop-builders/dashboard-builders.md) — Provides a drag-and-drop interface for building interactive dashboards using parameterized SQL queries.
- [Responsive Layout Adaptation](https://awesome-repositories.com/f/web-development/responsive-layout-adaptation.md) — Adjusts the display of visual components to fit different screen sizes across monitors, tablets, and mobile devices. ([source](https://edp963.github.io/davinci/))

### Part of an Awesome List

- [Geographic Map Visualizations](https://awesome-repositories.com/f/awesome-lists/media/visualization-and-mapping/geographic-map-visualizations.md) — Visualizes spatial data using bubble, heat, or flight path maps based on geographic dimensions. ([source](https://edp963.github.io/davinci/docs/zh/5.1-chart_config))
- [Report Designers](https://awesome-repositories.com/f/awesome-lists/devtools/drag-and-drop/report-designers.md) — Arranges multiple visual components onto a layout grid using a visual designer to create reporting portals. ([source](https://edp963.github.io/davinci/docs/zh/1.2-quick_start))

### Business & Productivity Software

- [Membership Management](https://awesome-repositories.com/f/business-productivity-software/group-management/membership-management.md) — Manages organization membership by inviting users and assigning roles to regulate access to resources. ([source](https://edp963.github.io/davinci/docs/zh/3.2-member))
- [JDBC Data Visualization Platforms](https://awesome-repositories.com/f/business-productivity-software/jdbc-data-visualization-platforms.md) — Implements a platform for building interactive reports by connecting to databases via JDBC and CSV files.
- [Dashboard Snapshot Generation](https://awesome-repositories.com/f/business-productivity-software/dashboard-snapshot-generation.md) — Generates images of visualization layouts to be included in the body of automated email notifications. ([source](https://edp963.github.io/davinci/docs/zh/1.1-deployment))

### Development Tools & Productivity

- [Project Resource Isolators](https://awesome-repositories.com/f/development-tools-productivity/project-resource-managers/project-resource-isolators.md) — Groups data sources, views, and tasks into isolated project units to manage related resources collectively. ([source](https://edp963.github.io/davinci/docs/zh/3.4-project))
- [Reporting Portals](https://awesome-repositories.com/f/development-tools-productivity/dashboard-portals/reporting-portals.md) — Creates a high-level entry point for applications with folder organization, searchable menus, and role-based visibility. ([source](https://edp963.github.io/davinci/docs/zh/2.4-dashboard))

### Security & Cryptography

- [Row Level Security](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/data-resource-permissions/row-level-security.md) — Restricts database query results by applying conditional constraints based on the authenticated user identity.
- [Multi-Tenant Identity Management](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/identity-role-management/multi-tenant-identity-management.md) — Groups projects, roles, and users into isolated organizational units to manage multi-tenant environments. ([source](https://edp963.github.io/davinci/docs/zh/3.1-organization))
- [User Role Management](https://awesome-repositories.com/f/security-cryptography/identity-access-management/identity-management/user-management/user-role-management.md) — Provides tools for defining reusable permission sets and assigning them to users to control access to visualizations. ([source](https://edp963.github.io/davinci/docs/zh/3.3-role))
- [LDAP Authentication](https://awesome-repositories.com/f/security-cryptography/ldap-authentication.md) — Integrates with LDAP directory services to verify user identities and manage centralized authentication. ([source](https://edp963.github.io/davinci/docs/zh/1.1-deployment))
- [Tenant Organizational Hierarchies](https://awesome-repositories.com/f/security-cryptography/multi-tenant-hierarchy-organizers/tenant-organizational-hierarchies.md) — Organizes users into isolated tenant groups where individuals can define their own organizational hierarchies. ([source](https://edp963.github.io/davinci/))
- [OAuth2 Integration](https://awesome-repositories.com/f/security-cryptography/oauth2-integration.md) — Delegates user authentication to LDAP and OAuth2 identity providers to manage secure single sign-on workflows.
- [Role-Based Access Control](https://awesome-repositories.com/f/security-cryptography/role-based-access-control.md) — Assigns users to specific roles within an organization to govern permissions across projects. ([source](https://edp963.github.io/davinci/docs/zh/3.1-organization))
- [Data Column Visibility Controls](https://awesome-repositories.com/f/security-cryptography/role-based-access-control/tab-access-restrictions/attribute-visibility-controls/log-visibility-controls/case-visibility-controls/data-column-visibility-controls.md) — Controls which data columns are visible to specific user roles to ensure data privacy. ([source](https://edp963.github.io/davinci/docs/zh/2.2-view))
- [Project Role Definitions](https://awesome-repositories.com/f/security-cryptography/role-based-access-control/workspace-role-assignments/role-permission-listings/custom-role-definitions/project-role-definitions.md) — Creates custom permission sets assigned to members to control capabilities across different projects. ([source](https://edp963.github.io/davinci/docs/zh/3.2-member))
- [Row and Column Access Controls](https://awesome-repositories.com/f/security-cryptography/row-and-column-access-controls.md) — Implements fine-grained security that restricts data visibility at the individual row and column levels. ([source](https://edp963.github.io/davinci/))
- [Single Sign-On Integrations](https://awesome-repositories.com/f/security-cryptography/single-sign-on-integrations.md) — Connects to external OAuth2 providers to enable centralized single sign-on for user authentication. ([source](https://edp963.github.io/davinci/docs/zh/1.1-deployment))
- [Project Access Controls](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/access-control-models/permission-based-security/access-control-policies/project-access-controls.md) — Configures project-level permissions, including the ability to create projects and visibility settings. ([source](https://edp963.github.io/davinci/docs/zh/3.1-organization))

### Artificial Intelligence & ML

- [Scheduled Report Deliveries](https://awesome-repositories.com/f/artificial-intelligence-ml/agent-architectures/orchestration-engines/ai-agent/runtime-execution-control/recurring-agent-scheduling/recurring-task-scheduling/report-execution-schedulers/scheduled-report-deliveries.md) — Schedules the delivery of dashboard snapshots or data exports via email and messaging apps on a recurring timetable. ([source](https://edp963.github.io/davinci/docs/zh/2.6-schedule))

### Scientific & Mathematical Computing

- [Numeric Data Formatting](https://awesome-repositories.com/f/scientific-mathematical-computing/numeric-data-formatting.md) — Performs mathematical aggregations on numeric fields and formats them as currencies, percentages, or scientific notation. ([source](https://edp963.github.io/davinci/docs/zh/2.3-widget))

### Software Engineering & Architecture

- [Project Member Assignments](https://awesome-repositories.com/f/software-engineering-architecture/project-management-governance/project-management/project-member-assignments.md) — Designates specific members as project administrators to grant full control over specific assets. ([source](https://edp963.github.io/davinci/docs/zh/3.2-member))
- [Project Visibility Control](https://awesome-repositories.com/f/software-engineering-architecture/project-management-governance/project-management/project-visibility-control.md) — Restricts project access to organization members or authorized roles to protect sensitive data. ([source](https://edp963.github.io/davinci/docs/zh/3.4-project))

### System Administration & Monitoring

- [Dashboard Widgets](https://awesome-repositories.com/f/system-administration-monitoring/dashboard-widgets.md) — Integrates interactive widgets into the canvas with support for manual updates and automated data polling. ([source](https://edp963.github.io/davinci/docs/zh/2.5-display))