Welcome to the official website for Squirrels, an open-source project framework for building your very own REST APIs for dynamic data analytics!

In modern times, REST APIs are considered the "backbone of the internet". It allows two software programs to communicate with each other and share data across the world.

At the same time, requirements for data analytics are growing in companies across the world. But it often comes down to a few technical data experts to answer the growing number of data questions. For instance, today a company executive may ask for revenue by location for last year, and then tomorrow decide to ask for revenue by day of week for last quarter only. For many organizations, these executives must rely on others to get the information for them rather than being able to retrieve the information themselves (for instance, by clicking a button in a graphical user interface that calls the APIs), even when several of these data queries would take a similar shape but parameterized in different ways.

This is where Squirrels comes in handy. It merges the two worlds of "REST APIs" and "data analytics" together! By creating dynamic datasets (and their parameters) with a low-code framework and exposing them as REST APIs that take query parameters, you can allow others to self-serve the data analytics while having tight control over what they are allowed to query. And it's not just for internal analytics only, it can also be embedded in your customer-facing applications to expose analytics for external users!

Why is it named "Squirrels"?​

First off, it seems to be the trend that many data-relevant tools are named after animals (Pandas, Koalas, Polars, DuckDB, etc.). Not to mention, Squirrels runs on Python, a programming language named after an animal as well.

But more importantly, the phonetics of the word "squirrels" sounds like a blend between SQL and URLs, which encapsulates the purpose of this framework very well.