# 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.