gcp-spanner-execute-query
Execute SQL queries on Google Cloud Spanner databases by specifying the instance, database, and query parameters. Integrates with the Google Cloud MCP Server for streamlined database interactions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| 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"
}