Copilot Memory SQLite - Enhanced Knowledge Storage

🚀 High-Performance Memory System for GitHub Copilot

Transform your GitHub Copilot experience with SQLite-powered knowledge storage! Store, retrieve, and organize your coding knowledge with natural language commands like "remember this" and "retrieve information about X".

✨ Key Features

• 🧠 Natural Language Memory: Use "remember" and "retrieve" commands in GitHub Copilot Chat
• ⚡ 10x Faster Performance: SQLite database vs JSON files (5ms vs 500ms response times)
• 📦 One-Click Migration: Easy switch from ByteRover to local SQLite storage
• 🔒 100% Privacy: All data stays on your local machine
• � Comprehensive Knowledge: Pre-loaded with expert programming knowledge
• � Easy Reset: One-click MCP configuration switching
• 🎯 Project-Specific: Separate databases for each workspace
• 🔧 Easy Configuration: Simple setup and configuration options

Installation

From Source

1. Clone the repository and navigate to the extension directory:

   cd copilot-memory-mcp/extension
   

2. Install dependencies:

   npm install
   

3. Compile the extension:

   npm run compile
   

4. Package the extension:

   npm run package
   

5. Install the generated .vsix file in VS Code.

Quick Start

Using Server Storage (Recommended)

The extension comes pre-configured to use our hosted API server. Simply:

1. Install the extension
2. Open VS Code settings (Cmd/Ctrl + ,)
3. Search for "Copilot Memory"
4. Set Storage Type to server
5. The Server URL is already configured to use our hosted API

Using Local Storage

1. Set Storage Type to local
2. Optionally configure the Local Data Directory (default: ~/.copilot-memory)

Using Both (Hybrid)

1. Set Storage Type to both
2. Configure both server and local storage settings

Configuration

Storage Settings

MCP Server Settings

Logging Settings

Usage

Commands

Access these commands through the Command Palette (Cmd/Ctrl + Shift + P):

• Copilot Memory: Configure Storage - Open storage configuration
• Copilot Memory: View Memory - Browse stored memories
• Copilot Memory: Clear Memory - Clear all stored memories
• Copilot Memory: Resolve Conflicts - Handle storage conflicts
• Copilot Memory: Export Memory - Export memories to file
• Copilot Memory: Import Memory - Import memories from file

Memory Explorer

The Memory Explorer appears in the VS Code sidebar and provides:

• Tree view of stored memories organized by categories
• Search functionality to find specific memories
• Context menu actions for managing individual memories
• Real-time updates when memories are added or modified

With GitHub Copilot

When using GitHub Copilot, the extension automatically:

• Stores relevant code patterns and solutions
• Retrieves contextual information for better suggestions
• Learns from your coding patterns and preferences
• Provides intelligent conflict resolution

Storage Backends

Local Storage

• Pros: Fast, private, works offline
• Cons: Not shared across devices
• Best for: Personal use, privacy-sensitive projects

Server Storage

• Pros: Shared across devices, cloud backup, team collaboration
• Cons: Requires internet connection
• Best for: Team projects, multi-device workflows

Hybrid Storage

• Pros: Best of both worlds, automatic sync, fallback support
• Cons: More complex configuration
• Best for: Advanced users, critical workflows

API Server

The extension can connect to our hosted API server or your own deployment:

Hosted Service

• URL: https://aimem-q9cgj9973-kiranbjms-projects.vercel.app
• No authentication required
• Automatically configured

Self-Hosted

Deploy your own instance using the provided server code in the repository.

Development

Building from Source

# Install dependencies
npm install

# Compile TypeScript
npm run compile

# Watch for changes during development
npm run watch

# Run tests
npm test

# Lint code
npm run lint

# Package extension
npm run package

Project Structure

extension/
├── src/
│   ├── extension.ts          # Main extension entry point
│   ├── mcpClient.ts          # MCP client implementation
│   ├── configuration.ts     # Configuration management
│   ├── memoryExplorer.ts    # Tree view provider
│   └── webviewProvider.ts   # Webview management
├── package.json             # Extension manifest
├── tsconfig.json           # TypeScript configuration
└── README.md               # This file

Troubleshooting

Extension Not Loading

1. Check VS Code version compatibility (requires 1.85.0+)
2. Restart VS Code after installation
3. Check the Output panel for error messages

Storage Issues

1. Verify storage type configuration
2. For server storage, check network connectivity
3. For local storage, verify directory permissions

MCP Server Connection

1. Check server path configuration
2. Verify server is running and accessible
3. Check logs for connection errors

Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Add tests
5. Submit a pull request

License

This project is licensed under the MIT License. See the LICENSE file for details.

Support

• 📖 Documentation
• 🐛 Report Issues
• 💡 Feature Requests

Changelog

1.0.0

• Initial release
• Local and server storage backends
• Memory explorer tree view
• MCP server integration
• Configuration management
• Export/import functionality