Overchat - AI-Powered Conversation Analysis & Ticket Management

Transform team conversations into actionable tickets automatically

Overchat analyzes team discussions using AI and automatically creates, updates, and manages tickets on platforms like GitHub and Trello. No more manual ticket creation or missed action items.

🚀 What Overchat Does

Input: Team conversations (Slack, chat, document uploads)
Output: Automatically created and managed tickets on GitHub/Trello

"We need to fix the login bug ASAP" 
    ↓ AI Analysis
    ↓ Intent Detection  
    ↓ Similarity Check (finds related tickets)
    ↓ Diff Board (human approval)
    ↓ Ticket Creation
GitHub Issue #123: "Fix login authentication bug" [Priority: High]

✨ Key Features

• 🧠 Conversation Analysis — Detects intents (create/update/delete, decisions, clarifications, scope/priority/status changes)
• 🔗 Message↔Ticket Linking — Similarity search surfaces related tickets; one message can link to multiple tickets
• 📄 Message↔Chunk Linking — Real-time similarity search connects messages to relevant document chunks
• 👤 Human-in-the-Loop Approval — Review diff board showing before/after changes before execution
• 🔍 Duplicate Prevention — Vector search over tickets and docs before creating new ones
• 🔄 Real-time Sync & Drift Detection — Webhooks + version guards; operations are idempotent and reversible
• 🧩 Multi-Platform — GitHub, Trello (more coming)

📚 Documentation

Core Systems

• Application Overview - High-level architecture and concepts
• Conversation Analysis - How AI understands discussions
• Intent Execution - How intents become tickets
• Similarity Search - Duplicate prevention system
• External Services - GitHub/Trello integration
• Database Architecture - Data models and services

🛠️ Development Setup

Prerequisites

• Node.js 18+
• pnpm 8+
• PostgreSQL 14+

Quick Start

# 1. Clone and install
git clone https://github.com/your-org/overchat.dev
cd overchat.dev
pnpm install

# 2. Setup environment
cp .env.example .env
# Edit .env with your configuration

# 3. Setup database  
cd packages/database
pnpm db:migrate
pnpm db:generate

# 4. Start development
pnpm dev

🌐 Open your browser:

• Web App: http://localhost:3000
• API: http://localhost:4001/graphql
• Docs: http://localhost:3001

Required Environment Variables

# Database
DATABASE_URL=postgresql://user:pass@localhost:5432/overchat

# AI Services  
OPENAI_API_KEY=sk-...
PINECONE_API_KEY=...

# External Services
GITHUB_TOKEN=ghp_...
TRELLO_TOKEN=...

🔧 Project Structure

overchat.dev/
├── apps/
│   ├── api/           # GraphQL API server (Fastify)
│   ├── web/           # Main web interface (Next.js)  
│   └── docs/          # Documentation site
├── packages/
│   ├── ai/            # AI analysis & embeddings
│   ├── database/      # Prisma models & services
│   ├── external-services/  # GitHub/Trello integration
│   ├── shared/        # Shared types & utilities
│   └── ...            # Other packages

🎮 API Examples

Analyze a Conversation

query AnalyzeConversation($id: ID!) {
  conversation(id: $id) {
    id
    title
    intents {
      type
      summary
      confidence
      ticketOperation
    }
  }
}

Execute an Intent

mutation ExecuteIntent($intentId: ID!, $platform: ExternalService!) {
  executeIntent(intentId: $intentId, platform: $platform) {
    success
    mapping {
      externalId
      url
    }
  }
}

🔍 Key Use Cases

• Team Planning: "We need to build a user dashboard" → GitHub issue with requirements
• Bug Reports: "Login is broken" → High-priority GitHub issue
• Feature Requests: "Add mobile support" → Trello card in backlog
• Document Analysis: Upload PRD → Multiple tickets for each feature
• Real-time Context: "How do we handle auth?" → Chat shows relevant doc chunks from API specs and security guidelines
• Cross-Reference: "The login issue is similar to #123" → Message automatically links to related tickets and documentation

🚀 Deployment

# Build for production
pnpm build

# Run migrations
pnpm db:migrate:deploy

# Start server
pnpm start

🤝 Contributing

We welcome contributions! See our development workflow:

# Create feature branch
git checkout -b feature/new-integration

# Test changes
pnpm test
pnpm type-check
pnpm lint

# Submit PR
git push origin feature/new-integration

📝 License

MIT License - see LICENSE for details.

---

Built with ❤️ by the Overchat team

Transforming team collaboration through AI-powered conversation analysis.