Skip to main content
Glama
Sign In
BigQuery Austin Bikeshare MCP Server

BigQuery Austin Bikeshare MCP Server

by mohrstade
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Local

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.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    This server cannot be deployed

    One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

    Resources

    Related MCP Connectors

    Related MCP Servers

    • bonnard

      bonnardofficial

      bonnard-data
      A
      license
      Not graded
      quality
      F
      maintenance
      Open-source agentic schema layer. Define metrics once in YAML, query governed data from any warehouse (Snowflake, BigQuery, Databricks, PostgreSQL, DuckDB) via MCP.
      28
      Apache 2.0

    • semantic-mcp

      stefbartieri
      A
      license
      A
      quality
      C
      maintenance
      Exposes a governed semantic layer to AI agents so they select metrics and dimensions from a closed, engineer-declared vocabulary instead of writing SQL. Validates every typed call against the contract, rejects out-of-contract requests with structured errors and suggestions, and returns query rows together with the compiled SQL and dbt lineage for auditing.
      4
      MIT