gulmezeren2-byte/erp-report-engine ? reverse-engineered prompt

Build me a Python tool that connects to an ERP database and generates a weekly management report from it, plus a guarded MCP server that lets AI agents ask questions without ever being able to write to the database.

I want the report to be self contained HTML, with KPI cards, week over week and baseline comparisons, simple trend charts, stock alerts, data quality checks, and a clear audit trail showing every query that ran and whether row counts matched. It should work with a demo database out of the box, and also support real ERP databases like SQL Server, with PostgreSQL and SQLite if possible.

The main thing is safety, so make every query read only and reject anything risky, even tricky SQL that tries to sneak in side effects. Use a simple semantic config so the database schema can be mapped to friendly names like orders and inventory. If you need current library or driver details, look them up online and make sensible defaults.