Connect OpenCode to Linear and PostgreSQL

List comments for a specific Linear issue

Create a comment on a specific Linear issue

Update an existing comment

Delete a comment

Retrieve cycles for a specific Linear team

Create a new cycle (sprint) for a team

Update an existing cycle

Archive a cycle

Retrieve a Linear document by ID

List documents in the user's Linear workspace

Create a new document. Requires exactly one of: projectId, teamId, or issueId.

Update an existing document

Delete a document

Retrieve detailed information about an issue by ID

List issues in the user's Linear workspace

Create a new Linear issue

Update an existing Linear issue

Delete a Linear issue

Search issues by query string

Archive an issue

Unarchive an issue

List workflow states (statuses) for a team

List available issue labels in a Linear workspace

Create a new Linear issue label

Update an issue label

Delete an issue label

List projects in the user's Linear workspace

Retrieve details of a specific project

Create a new project in Linear

Update an existing Linear project

Archive a project (soft delete)

Permanently delete a project

List milestones for a project

Create a project milestone

Update a project milestone

Delete a project milestone

List teams in the user's Linear workspace

Retrieve details of a specific Linear team

Retrieve users in the Linear workspace

Retrieve details of a specific Linear user

Get the currently authenticated user

List attachments for an issue

Create an attachment (link URL to issue)

Delete an attachment

List issue relations (blocks, related, duplicate)

Create a relation between issues

Delete an issue relation

List webhooks for the organization

Create a webhook

Delete a webhook

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