# 🏥 MCP Hospital Assistant

A full-stack intelligent hospital appointment management system powered by React, Node.js, PostgreSQL, and Mistral LLM (via Ollama).
## 🔥 Preview

### 🎥 Demo Video

[▶️ Click here to watch the demo](./MCP_DEMO.webm)

### 🏠 Dashboard  
![Dashboard](./home2.png)

### 💬 LLM Chat Assistant  
![LLM Chat](./llmchat.png)

### 💬 Mannual Booking  
![LLM Chat](./booki.png)



    🔁 Node.js + Express

    🎨 React.js (frontend)

    🧠 LLM (Ollama - Mistral)

    💾 PostgreSQL

    🛡️ Session-based login

📷 UI Preview

    Login / Register Page

    Dashboard with buttons to manage system manually

    Book Appointment (manual)

    LLM-powered auto assistant interface

📁 Project Structure

├── backend/
│   ├── server.js              # Node.js + Express backend
│   ├── config/config.js       # PostgreSQL config
│   ├── mcp/                   # All business logic handlers
│   ├── auth/                  # Login, register, session routes
├── frontend/
│   └── mcp-ui/                # React frontend
│       ├── components/        # AddDoctor, Chat, Login, Home etc.
│       └── App.js             # Main route controller

⚙️ Setup Instructions
1. ✅ Install PostgreSQL and create DB

sudo apt install postgresql postgresql-contrib
sudo -u postgres psql

Then run:

CREATE DATABASE mcp;
CREATE USER mcpuser WITH PASSWORD 'mcppass';
GRANT ALL PRIVILEGES ON DATABASE mcp TO mcpuser;

2. 📦 Create Schema

Connect:

psql -U mcpuser -d mcp -h localhost

CREATE TABLE doctors (
  doctor_id SERIAL PRIMARY KEY,
  name TEXT,
  department TEXT,
  available_slots JSONB
);

CREATE TABLE patients (
  patient_id SERIAL PRIMARY KEY,
  name TEXT,
  age INTEGER,
  contact TEXT
);

CREATE TABLE appointments (
  appointment_id SERIAL PRIMARY KEY,
  doctor_id INTEGER REFERENCES doctors(doctor_id),
  patient_id INTEGER REFERENCES patients(patient_id),
  appointment_time TEXT
);

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  username TEXT UNIQUE,
  password TEXT
);

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO mcpuser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO mcpuser;

3. 🧠 Install Ollama with Mistral

curl -fsSL https://ollama.com/install.sh | sh
ollama run mistral

Make sure the local Ollama server is running and available on default port 11434.
4. 🚀 Backend Setup (Node.js)

cd backend/
npm install
node server.js

This starts backend on: http://localhost:3007
5. 💻 Frontend Setup (React)

cd frontend/mcp-ui
npm install
npm start

This starts frontend at: http://localhost:3000
🧠 Key Functionalities
✨ Mode 1: Manual via UI



You can click on homepage icons to:

    ➕ Add Doctor

    ➕ Add Patient

    📅 Book Appointment

    📋 View Doctors

    📋 View Appointments

These UI features directly use API endpoints (/api/execute, /api/book, etc.)
🔍 Mode 2: Smart Assistant (LLM-enabled)

From the "Ask Assistant" chat interface:

    Type: Show all appointments

    Or: Book appointment for patient John with doctor 2 at 10:00

✅ If MCP Tools is enabled (checkbox at top), the LLM will:

    🔎 Understand user command

    🔧 Choose correct tool from tools.json

    🧠 Generate SQL

    🔁 Automatically execute API calls behind the scenes

❌ If disabled, LLM simply gives plain answers (no system change).
🔐 Authentication

    Only authenticated users can access core pages.

    Register page stores hashed credentials securely in PostgreSQL.

    Session stored using express-session.

📝 Example Prompts for LLM

Show all the doctors in doctor table
Show appointments after 11:00
Book an appointment with Dr. Renu at 09:00 for John (age 30)

✅ Summary
Feature	Manual UI	LLM Tools
Add Doctor	✅ Yes	✅ via prompt
Book Appointment	✅ Yes	✅ if slot available
View Doctors/Appointments	✅ Yes	✅ via prompt
Edit Slots	✅ Yes (via query)	✅ via prompt
Security	🔐 Session Login	🔐 Session Protected