Skip to main content

Squirrels

Create REST APIs for Data Analytics

Build feature-rich data analytics applications with a powerful Python framework that simplifies connecting to data sources, modeling data, and creating interactive datasets or dashboards.

# Install Squirrels and initialize a new project from a new directory
cd my-squirrels-project
pip install squirrels
sqrl new --curr-dir

# Build static models and run the API server
sqrl build
sqrl run

Create Data Applications in Minutes

Squirrels handles the complexity, you focus on your analytics

🚀

Easy Installation & Setup

Run pip install squirrels and sqrl new to bootstrap a new Squirrels project in seconds.

🛠️

Connect & Model

Connect to any database and model your data with Jinja-templated SQL or Python. Reference and combine models across data sources.

🤖

AI Integration

Create dataset APIs that AI agents can interactive with to provide valuable insights. Use the dataset APIs as guardrails for how AI agents can query your data.

🔒

Secure & Scale

Built-in user management, access controls, and token authentication. Scale your analytics from prototype to production.

🔌

Multiple Data Connections

Specify connections to multiple databases or data warehouses in a single project! Connect to PostgreSQL, BigQuery, Snowflake, and more.

⚙️

Customizable Parameters

Create parameters with Python or YAML. Build interactive datasets or dashboards that respond to user inputs and parameter selections.

🔀

Flexible Data Modeling

Write data models in Jinja-templated SQL or Python. Create static models for offline data or dynamic models for real-time processing.

📦

Static Data Models

Define sources from databases, use seeds from CSV files, or create builds with SQL/Python that execute offline and reference other static models.

Dynamic Data Models

Create dbview models that run on external databases or federate models that can combine data from multiple sources in a temporary in-memory database.

🛒

Configurable Output Datasets

Define datasets (usable by AI agents or visualizations) in YAML by specifying target models, applicable parameters, and access controls for security.

📈

Visualization Freedom

Create dashboards using your favorite Python visualization libraries like Plotly, Matplotlib, Altair, or any other library you prefer.

🖥️

Simple Deployment

Run sqrl build to pre-build static models and sqrl run to activate the API server with built-in user management.