AnoFox

AI-Powered S&OP.
Brutally Effective.

Harness the power of high-performance statistics, anomaly detection, and global forecasting models to transform your Sales & Operations Planning.

SQL_IS_THE_API.exe

anofox-tabular

Audit & Guard

Validate emails, VAT IDs, and amounts before they corrupt your forecast. Detect anomalies and profile data health in a single SQL query.

// Validate business data

SELECT anofox_vat_is_valid(vat_id) FROM demands;
anofox-forecast

Forecast with Confidence

Generate 31 forecasting models with automatic seasonality detection. Handle intermittent demand with multiple algorithms—all in SQL.

// Generate 12-month forecast

SELECT TS_FORECAST(sales_table, 'date', 'amount', 'AutoETS', 12) FROM demands;
anofox-statistics

Analyze & Optimize

Run regression analysis, hypothesis testing, and statistical inference on demand. Understand what drives your business with inference tools.

// Analyze price elasticity

SELECT anofox_statistics_ols('demand', ['price', 'marketing'], 'sales') FROM demands;
anofox-tabular

Monitor Data Quality

Continuous data profiling and quality metrics. Detect schema drift, outliers, and data entry errors before they reach your forecast.

// Profile data quality

SELECT anofox_profile_table('orders', sample_size=10000) FROM demands;
anofox-forecast

Master Complex Patterns

Handle multiple seasonalities, promotions, and structural breaks. AutoML models adapt to real-world complexity automatically.

// Forecast with promotions

SELECT TS_FORECAST(sales_table, 'date', 'qty', 'AutoETS', 13, {'with_promotions': true}) FROM demands;
anofox-statistics

Test Causation

Isolate causal relationships with multivariate regression. Test hypotheses about market drivers and validate pricing strategies.

// Test promotion impact

SELECT anofox_statistics_diagnostics('demand', 'multi_regression_results') FROM demands;

A Brutally Efficient 3-Stage Workflow

Transform raw data into a precise S&OP plan through our battle-tested pipeline, designed for clarity and decisive action.

STAGE 1: AUDIT & GUARD

Validate Data Quality

Tabular extension validates every row. Email, VAT, phone—everything checked. Anomaly detection flags suspicious data before it corrupts your forecast.

STAGE 2: FORECAST

Generate Demand Plans

Forecast extension predicts future demand with 31 models. Automatic seasonality detection handles weekly, monthly, and yearly patterns—no tuning required.

STAGE 3: ANALYZE & OPTIMIZE

Analyze Root Causes

Statistics extension runs regression analysis to understand *why*. Quantify price elasticity, marketing ROI, and market drivers with statistical inference.

The Complete S&OP Pipeline

Data flows through three specialized stages, each powered by a DuckDB extension. From raw data to strategic insights—in SQL.

Raw DataERP, CRM, Data Lake
Audit & GuardValidate, Detect Anomalies
ForecastPredict Demand
Analyze & OptimizeUnderstand Drivers
InsightsBI, Dashboards, Planning

The Unified Query

-- One query, three stages, complete S&OP pipeline
WITH stage1 AS (
SELECT * FROM orders
WHERE anofox_vat_is_valid(vat_id) AND NOT anofox_metric_isolation_forest(amount, 0.1)
),
stage2 AS (
SELECT region, TS_FORECAST(stage1, 'date', 'sales', 'AutoETS', 12) FROM stage1 GROUP BY region
),
stage3 AS (
SELECT * FROM anofox_statistics_ols('sales', ['price', 'marketing'], 'stage2')
)
SELECT * FROM stage3;

The DuckDB Advantage

AnoFox is built as a set of high-performance extensions for DuckDB. Think of DuckDB as the engine and AnoFox as the glowing turbochargers that give you unparalleled speed and efficiency.

DuckDB Engine

AnoFox Turbocharger
AnoFox Turbocharger

Unrivaled Performance

Zero Copy, columnar processing, significantly faster than traditional data processing. Built on C++ for speed.

Drastic Cost Reduction

No Clusters Required. Serverless ready, runs on standard EC2, Lambda, or even WASM in the browser.

The Universal Ecosystem

Natively reads Parquet, CSV, JSON, Iceberg; interoperates with Polars, Pandas, Arrow.

SQL is the API. No new DSL.

SELECT TS_FORECAST(demands_table, 'date', 'sales', 'AutoETS', 12) FROM demands_table;

Built for Everyone, Supported for Enterprises

AnoFox is Source-Available

Free for development, testing, and research. Licensed under Business Source License 1.1 (BSL-1.1). Converts to Apache 2.0 on January 1, 2027.

Enterprise Support & Consulting

Scale with confidence. Get expert help when you need it most.

What's Included:

  • Architecture & DesignExpert consultation on data modeling, caching strategies, and API design.
  • Implementation SupportHands-on help deploying AnoFox for complex enterprise use cases.
  • Training & EnablementCustom workshops and training for your development team.
  • Priority SupportDirect access to engineering team with guaranteed response SLAs.
Perfect For:

Companies scaling AnoFox in production, complex data architectures, mission-critical deployments.

Commercial Licensing For Product Builders

Building a product on AnoFox? Let's partner on your success.

Our Approach:

  • Fair Share ModelWe believe in mutual success-get the licensing terms that work for your business.
  • Flexible LicensingRevenue share, per-seat, or custom arrangements-we adapt to your model.
  • Partnership BenefitsPriority feature requests, dedicated support, and go-to-market collaboration.
  • Legal ClarityClear licensing terms under BSL/Commercial, with straightforward commercial agreements.
Required For:

SaaS products embedding AnoFox, commercial products using AnoFox as core infrastructure.

Questions about licensing? If you're using AnoFox internally (even at enterprise scale), building open source projects, or creating free tools—you don't need a commercial license. Under BSL-1.1, any commercial use or product deployment requires explicit licensing from AnoFox.