Google Directory MCP Server by CData

What is Google Directory MCP Server by CData?

Google Directory MCP Server by CData is a read-only Model Context Protocol (MCP) server that enables LLMs like Claude Desktop to query live data from Google Directory using natural language. It wraps the CData JDBC Driver for Google Directory, which exposes Google Directory as relational SQL models, and makes that data available through a simple MCP interface—no SQL required.

How to use Google Directory MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, install and license the CData JDBC Driver for Google Directory, then configure a .prp file with your connection details. Add the server to your Claude Desktop config (claude_desktop_config.json) using the Java command that points to the JAR and the .prp file. Run or refresh your client to start querying.

Key features of Google Directory MCP Server by CData

• Read-only access to live Google Directory data
• Exposes Google Directory as SQL tables via MCP tools
• Supports natural language queries through LLM clients
• Provides tools: get_tables, get_columns, run_query
• Uses stdio transport (client and server on same machine)

Use cases of Google Directory MCP Server by CData

• Answering questions about Google Directory users and groups via a conversational AI
• Listing available tables and columns in Google Directory for exploration
• Running read-only SQL queries against Google Directory data without writing full SQL
• Integrating Google Directory insights into AI‑powered analytics workflows

FAQ from Google Directory MCP Server by CData

Is this server read-only or can it write data?

The README explicitly states this project builds a read-only MCP server. For full create, update, delete, and action capabilities, CData offers a separate free beta server.

What are the runtime requirements?

You need Java installed, the CData JDBC Driver for Google Directory (downloaded and licensed), and the server must run on the same machine as the client because it uses stdio transport.

How do I connect to Google Directory?

Configure a .prp file with the JDBC connection string (e.g., jdbc:googledirectory:InitiateOAuth=GETANDREFRESH;), and set the path to the driver JAR and driver class (cdata.jdbc.googledirectory.GoogleDirectoryDriver).

What tools does the server expose?

It provides {servername}_get_tables (list tables), {servername}_get_columns (list columns for a table), and {servername}_run_query (execute a SQL SELECT query). All output is CSV.

Where does my data live?

The server queries Google Directory live via the JDBC driver; no data is stored by the server. The driver handles authentication and data retrieval directly from Google.