MCP.so
Sign In
G

Google Spanner MCP Server by CData

@CDataSoftware

Repository

About Google Spanner MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Google Spanner (beta): https://www.cdata.com/download/download.aspx?sku=OGZK-V&type=beta

#google-spanner#mcp-server#cdata

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\google-spanner.prp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Google Spanner MCP Server by CData?

A read-only Model Context Protocol (MCP) server that allows LLMs like Claude Desktop to query live Google Spanner data using natural language. It wraps the CData JDBC Driver for Google Spanner, which exposes Google Spanner as relational SQL models.

How to use Google Spanner MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Google Spanner, configure a connection string using the driver’s utility, create a .prp file with the JDBC URL and other properties, then add the server to your Claude Desktop config file using the java -jar command pointing to the JAR and .prp file. Restart Claude Desktop to see the server.

Key features of Google Spanner MCP Server by CData

  • Read-only access to Google Spanner data
  • Natural language querying via LLMs
  • Built‑in tools: get_tables, get_columns, run_query
  • Returns data in CSV format
  • Uses stdio transport for local clients
  • Requires CData JDBC Driver for Google Spanner

Use cases of Google Spanner MCP Server by CData

  • Ask an AI assistant about Google Spanner data without writing SQL
  • Explore table schemas and columns in Google Spanner
  • Retrieve live business data from Google Spanner for analysis
  • Integrate Google Spanner data into AI‑powered chat workflows

FAQ from Google Spanner MCP Server by CData

Is the server read-only?

Yes, this project builds a read-only MCP server that supports only SELECT queries.

What tools does the server provide?

Three tools: {servername}_get_tables (list tables), {servername}_get_columns (list columns of a table), and {servername}_run_query (execute a SQL SELECT query).

What are the runtime dependencies?

You need Java, the CData JDBC Driver for Google Spanner (installed and licensed), and the built JAR file CDataMCP-jar-with-dependencies.jar.

How is the server transported?

It uses stdio transport, so it can only be used with clients running on the same machine.

How do I authenticate to Google Spanner?

Authentication is handled by the CData JDBC Driver. The README mentions OAuth support; you will need to authenticate in your browser when testing the connection via the driver’s connection string utility.

Frequently asked questions

Is the server read-only?

Yes, this project builds a read-only MCP server that supports only SELECT queries.

What tools does the server provide?

Three tools: `{servername}_get_tables` (list tables), `{servername}_get_columns` (list columns of a table), and `{servername}_run_query` (execute a SQL SELECT query).

What are the runtime dependencies?

You need Java, the CData JDBC Driver for Google Spanner (installed and licensed), and the built JAR file `CDataMCP-jar-with-dependencies.jar`.

How is the server transported?

It uses `stdio` transport, so it can only be used with clients running on the same machine.

How do I authenticate to Google Spanner?

Authentication is handled by the CData JDBC Driver. The README mentions OAuth support; you will need to authenticate in your browser when testing the connection via the driver’s connection string utility.

Comments

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

More Other MCP servers

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Peekaboo MCP – lightning-fast macOS screenshots for AI agents

steipete

Peekaboo is a macOS CLI & optional MCP server that enables AI agents to capture screenshots of applications, or the entire system, with optional visual question answering through local or remote AI models.

4.8K

IDA Pro MCP

mrexodia

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.

9.9K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Mobile Mcp

mobile-next

Model Context Protocol Server for Mobile Automation and Scraping (iOS, Android, Emulators, Simulators and Real Devices)

5.4K