编码记忆管理系统

MemoryMcp/
├── MemoryMcp/                      # Main library
│   ├── Database/
│   │   ├── McpDb.cs               # DB initialization & schema
│   │   └── LearningNoteRepo.cs    # Repository pattern (CRUD + search)
│   ├── Models/
│   │   └── LearningNote.cs        # Data models
│   ├── Formatting/
│   │   └── ApplyFormatter.cs      # Output generation (instructions, checklist, gotchas)
│   └── MemoryMcp.csproj
├── MemoryMcp.Tests/               # Comprehensive test suite
│   ├── Database/
│   │   ├── DatabaseInitializationTests.cs
│   │   └── LearningNoteRepoTests.cs
│   ├── Formatting/
│   │   └── ApplyFormatterTests.cs
│   ├── Integration/
│   │   └── EndToEndWorkflowTests.cs
│   ├── TestDbFixture.cs
│   ├── Usings.cs
│   └── MemoryMcp.Tests.csproj
├── MemoryMcp.sln
└── README.md

dotnet build MemoryMcp.sln

dotnet test MemoryMcp.sln

dotnet test MemoryMcp.sln --filter "DatabaseInitializationTests"

dotnet test MemoryMcp.sln --verbosity detailed

// Initialize database
var db = new McpDb(@"%USERPROFILE%\.mcp\mcp.db");
await db.InitializeAsync();

// Create repository
var repo = new LearningNoteRepo(db.ConnectionString);

// Add a learning
var id = await repo.AddLearningAsync(new LearningNoteInput(
    RepoKey: "example-repo",
    Title: "Email reminder race condition",
    Problem: "Duplicate emails sent on retry",
    Solution: "Add idempotency check; verify state before send",
    RootCause: "Async message in flight when approval completes",
    Confidence: "confirmed",
    Tags: new[] { "email", "approval", "race-condition" },
    Links: new[] { ("PR", "https://github.com/org/repo/pull/123") }
));

// Search for it
var results = await repo.SearchAsync("email reminder", repoKey: "example-repo");

// Generate session aids
var instructions = ApplyFormatter.BuildCopilotInstructions(results);
var checklist = ApplyFormatter.BuildChecklist(results);
var gotchas = ApplyFormatter.BuildGotchasSummary(results);

record LearningNote(
    long Id,
    string RepoKey,              // e.g., "example-repo"
    string Title,                // Main heading
    string Problem,              // What went wrong
    string Solution,             // How to fix/prevent
    string? RootCause,           // Optional root cause
    string? AppliesWhen,         // When this learning applies
    string Confidence,           // "confirmed" | "likely" | "hypothesis"
    string CreatedAt,            // ISO8601 timestamp
    string UpdatedAt,            // ISO8601 timestamp
    string? LastVerifiedAt       // When last confirmed
)

record LearningNoteInput(
    string RepoKey,
    string Title,
    string Problem,
    string Solution,
    string? RootCause = null,
    string? AppliesWhen = null,
    string Confidence = "likely",
    IEnumerable<string>? Tags = null,
    IEnumerable<(string label, string url)>? Links = null
)

-- Simple keywords
"email timeout"

-- OR queries
"timeout OR deadline"

-- NEAR operator (within N words)
"reminder NEAR/3 approved"

-- Quoted phrases
"race condition"

-- Field-specific (if needed)
problem:timeout solution:retry