Connect OpenCode to GitHub and PostgreSQL

Get information about a repository

List repositories for the authenticated user

List repositories for an organization

Fork a repository

List collaborators for a repository

Create a webhook for a repository

List forks of a repository

List contributors to a repository

Get languages used in a repository

Get topics for a repository

Set topics for a repository

List stargazers for a repository

Star a repository

Unstar a repository

List contents of a directory in a repository

Create a repository from a template

List repositories for a specific user

List issues for a repository

Get a specific issue

Create a new issue

Update an existing issue

List comments on an issue

Create a comment on an issue or pull request

Add labels to an issue

Add a reaction to an issue

List milestones for a repository

Create a milestone

List available assignees for a repository

List pull requests for a repository

Get a specific pull request

Create a new pull request

Update an existing pull request

Merge a pull request

List files changed in a pull request

Request reviewers for a pull request

List reviews on a pull request

Create a review on a pull request

List commits in a repository

Get a specific commit

Compare two commits

List check runs for a git reference

List branches in a repository

Create a new branch

Delete a branch

List tags in a repository

Get the contents of a file

Create or update a file in a repository

Delete a file from a repository

List releases for a repository

Get a specific release

Create a new release

List labels for a repository

Create a label

Get the authenticated user

Get a specific user

List followers of a user

List users followed by a user

List workflow runs for a repository

List workflows in a repository

Get a specific workflow run

Trigger a workflow dispatch event

Cancel a workflow run

Re-run a workflow

List deployments for a repository

Create a deployment

List notifications for the authenticated user

Mark notifications as read

List teams in an organization

List members of an organization

List gists for the authenticated user

Get a specific gist

Create a new gist

Search issues and pull requests

Search code across repositories

Search repositories

List review comments on a pull request

Create a review comment on a pull request

Get a specific review comment

Update a review comment

Delete a review comment

Reply to a review comment

Update a pending review

Delete a pending review

Get comments for a specific review

Submit a pending review

Dismiss a review

List commits on a pull request

Check if a pull request has been merged

Update pull request branch with latest base branch

Update repository settings

Delete a repository

Create a repository for the authenticated user

Transfer repository ownership

Lock an issue conversation

Unlock an issue conversation

Get a specific issue comment

Update an issue comment

Delete an issue comment

Get a label

Update a label

Delete a label

Set labels for an issue (replaces all)

Remove all labels from an issue

Remove a label from an issue

Get a milestone

Update a milestone

Delete a milestone

Update a release

Delete a release

Get the latest release

Get a release by tag name

Generate release notes

List release assets

Get a release asset

Update a release asset

Delete a release asset

Update a gist

Delete a gist

List public gists

List starred gists

Star a gist

Unstar a gist

Check if a gist is starred

Fork a gist

List gist forks

List gist commits

Get a specific gist revision

List gists for a user

List branches where commit is the HEAD

List pull requests associated with a commit

List comments for a commit

Create a comment on a commit

Create a commit status

Get a repository webhook

Update a repository webhook

Delete a repository webhook

Ping a repository webhook

Test a repository webhook

List webhook deliveries

Get a webhook delivery

Redeliver a webhook

Add a repository collaborator

Remove a repository collaborator

Get repository permissions for a user

Check if a user is a collaborator

List repository invitations

Update a repository invitation

Create a team

Get a team

Update a team

Delete a team

List team repositories

Check team permissions for a repository

Add or update team repository permissions

Remove a repository from a team

List team members

Get team membership for a user

Get an organization

Update an organization

List organization repositories (alias)

Create an organization repository

List organization invitations

Cancel an organization invitation

List organization members (alias)

Check organization membership

Remove an organization member

Get organization membership for a user

Add or update organization membership

Remove organization membership

List pending organization invitations (alias)

List organization webhooks

Create an organization webhook

List deployment statuses

Create a deployment status

Get a deployment status

Get a deployment

Delete a deployment

List reactions for an issue

Delete an issue reaction

List reactions for an issue comment

Create a reaction for an issue comment

Delete an issue comment reaction

List reactions for a commit comment

Create a reaction for a commit comment

Delete a commit comment reaction

List reactions for a PR review comment

Create a reaction for a PR review comment

Delete a PR review comment reaction

List reactions for a release

Create a reaction for a release

Delete a release reaction

List workflow run artifacts

List repository artifacts

Get an artifact

Delete an artifact

Download an artifact

Delete a workflow run

Get workflow run usage

Download workflow run logs

Delete workflow run logs

List jobs for a workflow run

Get a workflow run attempt

List jobs for a workflow run attempt

Download logs for a workflow run attempt

Approve a workflow run

List pending deployments for a workflow run

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