Confluence Automation via Rube MCP

Automate Confluence operations including page creation and updates, content search with CQL, space management, label tagging, and page hierarchy navigation through Composio's Confluence toolkit.

Prerequisites

• Rube MCP must be connected (RUBESEARCHTOOLS available)
• Active Confluence connection via RUBEMANAGECONNECTIONS with toolkit confluence
• Always call RUBESEARCHTOOLS first to get current tool schemas

Setup

Get Rube MCP: Add https://rube.app/mcp as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works.

1. Verify Rube MCP is available by confirming RUBESEARCHTOOLS responds
2. Call RUBEMANAGECONNECTIONS with toolkit confluence
3. If connection is not ACTIVE, follow the returned auth link to complete Confluence OAuth
4. Confirm connection status shows ACTIVE before running any workflows

Core Workflows

1. Create and Update Pages

When to use: User wants to create new documentation or update existing Confluence pages

Tool sequence:

1. CONFLUENCEGETSPACES - List spaces to find the target space ID [Prerequisite]
2. CONFLUENCESEARCHCONTENT - Find existing page to avoid duplicates or locate parent [Optional]
3. CONFLUENCEGETPAGEBYID - Get current page content and version number before updating [Prerequisite for updates]
4. CONFLUENCECREATEPAGE - Create a new page in a space [Required for creation]
5. CONFLUENCEUPDATEPAGE - Update an existing page with new content and incremented version [Required for updates]
6. CONFLUENCEADDCONTENT_LABEL - Tag the page with labels after creation [Optional]

Key parameters:

• spaceId: Space ID or key (e.g., "DOCS", "12345678") -- space keys are auto-converted to IDs
• title: Page title (must be unique within a space)
• parentId: Parent page ID for creating child pages; omit to place under space homepage
• body.storage.value: HTML/XHTML content in Confluence storage format
• body.storage.representation: Must be "storage" for create operations
• version.number: For updates, must be current version + 1
• version.message: Optional change description

Pitfalls:

• Confluence enforces unique page titles per space; creating a page with a duplicate title will fail
• UPDATEPAGE requires version.number set to current version + 1; always fetch current version first with GETPAGEBYID
• Content must be in Confluence storage format (XHTML), not plain text or Markdown
• CREATEPAGE uses body.storage.value while UPDATEPAGE uses body.value with body.representation
• GETPAGEBY_ID requires a numeric long ID, not a UUID or string

2. Search Content

When to use: User wants to find pages, blog posts, or content across Confluence

Tool sequence:

1. CONFLUENCESEARCHCONTENT - Keyword search with intelligent relevance ranking [Required]
2. CONFLUENCECQLSEARCH - Advanced search using Confluence Query Language [Alternative]
3. CONFLUENCEGETPAGEBYID - Hydrate full content for selected search results [Optional]
4. CONFLUENCEGETPAGES - Browse pages sorted by date when search relevance is weak [Fallback]

Key parameters for SEARCH_CONTENT:

• query: Search text matched against page titles with intelligent ranking
• spaceKey: Limit search to a specific space
• limit: Max results (default 25, max 250)
• start: Pagination offset (0-based)

Key parameters for CQL_SEARCH:

• cql: CQL query string (e.g., text ~ "API docs" AND space = DOCS AND type = page)
• expand: Comma-separated properties (e.g., content.space, content.body.storage)
• excerpt: highlight, indexed, or none
• limit: Max results (max 250; reduced to 25-50 when using body expansions)

CQL operators and fields:

• Fields: text, title, label, space, type, creator, lastModified, created, ancestor
• Operators: =, !=, ~ (contains), !~, >, <, >=, <=, IN, NOT IN
• Functions: currentUser(), now("-7d"), now("-30d")
• Example: title ~ "meeting" AND lastModified > now("-7d") ORDER BY lastModified DESC

Pitfalls:

• CONFLUENCESEARCHCONTENT fetches up to 300 pages and applies client-side filtering -- not a true full-text search
• CONFLUENCECQLSEARCH is the real full-text search; use text ~ "term" for content body search
• HTTP 429 rate limits can occur; throttle to ~2 requests/second with backoff
• Using body expansions in CQL_SEARCH may reduce max results to 25-50
• Search indexing is not immediate; recently created pages may not appear

3. Manage Spaces

When to use: User wants to list, create, or inspect Confluence spaces

Tool sequence:

1. CONFLUENCEGETSPACES - List all spaces with optional filtering [Required]
2. CONFLUENCEGETSPACEBYID - Get detailed metadata for a specific space [Optional]
3. CONFLUENCECREATESPACE - Create a new space with key and name [Optional]
4. CONFLUENCEGETSPACE_PROPERTIES - Retrieve custom metadata stored as space properties [Optional]
5. CONFLUENCEGETSPACE_CONTENTS - List pages, blog posts, or attachments in a space [Optional]
6. CONFLUENCEGETLABELSFORSPACE - List labels on a space [Optional]

Key parameters:

• key: Space key -- alphanumeric only, no underscores or hyphens (e.g., DOCS, PROJECT1)
• name: Human-readable space name
• type: global or personal
• status: current (active) or archived
• spaceKey: For GETSPACECONTENTS, filters by space key
• id: Numeric space ID for GETSPACEBY_ID (NOT the space key)

Pitfalls:

• Space keys must be alphanumeric only (no underscores, hyphens, or special characters)
• GETSPACEBYID requires numeric space ID, not the space key; use GETSPACES to find numeric IDs
• Clickable space URLs may need assembly: join links.webui (relative) with links.base
• Default pagination is 25; set limit explicitly (max 200 for spaces)

4. Navigate Page Hierarchy and Labels

When to use: User wants to explore page trees, child pages, ancestors, or manage labels

Tool sequence:

1. CONFLUENCESEARCHCONTENT - Find the target page ID [Prerequisite]
2. CONFLUENCEGETCHILD_PAGES - List direct children of a parent page [Required]
3. CONFLUENCEGETPAGE_ANCESTORS - Get the full ancestor chain for a page [Optional]
4. CONFLUENCEGETLABELSFORPAGE - List labels on a specific page [Optional]
5. CONFLUENCEADDCONTENT_LABEL - Add labels to a page [Optional]
6. CONFLUENCEGETLABELSFORSPACE_CONTENT - List labels across all content in a space [Optional]
7. CONFLUENCEGETPAGE_VERSIONS - Audit edit history for a page [Optional]

Key parameters:

• id: Page ID for child pages, ancestors, labels, and versions
• cursor: Opaque pagination cursor for GETCHILDPAGES (from _links.next)
• limit: Items per page (max 250 for child pages)
• sort: Child page sort options: id, -id, created-date, -created-date, modified-date, -modified-date, child-position, -child-position

Pitfalls:

• GETCHILDPAGES only returns direct children, not nested descendants; recurse for full tree
• Pagination for GETCHILDPAGES uses cursor-based pagination (not start/limit)
• Verify the correct page ID from search before using as parent; search can return similar titles
• GETPAGEVERSIONS requires the page ID, not a version number

Common Patterns

ID Resolution

Always resolve human-readable names to IDs before operations:

• Space key -> Space ID: CONFLUENCEGETSPACES with spaceKey filter, or CREATE_PAGE accepts space keys directly
• Page title -> Page ID: CONFLUENCESEARCHCONTENT with query param, then extract page ID
• Space ID from URL: Extract numeric ID from Confluence URLs or use GET_SPACES

Pagination

Confluence uses two pagination styles:

• Offset-based (most endpoints): start (0-based offset) + limit (page size). Increment start by limit until fewer results than limit are returned.
• Cursor-based (GETCHILDPAGES, GETPAGES): Use the cursor from links.next in the response. Continue until no next link is present.

Content Formatting

• Pages use Confluence storage format (XHTML), not Markdown
• Basic elements: <p>, <h1>-<h6>, <strong>, <em>, <code>, <ul>, <ol>, <li>
• Tables: <table><tbody><tr><th> / <td> structure
• Macros: <ac:structured-macro ac:name="code"> for code blocks, etc.
• Always wrap content in proper XHTML tags

Known Pitfalls

ID Formats

• Space IDs are numeric (e.g., 557060); space keys are short strings (e.g., DOCS)
• Page IDs are numeric long values for GETPAGEBY_ID; some tools accept UUID format
• GETSPACEBY_ID requires numeric ID, not the space key
• GETPAGEBY_ID takes an integer, not a string

Rate Limits

• HTTP 429 can occur on search endpoints; honor Retry-After header
• Throttle to ~2 requests/second with exponential backoff and jitter
• Body expansion in CQL_SEARCH reduces result limits to 25-50

Content Format

• Content must be Confluence storage format (XHTML), not Markdown or plain text
• Invalid XHTML will cause page creation/update to fail
• CREATEPAGE nests body under body.storage.value; UPDATEPAGE uses body.value + body.representation

Version Conflicts

• Updates require exact next version number (current + 1)
• Concurrent edits can cause version conflicts; always fetch current version immediately before updating
• Title changes during update must still be unique within the space

Quick Reference

When to Use

This skill is applicable to execute the workflow or actions described in the overview.

Example

User request:

Automate Confluence page creation, content search, space management, labels, and hierarchy navigation via Rube MCP (Composio).

Limitations

• Use this skill only when the task clearly matches the scope described above.
• Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
• Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.