theabdullahraja/database-intrusion-detection-system ? reverse-engineered prompt

Build me a small database security app for MySQL that can watch SQL queries, spot suspicious activity, and block or warn about attacks before they reach the database.

I want it to support role based logins, safe query checking, and detection for things like SQL injection, privilege escalation, brute force attempts, DDL abuse, and data dumping. It should keep an audit trail, alert log, and blocked IP list, and it should be able to export reports for an admin to review.

Please make a Python app with a command line mode for running protected queries, plus a simple localhost only web console where a user can log in and try queries through the same security checks. Also add a read only dashboard for viewing alerts, activity, and attack stats, with a clean demo friendly setup.

Use MySQL for the data, include sample schema and seed data, and make it easy to run locally with environment based config. If you need to, look up the current docs online for the best way to wire it together.