README.md•1.11 kB
# ap-training-bigquery-mcp
An MCP (Model Context Protocol) server that provides a semantic layer for BigQuery's Austin Bikeshare public dataset. It uses the boring-semantic-layer library to define structured dimensions (trip_id, subscriber_type, bike_id, bike_type, station names) and measures (total_trip_count, trip_duration), enabling simplified querying and analysis of bikeshare trip data through a well-defined interface.
## Adding to Claude Desktop
To use this MCP server with Claude Desktop, add the following configuration to your Claude Desktop config file:
**MacOS**: `~/Library/Application Support/Claude/claude_desktop_config.json`
**Windows**: `%APPDATA%/Claude/claude_desktop_config.json`
```json
{
"mcpServers": {
"bigquery-bikeshare": {
"command": "uv",
"args": [
"--directory",
"/path/to/ap-training-bigquery-mcp",
"run",
"mcp_layer.py"
]
}
}
}
```
Replace `/path/to/ap-training-bigquery-mcp` with the actual path to this repository on your system.
After adding the configuration, restart Claude Desktop to load the MCP server.