Connect OpenCode to Confluence and PostgreSQL

List pages, optionally filtered by space, status, or title.

Get a single page by ID, optionally including its body.

Create a page in a space.

Update a page. Requires the new version number (current + 1).

Trash (or permanently purge) a page.

List all pages within a given space.

List the direct child pages of a page.

List the version history of a page.

Get the ancestor pages (breadcrumb path) of a page.

List blog posts, optionally filtered by space or status.

Get a single blog post by ID, optionally including its body.

Create a blog post in a space.

Update a blog post. Requires the new version number (current + 1).

Delete a blog post.

List spaces, optionally filtered by key, type, or status.

Get a single space by ID.

Create a new Confluence space.

List labels applied to a space.

List footer comments on a page.

Add a footer comment to a page or blog post.

Update the body of a footer comment.

Delete a footer comment.

List footer comments on a blog post.

List inline (highlight) comments on a page.

Create an inline comment anchored to selected text on a page or blog post.

Update the body of an inline comment.

Delete an inline comment.

List inline comments on a blog post.

List attachments on a page.

Get attachment metadata, including its download link.

Upload a file as an attachment to a page (v1 multipart API).

Delete an attachment.

List labels attached to a page.

Add a label to content (page or blog post). Uses the v1 API.

Remove a label from content (page or blog post). Uses the v1 API.

List custom content properties (key/value metadata) on a page.

Set a custom content property on a page.

Update an existing content property on a page (requires the property ID and current version).

Delete a content property from a page.

List inline tasks (checkboxes) across the site or filtered by space/page.

Get a single inline task by ID.

Update an inline task (e.g., mark as complete or incomplete).

Full-text / structured search via CQL (v1). Returns search results.

CQL search returning content objects only (v1).

Get the authenticated user's account info (v1).

Execute a SELECT query and return results as JSON

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

Execute a statement with multiple parameter sets (batch operations)

Execute query with cursor for large result sets

Bulk import data to a table using COPY

Bulk export data from a table using COPY

List all tables in a schema

Get column metadata for a table

Get detailed information about a table including constraints and indexes

Create a new table

Drop a table

Truncate a table (remove all rows)

List all schemas in the database

Create a new schema

Drop a schema

List all databases in the PostgreSQL server

List all indexes in a schema

Create an index on a table

Drop an index

List all views in a schema

Create a view

Drop a view

List all sequences in a schema

Get the next value from a sequence (nextval)

Get the current value from a sequence (currval)

Set the current value of a sequence (setval)

List all functions in a schema

Call a PostgreSQL function

List all constraints for a table

List all triggers in a schema

List all installed extensions

Create/install an extension

List all database users

List all database roles

Explain a query's execution plan

Vacuum a table to reclaim storage and update statistics

Analyze a table to update statistics

Begin a new transaction

Commit the current transaction

Rollback the current transaction