MCP save_memory: Type "note" not allowed by database constraint #242

New issue

Closed

opened 2026-01-25 00:35:09 +00:00 by jack · 0 comments

jack commented

2026-01-25 00:35:09 +00:00

Owner

Problem

The MCP tool save_memory accepts a type parameter with allowed values: decision, discovery, note, bookmark. However, the database has a CHECK constraint that only allows: decision, bugfix, feature, refactor, discovery, change, session-request.

Error:

CHECK constraint failed: type IN ('decision', 'bugfix', 'feature', 'refactor', 'discovery', 'change', 'session-request')

MCP Tool Definition:

{
  type: {
    description: "Memory type: decision (architectural choice), discovery (learning), note (general), bookmark (important moment)",
    enum: ["decision", "discovery", "note", "bookmark"]
  }
}

Solution Options

Update database constraint to include note and bookmark types
Update MCP tool definition to match existing database types
Map MCP types to database types (e.g., note → discovery, bookmark → decision)

## Problem The MCP tool `save_memory` accepts a `type` parameter with allowed values: `decision`, `discovery`, `note`, `bookmark`. However, the database has a CHECK constraint that only allows: `decision`, `bugfix`, `feature`, `refactor`, `discovery`, `change`, `session-request`. **Error:** ``` CHECK constraint failed: type IN ('decision', 'bugfix', 'feature', 'refactor', 'discovery', 'change', 'session-request') ``` **MCP Tool Definition:** ```typescript { type: { description: "Memory type: decision (architectural choice), discovery (learning), note (general), bookmark (important moment)", enum: ["decision", "discovery", "note", "bookmark"] } } ``` ## Solution Options 1. **Update database constraint** to include `note` and `bookmark` types 2. **Update MCP tool definition** to match existing database types 3. **Map MCP types to database types** (e.g., `note` → `discovery`, `bookmark` → `decision`)