I need a production-ready web application built with Flask, the AdminLTE theme, and a SQL back-end that works as an all-in-one networking portal. The core idea is to give every authenticated user a single place where they can view real-time dashboards, chat with a local AI assistant, and organise projects together. Scope at a glance • Scalable and easily maintainable codebase (Blueprint structure, SQLAlchemy, migrations) • Multi-tenant user system with roles: Admin, Manager, Standard User • Real-time dashboards powered by Socket.IO/WebSockets so key stats refresh instantly • Local AI chatbot embedded in the interface for quick Q&A and guidance (no external API calls) • Integrated project planner: Kanban or Gantt view, task assignment, due dates, progress tracking • Robust user profile pages that can later expand to show skills, experience, or contact details • Clean, responsive UI via AdminLTE, keeping the look cohesive across dashboards, chat, and planner Preferred stack & tools Flask 2.x, Jinja2, AdminLTE 3/4, SQLAlchemy/PostgreSQL (open to MySQL), Flask-Login, Socket.IO, Celery/Redis for background tasks, and a lightweight LLM such as llama.cpp for the on-device chatbot. Version control on GitHub or GitLab is essential. Deliverables 1. Complete source code with a README that explains setup, environment variables, and migration commands. 2. Database schema (SQLAlchemy models + migration scripts). 3. Sample data fixture so I can see dashboards populate immediately. 4. Documentation covering how to retrain or swap the local AI model. 5. Dockerfile or Compose stack that spins up the whole platform with one command. 6. Short walkthrough video or screenshots proving the real-time updates, AI chat, and project planner all function together. Acceptance criteria • Creating a project, adding users, and assigning tasks must reflect on every participant’s dashboard within two seconds. • The AI chatbot must answer a prompt without leaving the local network and display the reply in the chat pane. • No page reloads are required to see new data in any dashboard widget. • Admin can deactivate or delete a user and immediately revoke their access. If elements like discussion forums, event management, or richer profile sections can be slotted in without disrupting the core goals above, let’s discuss; flexibility here is welcome, but the dashboard, AI bot, and planner remain first priority. Hand me a repo I can `docker compose up` and start using, plus the docs to maintain, extend, and scale it.