Can the agent write to my database?

Only if you allowlist a write operation. Expose just the query operation and connect a read-only Postgres role to keep it strictly investigative.

Do I need to run OpenCode myself?

No. NoClick hosts the OpenCode harness and wires both Jira and Postgres in as tools, so you skip the setup entirely.

Does it run queries on its own without me checking them?

It can only call the Postgres operations you allowlist, against the credential you provide. Scope the database role and the operation set to bound exactly what it can touch.

What makes OpenCode different here?

OpenCode is open and model-agnostic, so you have flexibility over the underlying model. NoClick handles running it and connecting your apps as tools.

How do I give OpenCode tools?

Connect an integration node to the agent's tools handle and choose the operations to allow. Each becomes a tool the agent can call.

Do I manage any infrastructure?

No. NoClick runs the OpenCode harness in a hosted sandbox and resolves credentials for the apps you connect.

Can it combine several apps?

Yes. Add as many integrations as you need and the agent can use them together in one run.

Connect OpenCode to Jira and PostgreSQL

Give OpenCode your Jira and a Postgres connection and it can investigate a bug ticket by actually querying the data behind it. It pulls the issue details from Jira, runs read queries against your database to confirm what is happening, and writes its findings back as a comment. That closes the gap between a vague bug report and a grounded diagnosis.

Loading preview…

Opens a workflow with 233 tools ready to use.

Tools OpenCode gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Jira

193 tools

Get Issue

Get a specific issue by key or ID

Search Issues with Jql

Search for issues using JQL

Create Issue

Create a new issue

Update Issue

Update an existing issue

Transition Issue Status

Transition an issue to a new status

List Issue Transitions

List available transitions for an issue

Add Comment to Issue

Add a comment to an issue

Delete Issue

Delete an issue

List Projects

List accessible projects

Get Project

Get project details

Search Users

Search for users

Get Current User

Get current user details

Get Attachment Metadata

Get metadata for an attachment

Download Attachment

Download an attachment (returns content as base64)

Delete Attachment

Delete an attachment

Add Attachment to Issue

Add attachment to an issue

List Issue Attachments

Get all attachments for an issue

Get Attachment Human Readable

Get attachment with expanded human-readable data

Add Worklog to Issue

Add worklog to an issue (time tracking)

Get Worklog

Get a worklog by ID

Update Worklog

Update a worklog

Delete Worklog

Delete a worklog

List Issue Worklogs

Get all worklogs for an issue

List Deleted Worklog Ids

Get list of IDs for deleted worklogs

List Updated Worklog Ids

Get list of IDs for updated worklogs

List Worklog Property Keys

Get all worklog property keys for a worklog

Create Project Component

Create a project component

Get Component

Get a component by ID

Update Component

Update a component

Delete Component

Delete a component

List Project Components

Get all components for a project

Get Component Issue Count

Get issue count for a component

Create Project Version

Create a project version/release

Get Version

Get a version by ID

Update Version

Update a version

Delete Version

Delete a version

List Project Versions

Get all versions for a project

Merge Project Versions

Merge two versions

Move Version Position

Move version position

Get Version Issue Counts

Get issue counts for a version

Get Version Unresolved Count

Get count of unresolved issues for a version

Get Issue Link

Get an issue link by ID

Link Two Issues

Create a link between two issues

Delete Issue Link

Delete an issue link

List Issue Watchers

Get watchers for an issue

Add Watcher to Issue

Add watcher to an issue

Remove Watcher from Issue

Remove watcher from an issue

List Priorities

Get all priorities

Get Priority

Get a priority by ID

List Resolutions

Get all resolutions

Get Resolution

Get a resolution by ID

List Statuses

Get all statuses

Get Status

Get a status by ID

List Issue Types

Get all issue types

Get Issue Type

Get an issue type by ID

List Project Issue Types

Get issue types for a project

Create Jql Filter

Create a filter (saved JQL query)

Get Filter

Get a filter by ID

Update Filter

Update a filter

Delete Filter

Delete a filter

Search Filters

Search for filters

Get Issue Comment

Get a comment by ID

List Issue Comments

Get all comments for an issue

Update Issue Comment

Update a comment

Delete Issue Comment

Delete a comment

List Fields

Get all fields

Create Custom Field

Create a custom field

List Boards

Get all boards

Get Board

Get a board by ID

List Board Issues

Get issues for a board

Get Board Backlog

Get backlog issues for a board

List Board Sprints

Get sprints for a board

Get Sprint

Get a sprint by ID

Create Sprint

Create a sprint

Update Sprint

Update a sprint

Delete Sprint

Delete a sprint

List Sprint Issues

Get issues in a sprint

Move Issues to Sprint

Move issues to a sprint

Get Epic

Get an epic by ID or key

List Epic Issues

Get issues in an epic

Move Issues to Epic

Move issues to an epic

List Issue Remote Links

Get remote links for an issue

Create Remote Link on Issue

Create a remote link on an issue

Delete Remote Link

Delete a remote link

Get Issue Labels

Get all labels for an issue

Add Labels to Issue

Add labels to an issue

Replace Issue Labels

Set labels for an issue (replaces existing)

Get Issue Property

Get a property value for an issue

Set Issue Property

Set a property value for an issue

Delete Issue Property

Delete a property from an issue

List Issue Property Keys

Get all property keys for an issue

Get Current User Permissions

Get permissions for the current user

List All Permissions

Get all permissions in the system

Check User Permissions

Check if user has specific permissions

List Permission Schemes

Get all permission schemes

Get Permission Scheme

Get a permission scheme by ID

Create Permission Scheme

Create a new permission scheme

Delete Permission Scheme

Delete a permission scheme

List Groups

Get all groups

Get Group

Get a group by name

Create Group

Create a new group

Delete Group

Delete a group

Add User to Group

Add a user to a group

Remove User from Group

Remove a user from a group

List Group Members

Get members of a group

List Project Roles

Get all project roles for a project

Get Project Role

Get a specific project role

Add Actors to Project Role

Add actors (users/groups) to a project role

Remove Actors from Project Role

Remove actors from a project role

List Screens

Get all screens

Get Screen

Get a screen by ID

List Screen Tabs

Get all tabs for a screen

List Screen Tab Fields

Get all fields for a screen tab

List Issue Security Schemes

Get all issue security schemes

Get Issue Security Scheme

Get an issue security scheme by ID

List Notification Schemes

Get all notification schemes

Get Notification Scheme

Get a notification scheme by ID

List Workflows

Get all workflows

Get Workflow

Get a workflow by name

List Workflow Schemes

Get all workflow schemes

Get Workflow Scheme

Get a workflow scheme by ID

List Dashboards

Get all dashboards

Get Dashboard

Get a dashboard by ID

Create Dashboard

Create a new dashboard

Update Dashboard

Update a dashboard

Delete Dashboard

Delete a dashboard

Get Audit Log

Get audit log records

Search Projects

Search for projects

Get Application Property

Get an application property

Get Jira Server Info

Get Jira server information

List Issue Link Types

Get all issue link types

Get Issue Link Type

Get an issue link type by ID

Create Issue Link Type

Create a new issue link type

Update Issue Link Type

Update an issue link type

Delete Issue Link Type

Delete an issue link type

List Field Configurations

Get all field configurations

Get Field Configuration

Get a field configuration by ID

List Field Configuration Schemes

Get all field configuration schemes

Get Field Configuration Scheme

Get a field configuration scheme by ID

List Issue Type Schemes

Get all issue type schemes

Get Issue Type Scheme

Get an issue type scheme by ID

Create Issue Type Scheme

Create an issue type scheme

Update Issue Type Scheme

Update an issue type scheme

Delete Issue Type Scheme

Delete an issue type scheme

List Issue Type Screen Schemes

Get all issue type screen schemes

Get Issue Type Screen Scheme

Get an issue type screen scheme by ID

Get Priority Scheme

Get a priority scheme by ID

List Priority Schemes

Get all priority schemes

Archive Project

Archive a project

Restore Archived Project

Restore an archived project

Get Project Category

Get a project category by ID

List Project Categories

Get all project categories

Create Project Category

Create a project category

Update Project Category

Update a project category

Delete Project Category

Delete a project category

Assign Issue to User

Assign an issue to a user

Get Issue Changelog

Get changelog for an issue

Send Issue Notification

Send notification for an issue

Get Issue Votes

Get votes for an issue

Add Vote to Issue

Add vote to an issue

Remove Vote from Issue

Remove vote from an issue

Get User

Get a user by account ID

List User Groups

Get groups that a user belongs to

List User Properties

Get all properties for a user

Get User Property

Get a property for a user

Set User Property

Set a property for a user

Delete User Property

Delete a property from a user

Bulk Create Issues

Create multiple issues in bulk

Bulk Update Issues

Update multiple issues in bulk

Bulk Delete Issues

Delete multiple issues in bulk

List Project Avatars

Get all avatars for a project

List Issue Type Avatars

Get all avatars for an issue type

List Application Properties

Get all application properties

Set Application Property

Set an application property

Get Global Configuration

Get global configuration

Get Issue Security Level

Get issue security level by ID

Create Status

Create a new status

Update Status

Update a status

Delete Status

Delete a status

Create Resolution

Create a new resolution

Update Resolution

Update a resolution

Delete Resolution

Delete a resolution

Create Priority

Create a new priority

Update Priority

Update a priority

Delete Priority

Delete a priority

Create Issue Type

Create a new issue type

Update Issue Type

Update an issue type

Delete Issue Type

Delete an issue type

Validate Jql Query

Validate a JQL query

Get Jql Autocomplete Suggestions

Get auto-complete suggestions for JQL

Get Current User Preferences

Get current user preferences

Set Current User Preference

Set a user preference

Get Jira License Info

Get Jira license information

PostgreSQL

40 tools

Run Select Query

Execute a SELECT query and return results as JSON

Execute Sql Statement

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

Execute Batch Statements

Execute a statement with multiple parameter sets (batch operations)

Run Query with Cursor

Execute query with cursor for large result sets

Copy Data to Table

Bulk import data to a table using COPY

Copy Data from Table

Bulk export data from a table using COPY

List Schema Tables

List all tables in a schema

List Table Columns

Get column metadata for a table

Get Table Info

Get detailed information about a table including constraints and indexes

Create Table

Create a new table

Drop Table

Drop a table

Truncate Table

Truncate a table (remove all rows)

List Schemas

List all schemas in the database

Create Schema

Create a new schema

Drop Schema

Drop a schema

List Databases

List all databases in the PostgreSQL server

List Schema Indexes

List all indexes in a schema

Create Index

Create an index on a table

Drop Index

Drop an index

List Schema Views

List all views in a schema

Create View

Create a view

Drop View

Drop a view

List Schema Sequences

List all sequences in a schema

Get Sequence Next Value

Get the next value from a sequence (nextval)

Get Sequence Current Value

Get the current value from a sequence (currval)

Set Sequence Value

Set the current value of a sequence (setval)

List Schema Functions

List all functions in a schema

Call Database Function

Call a PostgreSQL function

List Table Constraints

List all constraints for a table

List Schema Triggers

List all triggers in a schema

List Extensions

List all installed extensions

Install Extension

Create/install an extension

List Database Users

List all database users

List Database Roles

List all database roles

Explain Query Plan

Explain a query's execution plan

Vacuum Table

Vacuum a table to reclaim storage and update statistics

Analyze Table Statistics

Analyze a table to update statistics

Begin Transaction

Begin a new transaction

Commit Transaction

Commit the current transaction

Rollback Transaction

Rollback the current transaction

What you can build

Read a Jira bug report, query Postgres to reproduce the data condition, and comment the findings on the ticket

Generate a data-backed summary table from Postgres and attach it to the relevant Jira issue

Open a Jira issue when a scheduled Postgres query returns rows that breach a threshold

Pull metrics from Postgres to fill in the acceptance criteria on a Jira story

About OpenCode

OpenCode is an open, model-agnostic command-line coding agent. In NoClick it runs hosted and gains your apps as tools, so it can act on real systems rather than just edit files. Wire an integration into the agent and OpenCode can use that app’s operations directly while it works. It is a flexible choice when you want an open agent with broad model support and real tool access.

Open and model-agnostic

Flexible across many underlying models

Good general-purpose tool use

Lightweight to point at a focused task