Shaper is a SQL-first analytics platform designed for creating interactive dashboards and reports. It uses DuckDB as its query engine and allows users to define analytical content directly through SQL rather than a conventional drag-and-drop report builder.
The application is particularly useful for developers and analysts who want to maintain dashboards alongside other project files. Queries describe both the information being analysed and how the results should be presented, making the analytical definitions suitable for version control.
Shaper also supports embedding analytics within other applications. Organisations can build branded dashboards, control access to information and automate the generation of reports while retaining control over their underlying data infrastructure.
This is free and open source software.
Key Features
- Create interactive dashboards using SQL statements.
- DuckDB query engine for analysing connected data.
- Query information from multiple supported data sources.
- Visualise information using charts, tables and other dashboard elements.
- Configurable filters for interactive data exploration.
- Conditional dashboard sections and chart annotations.
- Customisable dashboard appearance and white-label branding.
- Embed analytics through JavaScript and React SDKs.
- Row-level access control using JSON Web Tokens.
- Export reporting results to PDF, PNG, CSV and Excel.
- Schedule SQL tasks for data transformation and reporting.
- Automated alerts and scheduled report distribution.
- Share dashboards through password-protected links.
- Define dashboards as SQL files for version-controlled development.
- Validate dashboard definitions before publication.
- Git-based collaboration and deployment workflows.
Website: github.com/taleshape-com/shaper
Support:
Developer: Taleshape OÜ
License: Mozilla Public License v2.0
Shaper is written in Go and TypeScript. Learn Go with our recommended free books and free tutorials.
Related Software
| Business Intelligence Software | |
|---|---|
| Metabase | Business intelligence and analytics software |
| Grafana | Platform for monitoring and observability |
| Superset | Data visualization and data exploration platform |
| Redash | Explore, query, visualize, and share data |
| Knowage | (formerly SpagoBI) Flexible business intelligence suite |
| ReportServer | Modern and versatile business intelligence platform |
| Apache Zeppelin | Interactive notebooks for data analytics and visualisation |
| KNIME | Konstanz Information Miner |
| JasperReports | A widely used reporting engine |
| Rill | Operational BI tool |
| BIRT Project | Eclipse-based reporting system |
| Querybook | Collaborative SQL editor for querying and exploring large datasets |
| Lightdash | Looker alternative |
| evidence | Code-based alternative to drag-and-drop business intelligence tools |
| Shaper | SQL-first analytics and dashboard platform |
| Frappe Insights | Self-service business intelligence with interactive dashboards |
Read our verdict in the software roundup.
LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |


Please read our Comment Policy before commenting.