bigquery MCP connection #5999

Open
opened 2026-02-16 17:59:17 -05:00 by yindo · 0 comments
Owner

Originally created by @AntoineGlacet on GitHub (Jan 14, 2026).

Originally assigned to: @rekram1-node on GitHub.

Description

bigquery MCP connection fails with non-descriptive error message

❯ opencode mcp auth bigquery

┌  MCP OAuth Authentication
│
◓  Starting OAuth flow.unknown format "uint64" ignored in schema at path "#/properties/lastModifiedTime"
unknown format "uint64" ignored in schema at path "#/properties/lastModifiedTime"
unknown format "uint64" ignored in schema at path "#/$defs/MaterializedViewDefinition/properties/refreshIntervalMs"
unknown format "uint64" ignored in schema at path "#/$defs/MaterializedViewDefinition/properties/refreshIntervalMs"
unknown format "uint64" ignored in schema at path "#/properties/numRows"
unknown format "uint64" ignored in schema at path "#/properties/numRows"
■  Authentication failed
│
■  Failed to get tools
│
└  Done

config snippet

{
  "$schema": "https://opencode.ai/config.json",
  "theme": "opencode",
  "share": "manual",
  "autoupdate": true,
  "mcp": {
    "bigquery": {
      "type": "remote",
      "url": "https://bigquery.googleapis.com/mcp",
      "oauth": {
        "clientId": BQ_0AUTH_CLIENT_ID,
        "clientSecret": "BQ_0AUTH_CLIENT_SECRET",
        "scope": "https://www.googleapis.com/auth/bigquery",
      },
      "enabled": true
    }
  }
}

Plugins

no

OpenCode version

1.1.20

Steps to reproduce

  1. configure bigquery MCP server as described in https://docs.cloud.google.com/bigquery/docs/use-bigquery-mcp#authentication-authorization
  2. test connection
  3. cry

Screenshot and/or share link

No response

Operating System

ubuntu 24.04 LTS

Terminal

No response

Originally created by @AntoineGlacet on GitHub (Jan 14, 2026). Originally assigned to: @rekram1-node on GitHub. ### Description bigquery MCP connection fails with non-descriptive error message ``` ❯ opencode mcp auth bigquery ┌ MCP OAuth Authentication │ ◓ Starting OAuth flow.unknown format "uint64" ignored in schema at path "#/properties/lastModifiedTime" unknown format "uint64" ignored in schema at path "#/properties/lastModifiedTime" unknown format "uint64" ignored in schema at path "#/$defs/MaterializedViewDefinition/properties/refreshIntervalMs" unknown format "uint64" ignored in schema at path "#/$defs/MaterializedViewDefinition/properties/refreshIntervalMs" unknown format "uint64" ignored in schema at path "#/properties/numRows" unknown format "uint64" ignored in schema at path "#/properties/numRows" ■ Authentication failed │ ■ Failed to get tools │ └ Done ``` config snippet ``` { "$schema": "https://opencode.ai/config.json", "theme": "opencode", "share": "manual", "autoupdate": true, "mcp": { "bigquery": { "type": "remote", "url": "https://bigquery.googleapis.com/mcp", "oauth": { "clientId": BQ_0AUTH_CLIENT_ID, "clientSecret": "BQ_0AUTH_CLIENT_SECRET", "scope": "https://www.googleapis.com/auth/bigquery", }, "enabled": true } } } ``` ### Plugins no ### OpenCode version 1.1.20 ### Steps to reproduce 1. configure bigquery MCP server as described in https://docs.cloud.google.com/bigquery/docs/use-bigquery-mcp#authentication-authorization 2. test connection 3. cry ### Screenshot and/or share link _No response_ ### Operating System ubuntu 24.04 LTS ### Terminal _No response_
yindo added the bug label 2026-02-16 17:59:17 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: anomalyco/opencode#5999