spanner-query-count

Track and count Spanner queries by type, status, and time range to monitor database activity. Configure instance, database, and alignment period for detailed query analysis.

Input Schema

Name	Required	Description	Default
`alignmentPeriod`	No	Alignment period for aggregating data points (e.g., "60s", "5m", "1h")	60s
`databaseId`	No	Spanner database ID (optional, if not provided will show all databases)
`endTime`	No	End time for the query (defaults to now)
`instanceId`	No	Spanner instance ID (optional, if not provided will show all instances)
`queryType`	No	Type of queries to count (ALL, READ, QUERY)	ALL
`startTime`	No	Start time for the query (e.g., "1h", "2d", "30m")	1h
`status`	No	Status of queries to count (ALL, OK, ERROR)	ALL

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "alignmentPeriod": {
      "default": "60s",
      "description": "Alignment period for aggregating data points (e.g., \"60s\", \"5m\", \"1h\")",
      "type": "string"
    },
    "databaseId": {
      "description": "Spanner database ID (optional, if not provided will show all databases)",
      "type": "string"
    },
    "endTime": {
      "description": "End time for the query (defaults to now)",
      "type": "string"
    },
    "instanceId": {
      "description": "Spanner instance ID (optional, if not provided will show all instances)",
      "type": "string"
    },
    "queryType": {
      "default": "ALL",
      "description": "Type of queries to count (ALL, READ, QUERY)",
      "enum": [
        "ALL",
        "READ",
        "QUERY"
      ],
      "type": "string"
    },
    "startTime": {
      "default": "1h",
      "description": "Start time for the query (e.g., \"1h\", \"2d\", \"30m\")",
      "type": "string"
    },
    "status": {
      "default": "ALL",
      "description": "Status of queries to count (ALL, OK, ERROR)",
      "enum": [
        "ALL",
        "OK",
        "ERROR"
      ],
      "type": "string"
    }
  },
  "type": "object"
}

Google Cloud MCP Server

spanner-query-count

Input Schema

Input Schema (JSON Schema)

Other Tools from Google Cloud MCP Server

Related Tools

MCP directory API