Consulting AI – Intelligent Process Advisor (In Development)

Description

Consulting AI is an intelligent advisory system built with FastAPI and PostgreSQL. It runs on rule-based process flows: users describe their needs in natural language; the system finds the right workflow, asks questions in sequence, and produces step-by-step outcomes from answers. It is designed to give consistent guidance for corporate processes (accounting, operations, support, etc.) when teams ask, “What steps should I follow?”

Details

Chat-based advisory: user message → intent matching → dynamic Q&A flow → rule engine output (title, steps, warnings). Multi-process management: each process is a JSON workflow (questions, rules, default outcomes); a registry holds keywords, descriptions, and optional strict matching rules. Smart routing: keyword scoring, topic search (over question text and registry), and disambiguation by offering choices when unclear. Conditional questions: branching via show_if from prior answers; answer normalization (e.g. Turkish character folding). Admin panel: create / clone / edit / delete flows, intent registry management, schema validation. AI-assisted process authoring: natural-language descriptions are turned into workflow + intent JSON via OpenAI, then published (OPENAI_API_KEY required). Authentication: cookie-based sessions, PBKDF2-SHA256 password hashes, admin and user roles. Analytics: conversation journey (question_log), resolved / unresolved feedback, admin reporting. Data: workflows and registry in PostgreSQL JSONB; Docker Compose for local PostgreSQL 16. Frontend: static HTML, CSS, and vanilla JavaScript. Main routes: / (chat), /login, /admin, /admin/ai-process, /report.

Tech Stack

  • Python — FastAPI, Uvicorn
  • SQLAlchemy 2.0 — PostgreSQL 16 (JSONB)
  • Pydantic v2 — API models & validation
  • Starlette SessionMiddleware, itsdangerous — sessions
  • python-dotenv — configuration
  • OpenAI Chat Completions API (optional)
  • Vanilla HTML / CSS / JavaScript — frontend
  • Docker Compose — PostgreSQL

Status

In active development

Screenshots

Chat-based advisor
Feedback report for chat conversations
Manual process creation
/admin/ai-process — AI-assisted process analysis & publishing

1 / 4 — click an image to enlarge