ERP Scale Sidecar (HTAP Router for Relational Limits)
9/10
Demand Score
ERP outages and slowdowns from connection limits, table bloat, and long-running joins are blocking operations and forcing costly DB license upgrades.
8/10
Blue Ocean
Competition Level
$2k-5k
Price/Month
Predicted customer spend
120 days
Time to MVP
Difficulty: Expert
The Problem
A drop-in SQL proxy and sidecar that horizontally scales ERP relational databases without code changes. It classifies ERP queries on the fly, routes OLTP writes to the primary RDBMS, and mirrors heavy
🔗 Validated by Real User Complaints
This problem has been verified through 5 real user complaints:
Competitor Landscape
- Citus Data
- Vitess
- PlanetScale
- Crunchy Bridge
- PgBouncer/ProxySQL
- Redis caching
Must-Have Features for MVP
SQL proxy with query classification and routing
CDC pipelines to columnar mirror
Auto materialized view generation for ERP reports
Online logical partitioning advisor and executor
Hot-row/lock storm guardrails
Read replica health and fail-open logic
Observability with per-query SLA tracking
⚠️ Potential Challenges
- Maintaining transactional consistency between primary and mirror
- ERP vendor-specific query patterns
- Change data capture latency under spikes
- Complex on-prem networking/security constraints
Risk Level: Moderate
🎯 Keys to Success
- Measurable 5–10x speedup for reports/dashboards
- No application code changes
- Near-zero downtime deployment
- Proven correctness (write paths never leave primary)
- Clear cost avoidance versus DB license/hardware upgrades
Ready to Build This?
This expert-difficulty project could be your next micro-SaaS success.