google-sheets-mcp-server-by-cdata

What is google-sheets-mcp-server-by-cdata?

google-sheets-mcp-server-by-cdata is a read-only MCP server that lets AI assistants like Claude Desktop query live Google Sheets data using natural language. It wraps the CData JDBC Driver for Google Sheets, exposing spreadsheets as relational SQL tables through a simple MCP interface.

How to use google-sheets-mcp-server-by-cdata?

Clone the repository, build the JAR with Maven, then install and license the CData JDBC Driver for Google Sheets. Create a .prp file with your JDBC connection string and configure Claude Desktop’s claude_desktop_config.json to point to both the JAR and the .prp file. After restarting Claude, you can ask natural language questions about your Google Sheets data.

Key features of google-sheets-mcp-server-by-cdata

• Read-only access to Google Sheets data via MCP tools
• Exposes Google Sheets as relational SQL models
• Provides get_tables, get_columns, and run_query tools
• No SQL required – LLMs query data with natural language
• Uses stdio transport (client must run on the same machine)
• Requires the CData JDBC Driver for Google Sheets

Use cases of google-sheets-mcp-server-by-cdata

• Ask an AI assistant “What is the correlation between my closed won opportunities and the account industry?” from a Google Sheet.
• Query “How many open tickets do I have in the SUPPORT project?” from project data stored in Google Sheets.
• Retrieve “What calendar events do I have today?” from a Google Sheets calendar.
• Explore available tables and columns in a Google Sheets spreadsheet without writing SQL.

FAQ from google-sheets-mcp-server-by-cdata

Is this server read-only?

Yes. This project builds a read-only MCP server. For full read, write, update, and delete capabilities, CData offers a free beta MCP Server for Google Sheets with a simplified setup.

What are the dependencies and runtime requirements?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Google Sheets installed and licensed on the same machine.

Where does the data live?

The data remains in Google Sheets. The server connects live to your spreadsheets via the JDBC driver; no data is stored locally by the MCP server.

How does authentication work?

The JDBC driver handles OAuth authentication. When you test the connection using the driver’s connection string utility, your browser opens so you can authenticate to Google Sheets.

What transport does this server use?

The server uses stdio transport, so it can only be used with MCP clients running on the same machine as the server.