Google Calendars

Provides live Google Calendars data through a read-only MCP interface for querying with LLMs.

other

0

GitHub Stars

other

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-google-calendars-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/Salesforce.prp"
      ]
    }
  }
}

You can query live Google Calendar data through a local, read-only MCP server that wraps the CData JDBC Driver. This server exposes Google Calendar information via the MCP interface, so you can ask natural language questions and receive up-to-date calendar details without writing SQL.

How to use

Once you have the MCP server running, you interact with it using an MCP client. You can ask questions like “What calendar events do I have today?” or “What is the next meeting in my calendar?” The server provides a stable, read-only gateway to your Google Calendar data, so you can retrieve tables and columns and run targeted queries through the client without managing SQL directly.

How to install

Prerequisites: make sure you have Java installed on your machine. You will also need Maven to build the server JAR.

# 1. Clone the project
git clone https://github.com/cdatasoftware/google-calendars-mcp-server-by-cdata.git
cd google-calendars-mcp-server-by-cdata

# 2. Build the server JAR with dependencies
mvn clean install

# This creates the JAR file: CDataMCP-jar-with-dependencies.jar

Additional setup details

You will need to install the CData JDBC Driver for Google Calendars and license it. After installation, configure a connection to Google Calendars to produce a JDBC URL, which you will place in a .prp file to expose the data through MCP.

Configuration snippet for the JDBC connection (example values shown as placeholders):

Prefix=googlecalendar
ServerName=CDataGoogleCalendar
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.googlecalendar.jar
DriverClass=cdata.jdbc.googlecalendar.GoogleCalendarDriver
JdbcUrl=jdbc:googlecalendar:InitiateOAuth=GETANDREFRESH;
Tables=

Running the MCP server locally

Start the MCP server using Java with the generated .prp configuration file. This runs on stdio, so it is intended for use with clients that execute on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/google-calendars.prp

Notes about using with clients

The MCP server is designed for local access. If you use a client like Claude Desktop, you will add the MCP server entry to the client’s config so the client can discover and invoke the server’s tools.

Available tools

googlecal_mcp_get_tables

Retrieves a list of calendars/tables available from the Google Calendars data source. The output lists available tables that you can further inspect.

googlecal_mcp_get_columns

Retrieves a list of columns for a specified table. Use this to understand the schema of a chosen calendar table.

googlecal_mcp_run_query

Executes a SQL SELECT query against the Google Calendars data, returning results matching the query criteria.