Google Spannervf.sr

listing.by · home.legend.verified

Manage Spanner instances, databases and schemas, and run SQL queries and transactions against Google Cloud Spanner.

state.auth.long (state.auth.title)Streamable HTTP

listing.connect

listing.explain.oauth

https://spanner.googleapis.com/mcp

listing.note.oauth

act.add_to a11y.new_tabact.add_to a11y.new_tabact.add_to a11y.new_tab

listing.share.h

listing.share.p

mcp.tc/i/spanner

listing.about

Connects to Google Cloud Spanner. You can list and inspect instances and configs, create or update instances, create databases, read and change schemas, create sessions, run SQL with parameters, commit transactions, check query plans and poll long-running operations.

It runs as a hosted remote endpoint at spanner.googleapis.com/mcp using streamable HTTP. Access uses Google OAuth 2.0 and IAM permissions, and the MCP endpoint must be enabled for the project first. Some tools write data or change schemas, so use IAM roles that match what you want the assistant to do.

listing.can

  • List and inspect Spanner instances and instance configs
  • Create and update Spanner instances
  • Create databases and list them per instance
  • Read and update database schema (DDL)
  • Run read-only or read-write SQL with parameters
  • Commit transactions in a session
  • Get query plans without executing the query
  • Poll long-running operations

listing.tools 16

  • get_instancelisting.hint.ro

    Get information about a Spanner instance.

  • list_instanceslisting.hint.ro

    List Spanner instances in a project, with paging.

  • list_configslisting.hint.ro

    List instance configs in a project, with paging.

  • get_configlisting.hint.ro

    Get details of a Spanner instance configuration.

  • create_instancelisting.hint.writes

    Create a Spanner instance in a project.

  • update_instancelisting.hint.writes

    Update a Spanner instance.

  • create_databaselisting.hint.writes

    Create a Spanner database in an instance.

  • get_database_ddllisting.hint.ro

    Get the schema of a database.

  • list_databaseslisting.hint.ro

    List databases in a Spanner instance.

  • create_sessionlisting.hint.ro

    Create a session in a database for running SQL.

  • execute_sqllisting.hint.delete

    Execute a SQL statement in a session, including writes.

  • execute_sql_readonlylisting.hint.ro

    Execute a SQL query in a read-only transaction.

listing.tools_more
  • commitlisting.hint.delete

    Commit a transaction in a session.

  • update_database_schemalisting.hint.delete

    Apply schema change statements to a database.

  • get_operationlisting.hint.ro

    Get status of a long-running operation.

  • get_query_planlisting.hint.ro

    Get the execution plan for a SQL query without running it.

listing.prov.live_on listing.prov.hints

listing.prompts

  • List the Spanner instances in my project my-project.

  • Show the schema of the orders database in instance prod-instance.

  • Run a read-only query for the 10 newest rows in the Users table.

  • Get the query plan for a SELECT on Orders filtered by CustomerId.

listing.setup.h

listing.setup.oauth

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport http spanner https://spanner.googleapis.com/mcp
  1. Start Claude Code, type /mcp, pick spanner and choose Authenticate. A browser window opens for the Google Cloud sign-in.

Add --scope user to make it available in every project, not just this one.

Claude Desktop

  1. Open Settings → Connectors and click Add custom connector.
  2. Name it Google Spanner and paste this URL:
https://spanner.googleapis.com/mcp
  1. Click Add, then Connect, and sign in when Google Cloud asks.

Claude Desktop's JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

claude.ai

  1. Open the connector form on claude.ai. This button fills in the name and URL for you:

Add to claude.ai a11y.new_tab

  1. Check that the URL reads https://spanner.googleapis.com/mcp and click Add.
  2. Click Connect and sign in when Google Cloud asks.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under Organization settings → Connectors.

ChatGPT

  1. On chatgpt.com, open Settings → Security and login and turn on Developer mode.
  2. Go to chatgpt.com/plugins and click + to create an app for a remote MCP server.
  3. Paste https://spanner.googleapis.com/mcp as the server URL and choose OAuth. ChatGPT sends you to Google Cloud to sign in.

Developer mode is available on the web for Plus, Pro, Business, Enterprise and Education accounts.

Cursor

Add to Cursor a11y.new_tab

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "spanner": {
      "url": "https://spanner.googleapis.com/mcp"
    }
  }
}

Cursor shows Needs login next to the server. Click it to sign in.

VS Code

Install in VS Code a11y.new_tab

Or from a terminal:

code --add-mcp '{"name":"spanner","type":"http","url":"https://spanner.googleapis.com/mcp"}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "spanner": {
      "type": "http",
      "url": "https://spanner.googleapis.com/mcp"
    }
  }
}

VS Code asks you to sign in the first time the server starts.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "spanner": {
      "serverUrl": "https://spanner.googleapis.com/mcp"
    }
  }
}
  1. Refresh the MCP server list in Cascade and sign in when asked.

Devin Desktop is the new name for Windsurf. It reads serverUrl (or url) for remote servers.

Codex

codex mcp add spanner --url https://spanner.googleapis.com/mcp
codex mcp login spanner

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.spanner]
url = "https://spanner.googleapis.com/mcp"

Gemini CLI

gemini mcp add --transport http spanner https://spanner.googleapis.com/mcp

Then, inside Gemini CLI, run /mcp auth spanner to sign in.

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients accept this shape. Some name the URL field differently: serverUrl in Devin Desktop, httpUrl in Gemini CLI's settings file.

{
  "mcpServers": {
    "spanner": {
      "type": "http",
      "url": "https://spanner.googleapis.com/mcp"
    }
  }
}

Zed puts servers under context_servers in its settings. Cline needs "type": "streamableHttp", or it assumes SSE.

Client only starts local servers? Bridge it with npx -y mcp-remote https://spanner.googleapis.com/mcp.

listing.faq

Can I paste mcp.tc/i/spanner into my MCP client?

No. mcp.tc links are pages, not server addresses. Connect with https://spanner.googleapis.com/mcp, so your client talks to Google Spanner directly. The sign-in token only works there anyway. The quick link is for sharing: it opens this page, with setup steps for every client.

Does Google Spanner need an API key or a sign-in?

Yes, you need a Google Cloud account. The first time your client connects, it opens Google Cloud's sign-in page. The token goes straight to the server's own URL, never through mcp.tc.

Is Google Spanner a remote or a local server?

Remote. Google Cloud hosts it at https://spanner.googleapis.com/mcp, and it speaks Streamable HTTP. There's nothing to install.

What can Google Spanner do?

It has 16 tools, including get_instance, list_instances and list_configs. You can list and inspect Spanner instances and instance configs, create and update Spanner instances and create databases and list them per instance.

Which clients can use it?

Any client that supports remote MCP servers: Claude Code, Claude Desktop, claude.ai, ChatGPT in developer mode, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.

Who wrote this page?

mcp.tc's robot read Google Spanner's own metadata (its MCP handshake, tool list and public pages), and an AI model drafted the text from it. A person reviews anything the checks can't confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

listing.em.h

listing.em.lead listing.em.how

listing.em.badge

em.prev_lightem.prev_dark
Markdown
[![Google Spanner on mcp.tc](https://mcp.tc/i/spanner/badge.svg)](https://mcp.tc/i/spanner)
HTML
<a href="https://mcp.tc/i/spanner"><img src="https://mcp.tc/i/spanner/badge.svg" alt="Google Spanner on mcp.tc" height="20"></a>

listing.em.badge_note

listing.em.widget

HTML
<script src="https://mcp.tc/w/spanner.js" async></script>

listing.em.widget_note

iframe

HTML
<iframe src="https://mcp.tc/embed/spanner" title="Google Spanner on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

listing.em.iframe_note

JSON

listing.em.json

https://mcp.tc/i/spanner.json

listing.em.fields

listing.related

listing.more_in

  • Google AlloyDBvf.sr

    Google Cloud

    state.auth.label (state.auth.title)

    Manage AlloyDB for PostgreSQL clusters, instances, backups and users, and run SQL against your databases.

    mcp.tc/i/alloydb

  • Memorystore for Valkeyvf.sr

    Google Cloud

    state.auth.label (state.auth.title)

    Manage Memorystore for Valkey instances, maintenance schedules and backups on Google Cloud.

    mcp.tc/i/memorystore-valkey

  • Google Cloud Bigtablevf.sr

    Google Cloud

    state.auth.label (state.auth.title)

    Create and manage Bigtable instances, tables and logical views, and find hot tablets in a cluster.

    mcp.tc/i/bigtable

  • Firestorevf.sr

    Google Cloud

    state.auth.label (state.auth.title)

    Read and write Firestore documents and manage databases, indexes, backups and backup schedules in Google Cloud.

    mcp.tc/i/firestore

  • Google Cloud SQLvf.sr

    Google Cloud

    state.auth.label (state.auth.title)

    Create and manage Cloud SQL instances, users and backups, and run SQL queries against them.

    mcp.tc/i/cloud-sql

  • Google BigQueryvf.sr

    Google Cloud

    state.auth.label (state.auth.title)

    List datasets, inspect tables and run SQL queries in Google BigQuery projects, with job status and cancellation.

    mcp.tc/i/bigquery

listing.disclaimer_checked