Business Intelligence

Shaper – SQL-first analytics and dashboard platform

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
MetabaseBusiness intelligence and analytics software
GrafanaPlatform for monitoring and observability
SupersetData visualization and data exploration platform
RedashExplore, query, visualize, and share data
Knowage(formerly SpagoBI) Flexible business intelligence suite
ReportServerModern and versatile business intelligence platform
Apache ZeppelinInteractive notebooks for data analytics and visualisation
KNIMEKonstanz Information Miner
JasperReportsA widely used reporting engine
RillOperational BI tool
BIRT ProjectEclipse-based reporting system
QuerybookCollaborative SQL editor for querying and exploring large datasets
LightdashLooker alternative
evidenceCode-based alternative to drag-and-drop business intelligence tools
ShaperSQL-first analytics and dashboard platform
Frappe InsightsSelf-service business intelligence with interactive dashboards

Read our verdict in the software roundup.


Best Free and Open Source Software 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.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted