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.