MD_UPDATE_GUIDE_METADATA

Preview

This feature is in preview and is subject to change.

Change a Guide's title, description, or topic without appending a content version. The guide keeps its ID and full version history.

Syntax

SELECT * FROM MD_UPDATE_GUIDE_METADATA(
  id = '<guide_uuid>',
  topic = 'customer-orders',
  title = 'Updated Title'
);

Parameters

Provide at least one of title, description, or topic.

Parameter	Type	Required	Description
id	UUID	Yes	The guide's UUID.
title	VARCHAR	No	New human-readable title. Must not be empty when supplied.
description	VARCHAR	No	New one-line summary. Pass an empty string ('') to clear it.
topic	VARCHAR	No	New grouping label — for example 'revenue-billing' or 'core/metrics' (no leading or trailing slash). Pass an empty string ('') to remove the topic.

Return columns

Column	Type	Description
id	UUID	Guide UUID
topic	VARCHAR	Updated topic (NULL when cleared)
title	VARCHAR	Updated title
description	VARCHAR	Updated description
owner_id	UUID	UUID of the guide owner
owner_name	VARCHAR	Name of the guide owner
access	VARCHAR	'user' or 'organization'
current_version	UINTEGER	Latest version number (unchanged)
created_at	TIMESTAMP WITH TIME ZONE	When the guide was created
updated_at	TIMESTAMP WITH TIME ZONE	When the guide was last updated

Examples

Move a guide to a different topic:

SELECT id, topic, title
FROM MD_UPDATE_GUIDE_METADATA(
  id = 'a1b2c3d4-e5f6-7890-abcd-ef1234567890',
  topic = 'customer-orders',
  title = 'Customer Order Filters'
);

Update only the description:

SELECT description
FROM MD_UPDATE_GUIDE_METADATA(
  id = 'a1b2c3d4-e5f6-7890-abcd-ef1234567890',
  description = 'MRR and ARR definitions, including expansion and churn adjustments'
);

Remove the topic (move the guide to the root level):

SELECT topic
FROM MD_UPDATE_GUIDE_METADATA(
  id = 'a1b2c3d4-e5f6-7890-abcd-ef1234567890',
  topic = ''
);

Related

• MD_UPDATE_GUIDE — Append a content version.
• MD_SET_GUIDE_ACCESS — Change visibility.
• update_guide_metadata MCP tool — AI assistant equivalent.