MCP API Keys Table

Overview

Table for managing MCP API key information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
MCP API Key Information	mcp_api_keys	id	serial	◯
		user_id	string				◯		Logical: user.cognito_sub (no FK)
		project_id	number		project:id		◯
		name	string
		key_prefix	string			◯
		key_hash	string			◯
		salt	string			◯
		permission	enum					'0'	mcp_api_key_permission ('0', '1')
		expires_at	datetime				◯
		revoked_at	datetime				◯
		last_used_at	datetime				◯
		created_at	datetime				◯
		updated_at	datetime
		deleted_at	datetime				◯
		created_by	string
		updated_by	string
		deleted_by	string				◯

Relations

• user_id → user.cognito_sub (application-level; not an FK in schema)
• project_id → project.id (on delete/update cascade from model)

Indexes

• PRIMARY KEY (id)
• UNIQUE (key_prefix)
• UNIQUE (key_hash)
• UNIQUE (salt)
• INDEX mcp_api_keys_user_id_idx (user_id)
• INDEX mcp_api_keys_project_id_idx (project_id)

Notes

• At least one of user_id or project_id must be set (enforced in application; both columns nullable in DB)
• updated_at is NOT NULL with default CURRENT_TIMESTAMP in schema