AI Integration for SQL ERP

I have an operational ERP that runs on a SQL back-end. I now want to unlock the data it holds by adding an AI layer that can:

• run predictive analytics for sales and purchasing forecasts,
• use natural language processing so I can just type or speak a question and receive answers,
• generate automated, always-up-to-date reports, and
• push live updates to my phone on daily sales, employee activity, top-selling items and supplier ratings.

The database schema is well documented and I can give direct SQL access or a read-only replica—whatever you prefer. Your job is to connect the ERP tables to an AI pipeline, build the required models or services, and surface the insights through a simple web or mobile interface with real-time notifications.

Acceptance criteria
1. Forecast accuracy improves on our current manual method and is demonstrated with back-testing.
2. Natural-language queries (“Show me yesterday’s top five items”, “Predict next month’s purchase needs”) return results in under five seconds.
3. Scheduled reports (PDF or interactive dashboard) auto-generate and email daily without intervention.
4. Push notifications reach my Android phone instantly when predefined thresholds are met.

Preferred stack is Python with TensorFlow/PyTorch and a lightweight API (FastAPI, Flask, or similar), but I’m open to alternatives if they get the job done quickly and reliably. All source code, model artefacts, and setup scripts should be delivered so we can host everything on our own server afterward.

Logic erp is the name of software i am using