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.