AI Knowledge System
An enterprise-ready system to archive AI conversations from ChatGPT and Claude into a Supabase database.
π§ 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_URLSUPABASE_ANON_KEY
3. Browser Extension Setup
- Open
chrome://extensions/ - Enable "Developer mode"
- Click "Load unpacked"
- Select the
browser-extensionfolder
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
- Have your conversation normally
- Click the extension icon
- Review auto-suggested topic
- Select category and priority
- 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 directionuser_feedback- Customer insights and researchcompetitive_analysis- Market and competitor researchbrainstorming- Creative ideation sessionsgeneral- Miscellaneous conversations
Priority Levels
critical- Mission-critical insightshigh- Important for near-term decisionsmedium- Useful reference materiallow- 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
- Fork the repository
- Create a feature branch (
git checkout -b feature/amazing-feature) - Commit your changes (
git commit -m 'Add amazing feature') - Push to the branch (
git push origin feature/amazing-feature) - 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.
Related Servers
Token Metrics
Token Metrics integration for fetching real-time crypto market data, trading signals, price predictions, and advanced analytics.
MCP MariaDB Server
Manage and query MariaDB databases using the Model Context Protocol (MCP), with support for SQL and vector search.
MySQL DB
An MCP server for integrating with and managing MySQL databases.
KuzuMem-MCP
A distributed memory bank MCP tool that stores memories in a KΓΉzuDB graph database, with repository and branch filtering capabilities.
Alpha Vantage
Provides real-time financial market data using the Alpha Vantage API.
MySQL MCP Server
Provides read-only access to MySQL databases, allowing LLMs to inspect schemas and execute queries.
A-Share MCP
Provides A-share stock market data, including basic info, historical K-lines, financial indicators, and macroeconomic data using Baostock.
Snapchat Ads by CData
A read-only MCP server for querying live Snapchat Ads data using the CData JDBC Driver.
Kollektiv MCP
Build and access a personal LLM knowledge base from your editor or client without any infrastructure setup.
PostgreSQL & Google Sheets
MCP servers for interacting with PostgreSQL databases and Google Sheets.