Choose MCP Server
An MCP server for Claude Desktop that allows users to query data from selected Google Cloud datasets by configuring project ID and datasets in the Claude Desktop configuration.
keurcien
README
Choose MCP Server Setup
-
Start by downloading the Claude Desktop Client: https://claude.ai/download
-
Install uv
brew install uv
- Install the MCP server
Edit the claude_desktop_config.json file (located in ~/Library/Application\ Support/Claude) and add the following to the mcpServers section:
{
"mcpServers": {
"Choose MCP Server": {
"command": "uvx",
"args": ["choose-mcp-server"],
"env": {
"PROJECT_ID": YOUR_PROJECT_ID,
"DATASETS": DATASET_1,DATASET_2,DATASET_3
"DBT_MANIFEST_FILEPATH": YOUR_DBT_MANIFEST_FILEPATH
}
}
}
}
N.B: the dbt manifest file path is optional.
- Log into Google Cloud and update your Application Default Credentials (ADC)
gcloud auth login --update-adc
- Open Claude Desktop and start asking questions!
Troubleshooting
For Windows users, you may need to add the APPDATA environment variable to your Claude Desktop config file.
"env": {
"APPDATA": "C:\\Users\\YOUR_USERNAME\\AppData\\Roaming",
}
Recommended Servers
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Apple MCP Server
Enables interaction with Apple apps like Messages, Notes, and Contacts through the MCP protocol to send messages, search, and open app content using natural language.
Claude Code MCP
An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.
Excel MCP Server
A Model Context Protocol server that enables AI assistants to read from and write to Microsoft Excel files, supporting formats like xlsx, xlsm, xltx, and xltm.
Playwright MCP Server
Provides a server utilizing Model Context Protocol to enable human-like browser automation with Playwright, allowing control over browser actions such as navigation, element interaction, and scrolling.
MCP PubMed Search
Server to search PubMed (PubMed is a free, online database that allows users to search for biomedical and life sciences literature). I have created on a day MCP came out but was on vacation, I saw someone post similar server in your DB, but figured to post mine.
MCP DuckDB Knowledge Graph Memory Server
A memory server for Claude that stores and retrieves knowledge graph data in DuckDB, enhancing performance and query capabilities for conversations with persistent user information.
dbt Semantic Layer MCP Server
A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.