Skip to content

bigquery MCP connection #8581

Closed
Closed

Description

@AntoineGlacet

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

Activity

  1. github-actions commented on Jan 15, 2026

    @github-actions
    Contributor

    This issue might be a duplicate of existing issues. Please check:

    Feel free to ignore if none of these address your specific case.

  2. thdxr commented on Mar 25, 2026

    @thdxr
    Member

    To stay organized issues are automatically closed after 90 days of no activity. If the issue is still relevant please open a new one.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions