Table: mcp_server_registration

Connected to

Referenced by:

• mcp_server_tool_grant — column server_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
name	text	no	—
url	text	no	—
transport	text	no	Default 'http'::text
auth_kind	text	no	Default 'none'::text
auth_secret_ref	text	yes	—
auth_header_name	text	yes	—
privacy_class	text	no	Default 'cloud'::text
enabled	boolean	no	Default false
rate_limit_per_second	integer	no	Default 2
rate_limit_per_minute	integer	no	Default 60
health_check_interval_s	integer	no	Default 60
last_health_check_at	timestamp	yes	—
last_health_status	text	yes	—
last_health_error	text	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
registered_by_user_ref	bigint	yes	—

Constraints

• CONSTRAINT mcp_server_registration_auth_kind_check CHECK ((auth_kind = ANY (ARRAY['none'::text, 'bearer'::text, 'header'::text, 'mtls'::text])))
• CONSTRAINT mcp_server_registration_health_check_interval_s_check CHECK ((health_check_interval_s > 0))
• CONSTRAINT mcp_server_registration_last_health_status_check CHECK (((last_health_status IS NULL) OR (last_health_status = ANY (ARRAY['healthy'::text, 'degraded'::text, 'unreachable'::text]))))
• CONSTRAINT mcp_server_registration_privacy_class_check CHECK ((privacy_class = ANY (ARRAY['local'::text, 'cloud'::text])))
• CONSTRAINT mcp_server_registration_rate_limit_per_minute_check CHECK ((rate_limit_per_minute > 0))
• CONSTRAINT mcp_server_registration_rate_limit_per_second_check CHECK ((rate_limit_per_second > 0))
• CONSTRAINT mcp_server_registration_transport_check CHECK ((transport = ANY (ARRAY['http'::text, 'stdio'::text])))

Full DDL

CREATE TABLE public.mcp_server_registration (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name text NOT NULL,
    url text NOT NULL,
    transport text DEFAULT 'http'::text NOT NULL,
    auth_kind text DEFAULT 'none'::text NOT NULL,
    auth_secret_ref text,
    auth_header_name text,
    privacy_class text DEFAULT 'cloud'::text NOT NULL,
    enabled boolean DEFAULT false NOT NULL,
    rate_limit_per_second integer DEFAULT 2 NOT NULL,
    rate_limit_per_minute integer DEFAULT 60 NOT NULL,
    health_check_interval_s integer DEFAULT 60 NOT NULL,
    last_health_check_at timestamp with time zone,
    last_health_status text,
    last_health_error text,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    registered_by_user_ref bigint,
    CONSTRAINT mcp_server_registration_auth_kind_check CHECK ((auth_kind = ANY (ARRAY['none'::text, 'bearer'::text, 'header'::text, 'mtls'::text]))),
    CONSTRAINT mcp_server_registration_health_check_interval_s_check CHECK ((health_check_interval_s > 0)),
    CONSTRAINT mcp_server_registration_last_health_status_check CHECK (((last_health_status IS NULL) OR (last_health_status = ANY (ARRAY['healthy'::text, 'degraded'::text, 'unreachable'::text])))),
    CONSTRAINT mcp_server_registration_privacy_class_check CHECK ((privacy_class = ANY (ARRAY['local'::text, 'cloud'::text]))),
    CONSTRAINT mcp_server_registration_rate_limit_per_minute_check CHECK ((rate_limit_per_minute > 0)),
    CONSTRAINT mcp_server_registration_rate_limit_per_second_check CHECK ((rate_limit_per_second > 0)),
    CONSTRAINT mcp_server_registration_transport_check CHECK ((transport = ANY (ARRAY['http'::text, 'stdio'::text])))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.