mohrstade/ap-training-bigquery-mcp

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

{
  "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.