show_running_queries

Monitor and analyze active queries on a CockroachDB cluster by filtering based on node ID, user, and minimum duration. Helps identify and optimize resource usage.

Instructions

Show currently running queries on the cluster.

Args: node_id (int): Node ID to filter (default: 1). user (str): Username to filter (default: 'root'). min_duration (str): Minimum query duration (default: '1:0', format: 'minutes').

Returns: The queries running on the cluster.

Input Schema

Name	Required	Default
`min_duration`	No	1:0
`node_id`	No
`user`	No	root

Input Schema (JSON Schema)

{
  "properties": {
    "min_duration": {
      "default": "1:0",
      "title": "Min Duration",
      "type": "string"
    },
    "node_id": {
      "default": 1,
      "title": "Node Id",
      "type": "integer"
    },
    "user": {
      "default": "root",
      "title": "User",
      "type": "string"
    }
  },
  "title": "show_running_queriesArguments",
  "type": "object"
}

CockroachDB MCP Server

show_running_queries

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from CockroachDB MCP Server

Related Tools

MCP directory API