Shaper

Shaper is a web analytics program for building data dashboards entirely in SQL. It uses DuckDB as its underlying technology, keeping dashboard development within a SQL-based workflow. Users create dashboards with SQL, while DuckDB provides the foundation for the process. Shaper is intended for people and teams who want to create web analytics dashboards without moving away from SQL, particularly those already comfortable working in a SQL-centered environment. Shaper can be used as an open source replacement for Google Analytics. Its defining difference is its development model: dashboards are built using SQL and powered by DuckDB. This also creates an important limitation for some users. Because the dashboard-building process is entirely SQL-based, Shaper may not suit people who do not work with SQL or who prefer to create dashboards through a different kind of workflow.