AI Appointment Chatbot System
A full-stack chatbot system for appointment scheduling, built with Next.js, Node.js (Express), Python (FastAPI + LangChain), and PostgreSQL.
The chatbot intelligently handles user conversations, identifies appointment intents, and books appointments using AI-driven logic.
Please find technical Documentation for Architecture Overview
- Responsive, modern chat interface (Socket.IO)
- Real-time messaging
- Secure user authentication (JWT via cookies)
- Session management and chat history
- Intuitive, clean user experience
/api/chatbot/tokenendpoint for short-lived access tokens- Secure JWT-based authentication
- Middleware for logging, rate limiting, and request validation
- Socket.IO integration for real-time chat relay
- Communication bridge between frontend and Python microservice
- Manages chatbot conversation flow
- Integrates with OpenAI (or Anthropic / local LLM)
- Detects intent and manages appointment scheduling logic
- Logs all interactions for analytics
- Writes confirmed appointments to PostgreSQL
users: stores user profiles & credentialsappointments: handles scheduling data and statuschat_sessions: logs messages and metadata for analytics- Optimized with proper indexes and constraints
-Gives the command by command execution of code
- Gives security highlights
- Clone the repository
- git clone ,Example :https://github.com/your-org/ai-appointment-chatbot.git
- cd ai-appointment-chatbot
- psql -U postgres -d chatbot_appointments -f db/schema.sql
- cd backend
- npm install
- npm run dev
- cd microservice
- pip install -r requirements.txt
- uvicorn app:app --host 0.0.0.0 --port 8000 --reload
- cd frontend
- npm install
- npm run dev
-Visit → http://localhost:3000