google-calendars-mcp-server-by-cdata

The CData MCP Server for Google Calendars is designed to facilitate the interaction between large language models (LLMs) and Google Calendars by providing a read-only interface. This server leverages the CData JDBC Driver to expose Google Calendars as relational SQL models, enabling LLMs to access live calendar data through natural language queries without the need for SQL knowledge. The server is particularly useful for applications like Claude Desktop, where users can query calendar data seamlessly. The setup involves cloning the repository, building the server, and configuring the connection using the CData JDBC Driver. The server supports various platforms and can be integrated with different clients to enhance data accessibility and interaction.

Features

• Read-only access to Google Calendars data through MCP interface.
• Integration with CData JDBC Driver for relational SQL model exposure.
• Natural language querying capability for LLMs without SQL knowledge.
• Support for various platforms including Windows, Mac, and Linux.
• Simplified setup and configuration process for easy deployment.

MCP Tools

• {'get_tables': 'Retrieves a list of tables available in the data source.'}
• {'get_columns': 'Retrieves a list of columns for a table.'}
• {'run_query': 'Execute a SQL SELECT query.'}

Usage with Different Platforms

claude_desktop_windows

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

claude_desktop_linux_mac

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