Employee Management AI Agent Demo

Overview

A personal project exploring AI-powered employee management using JStack, LangGraph, and LangSmith. This demo showcases how to build an intelligent agent that can query and analyze employee data through natural language interactions.

Demo.Video.mov

Features

AI-Powered Assistant: Natural language interface for querying employee data
Employee Analytics: Get insights about salary distributions, demographics, and more
Structured Data Querying: Complex database queries simplified through conversation

Technologies Used

JStack: A modern TypeScript framework for building type-safe APIs
LangGraph: Framework for building stateful applications with LLMs
LangSmith: Debug, test, evaluate, and monitor LLM applications
Next.js: React framework for the web interface
Drizzle ORM: TypeScript ORM for PostgreSQL
Tailwind CSS: Utility-first CSS framework

Getting Started

Prerequisites

Node.js (v18 or higher)
PostgreSQL database
OpenAI API key

Installation

Clone the repository:

git clone https://github.com/yourusername/employee-management-ai-demo.git
cd employee-management-ai-demo

Install dependencies:
```
npm i
```

Set up environment variables:

Create a .env file with:

DATABASE_URL='****'
LANGSMITH_TRACING=true
LANGSMITH_ENDPOINT="https://api.smith.langchain.com"
LANGSMITH_API_KEY="****"
LANGSMITH_PROJECT="****"
OPENAI_API_KEY="****"

Start the development server:
```
yarn dev
```
Visit http://localhost:3000 to interact with the AI assistant.

Usage Example

You can ask the AI assistant questions like:

"What's the average salary in the marketing department?"
"Show me employees hired in the last 6 months"
"Compare compensation between different departments"

Learning Resources

License

MIT

This is a personal project created for learning and demonstration purposes.

themashcodee/langGraph-w-jstack-demo