DecisionBox v0.3.0 — PostgreSQL, Databricks, Ecommerce, and Plugin Hooks

DecisionBox v0.3.0 adds two new warehouse providers, the first non-gaming domain pack, and a plugin middleware system that opens the door for enterprise extensions without touching community code.

PostgreSQL Support

PostgreSQL is now a supported warehouse, making DecisionBox accessible to teams that don't use a cloud data warehouse. Connect with username/password or a connection string, with SSL mode configurable (default: require).

The PostgreSQL provider includes a comprehensive SQL fix prompt covering 13 error patterns that the AI agent commonly encounters — LATERAL joins, FILTER clauses, recursive CTEs, the NOT IN NULL trap, BETWEEN timestamp pitfalls, and more. Row count estimates use pg_class.reltuples for fast schema discovery without full-table scans.

Databricks Integration

Databricks SQL warehouses are now supported via Unity Catalog. Two authentication methods are available:

• Personal Access Token (PAT) for quick setup.
• OAuth M2M (service principal) for production workloads.

The provider covers the full Databricks type system including complex types (STRUCT, ARRAY, MAP, VARIANT) and includes a dialect-specific SQL fix prompt for QUALIFY, PIVOT/UNPIVOT, Delta time travel, and the common yyyy vs YYYY date format pitfall.

Ecommerce Domain Pack

The first domain pack outside of gaming brings AI-powered analysis to online stores. It covers five analysis areas:

• Conversion Funnel — Drop-off analysis from landing to purchase.
• Revenue & Pricing — Price sensitivity, discount effectiveness, AOV trends.
• Customer Retention — Cohort analysis, repeat purchase patterns, churn signals.
• Product & Category Performance — Top sellers, underperformers, cross-sell opportunities.
• Session & Browsing Behavior — Navigation paths, search patterns, device segmentation.

The pack includes a profile schema for capturing store context — business model, fulfillment method, marketing channels, and KPIs — so the agent tailors its analysis to your specific setup.

Plugin Middleware Hooks

This release introduces a middleware system that lets enterprise plugins wrap core functionality without modifying community code:

• Warehouse Middleware (warehouse.RegisterMiddleware()) — Intercept warehouse calls for logging, access controls, or cost tracking.
• HTTP Middleware (apiserver.RegisterGlobalMiddleware()) — Wrap all API requests for audit logging or custom authentication.
• Agent Export (agentserver.Run()) — Build custom agent binaries that import your plugins and call the standard entry point.

These hooks power the enterprise auth plugin and are available for anyone building custom extensions.

Other Improvements

• Per-model max output tokens — The agent now requests each model's full output capacity for recommendation generation instead of a fixed 8K limit.
• IP restriction — GKE, EKS, and AKS control plane access can be restricted to specific CIDR ranges via allowed_cidr_blocks in Terraform modules. The setup wizard auto-detects your public IP.
• Insight validation fix — Improved SQL fix prompt parsing and added missing schema context, increasing the success rate of automated insight validation.

Seamless Upgrade

No breaking changes. Update your Docker images to v0.3.0 or pull the latest Helm charts:

helm repo update decisionbox
helm upgrade decisionbox-api decisionbox/decisionbox-api
helm upgrade decisionbox-dashboard decisionbox/decisionbox-dashboard

Get Started

Check out the v0.3.0 release notes on GitHub. If you have suggestions or run into issues, join us on GitHub Discussions.