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.