Google Cloud MCP Server

execute-spanner-query

Execute SQL queries on Google Cloud Spanner by specifying an instance, database, and parameters. Use this tool to retrieve or manage Spanner data directly from the Google Cloud MCP Server.

Input Schema

Name	Required	Description
`databaseId`	No	Spanner database ID (defaults to SPANNER_DATABASE env var)
`instanceId`	No	Spanner instance ID (defaults to SPANNER_INSTANCE env var)
`params`	No	Query parameters
`sql`	Yes	The SQL query to execute

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "databaseId": {
      "description": "Spanner database ID (defaults to SPANNER_DATABASE env var)",
      "type": "string"
    },
    "instanceId": {
      "description": "Spanner instance ID (defaults to SPANNER_INSTANCE env var)",
      "type": "string"
    },
    "params": {
      "additionalProperties": {},
      "description": "Query parameters",
      "type": "object"
    },
    "sql": {
      "description": "The SQL query to execute",
      "type": "string"
    }
  },
  "required": [
    "sql"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Other Tools from Google Cloud MCP Server

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/andyl25/googlecloud-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server