🧠 AI Knowledge System

Enterprise-Ready Conversation Archive for ChatGPT + Claude

Transform your AI conversations from lost chat history into a searchable, organized knowledge base. This system captures insights from both ChatGPT Enterprise and Claude Desktop, storing everything in a structured database for long-term reference and analysis.

✨ Features

• 🔄 Dual AI Integration: Seamlessly capture conversations from both ChatGPT and Claude
• 🏢 Enterprise Compliant: Works with ChatGPT Enterprise restrictions via browser extension
• 📊 Smart Organization: Auto-categorize by strategy, user feedback, competitive analysis, etc.
• 🎯 Priority Levels: Mark conversations as low, medium, high, or critical importance
• 📅 Time-Based Filtering: Automatic quarterly tagging for periodic reviews
• 🔍 Powerful Search: Query across months of conversations to find patterns and insights
• 🛡️ Privacy First: Your data stays in your own Supabase database
• ⚡ One-Click Save: Browser extension makes saving ChatGPT conversations effortless

🎯 Perfect For

• Product Managers building competitive intelligence and user research repositories
• Consultants maintaining client insight databases
• Researchers organizing AI-assisted analysis sessions
• Teams creating shared knowledge bases from AI conversations
• Anyone who wants to stop losing valuable AI insights

🚀 Quick Start

Prerequisites

• Node.js 18+
• Chrome browser
• Supabase account (free tier works)

1. Database Setup

-- Create your conversations table
CREATE TABLE conversations (
  id SERIAL PRIMARY KEY,
  topic VARCHAR(100),
  content TEXT NOT NULL,
  category VARCHAR(50),
  priority VARCHAR(10),
  source VARCHAR(20),
  tags TEXT[],
  conversation_date DATE DEFAULT CURRENT_DATE,
  quarter VARCHAR(10),
  created_at TIMESTAMP DEFAULT NOW()
);

2. API Deployment

git clone https://github.com/yourusername/ai-knowledge-system
cd ai-knowledge-system/api-server
npm install
npm start

Set environment variables:

• `SUPABASE_URL`
• `SUPABASE_ANON_KEY`

3. Browser Extension Setup

1. Open `chrome://extensions/`

2. Enable "Developer mode"

3. Click "Load unpacked"

4. Select the `browser-extension` folder

4. Claude Desktop Integration

Add to `~/.claude/claude_desktop_config.json`:

{
  "mcpServers": {
    "supabase": {
      "command": "node",
      "args": ["/path/to/supabase-mcp/packages/mcp-server-supabase/dist/transports/stdio.js"],
      "env": {
        "SUPABASE_ACCESS_TOKEN": "your_token",
        "SUPABASE_URL": "your_url",
        "SUPABASE_ANON_KEY": "your_key",
        "SUPABASE_PROJECT_REF": "your_project"
      }
    }
  }
}

💡 Usage Examples

ChatGPT Enterprise

1. Have your conversation normally

2. Click the extension icon

3. Review auto-suggested topic

4. Select category and priority

5. Click "Save Conversation"

Claude Desktop

"Save this strategy conversation with high priority: 
[your conversation content]"

"Show me all user feedback insights from Q1 2025"

"Find high-priority competitive analysis discussions"

🏗️ Architecture

ChatGPT Enterprise → Browser Extension → API Server → Supabase
Claude Desktop → MCP Protocol → Local Server → Supabase

Components

• Browser Extension: Captures ChatGPT conversations with enterprise compliance
• API Server: Hosted endpoint for saving conversations to database
• MCP Integration: Direct Claude Desktop to database connection
• Supabase Database: PostgreSQL with structured conversation storage

📁 Project Structure

ai-knowledge-system/
├── browser-extension/
│   ├── manifest.json
│   ├── popup.html
│   ├── popup.js
│   └── content.js
├── api-server/
│   ├── server.js
│   ├── package.json
│   └── .env.example
├── mcp-setup/
│   └── claude_desktop_config.json
├── database/
│   └── schema.sql
└── docs/
    └── technical-overview.html

🔧 Configuration

Categories

• `strategy` - High-level planning and direction
• `user_feedback` - Customer insights and research
• `competitive_analysis` - Market and competitor research
• `brainstorming` - Creative ideation sessions
• `general` - Miscellaneous conversations

Priority Levels

• `critical` - Mission-critical insights
• `high` - Important for near-term decisions
• `medium` - Useful reference material
• `low` - Nice-to-have information

🛠️ Development

Local Development

# API Server
cd api-server
npm install
npm run dev

# Extension Development
# Load unpacked extension in Chrome for hot reloading

Adding Features

• New Categories: Update database constraints and extension dropdown
• Custom Fields: Extend database schema and forms
• Integrations: Add new AI tools following the extension pattern

🤝 Contributing

1. Fork the repository

2. Create a feature branch (`git checkout -b feature/amazing-feature`)

3. Commit your changes (`git commit -m 'Add amazing feature'`)

4. Push to the branch (`git push origin feature/amazing-feature`)

5. Open a Pull Request

📋 Roadmap

• [ ] Slack integration for team sharing
• [ ] Export to PDF/Word reports
• [ ] Advanced analytics dashboard
• [ ] Mobile app for conversation capture
• [ ] Integration with Notion/Obsidian
• [ ] Multi-user support with permissions

⚠️ Enterprise Considerations

This system is designed to work within enterprise constraints:

• ✅ No API keys required for ChatGPT Enterprise
• ✅ Data stays in your own database
• ✅ Browser extension uses standard web APIs
• ✅ No external AI service dependencies

📄 License

MIT License - see LICENSE file for details.

🙏 Acknowledgments

• Supabase MCP Community for the foundational MCP server
• Anthropic for Claude and MCP protocol
• OpenAI for ChatGPT platform

📧 Support

• Create an issue for bugs
• Start a discussion for questions
• Follow @yourusername for updates

Built by product managers, for product managers. 🚀

*Stop losing your best AI insights. Start building your knowledge advantage.*