Skip to content

Conversation

@johanesalxd
Copy link
Contributor

Problem

Fixes #1378 - BigQuery Conversational Analytics tool fails with ACCESS_TOKEN_SCOPE_INSUFFICIENT error in Cloud Run environments while other BigQuery tools work fine.

Root Cause

The conversational analytics tool was using BigQueryTokenSource() with limited bigqueryapi.Scope, but the Gemini Data Analytics API (geminidataanalytics.googleapis.com) requires broader cloud-platform scope.

Solution

  • Replace ADC token acquisition to use google.DefaultTokenSource with cloud-platform scope
  • Remove dependency on limited BigQuery scope from source
  • Maintain compatibility with existing OAuth flow

Testing

Impact

  • Fixes: Cloud Run deployment authentication errors
  • Maintains: Local development functionality
  • Preserves: All existing BigQuery tool functionality

@johanesalxd johanesalxd requested a review from a team as a code owner September 9, 2025 10:49
@averikitsch averikitsch assigned duwenxin99 and unassigned averikitsch Sep 9, 2025
@duwenxin99
Copy link
Contributor

Hi @Genesis929, could you take a look at this PR? Thanks!

Genesis929
Genesis929 previously approved these changes Sep 10, 2025
@Genesis929 Genesis929 changed the title Fix BigQuery Conversational Analytics authentication scope error in Cloud Run Fix(tools/bigquery-conversational-analytics): fix authentication scope error in Cloud Run Sep 10, 2025
@Genesis929 Genesis929 dismissed their stale review September 10, 2025 18:19

Need to add one comment.

- Replace limited BigQuery scope with cloud-platform scope for ADC
- Remove dependency on BigQueryTokenSource for Gemini Data Analytics API
- Maintain OAuth compatibility while fixing Cloud Run authentication

The conversational analytics tool was using BigQueryTokenSource() with limited
bigqueryapi.Scope, but the Gemini Data Analytics API requires broader
cloud-platform scope. This change ensures proper authentication in Cloud Run
environments while preserving local development functionality.

Fixes googleapis#1378
@johanesalxd johanesalxd force-pushed the fix/bigquery-conversational-analytics-scope-issue branch from 2b18c28 to aa1695a Compare September 11, 2025 00:46
johanesalxd added a commit to johanesalxd/bq-agent-app that referenced this pull request Sep 13, 2025
@johanesalxd
Copy link
Contributor Author

thanks @Genesis929 and @duwenxin99 . just want to check if anything else needed from my side?

@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 15, 2025
@github-actions github-actions bot removed the tests: run Label to trigger Github Action tests. label Sep 15, 2025
@Genesis929
Copy link
Contributor

/gcbrun

@Genesis929
Copy link
Contributor

thanks @Genesis929 and @duwenxin99 . just want to check if anything else needed from my side?

Thanks for your great work! We will merge it soon.

@Genesis929
Copy link
Contributor

/gcbrun

@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 17, 2025
@github-actions github-actions bot removed the tests: run Label to trigger Github Action tests. label Sep 17, 2025
@Genesis929 Genesis929 enabled auto-merge (squash) September 17, 2025 22:55
@Genesis929
Copy link
Contributor

/gcbrun

@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 17, 2025
@github-actions github-actions bot removed the tests: run Label to trigger Github Action tests. label Sep 17, 2025
@Genesis929 Genesis929 merged commit 80b7488 into googleapis:main Sep 17, 2025
10 checks passed
github-actions bot pushed a commit to Genesis929/genai-toolbox that referenced this pull request Sep 17, 2025
…ion scope error in Cloud Run (googleapis#1381)

## Problem
Fixes googleapis#1378 - BigQuery Conversational Analytics tool fails with
`ACCESS_TOKEN_SCOPE_INSUFFICIENT` error in Cloud Run environments while
other BigQuery tools work fine.

## Root Cause
The conversational analytics tool was using `BigQueryTokenSource()` with
limited `bigqueryapi.Scope`, but the Gemini Data Analytics API
(`geminidataanalytics.googleapis.com`) requires broader `cloud-platform`
scope.

## Solution
- Replace ADC token acquisition to use `google.DefaultTokenSource` with
`cloud-platform` scope
- Remove dependency on limited BigQuery scope from source
- Maintain compatibility with existing OAuth flow

## Testing
- ✅ **Local testing confirmed**: Tool now works perfectly
- ✅ **Test script**:
https://github.com/johanesalxd/bq-agent-app/blob/main/setup/mcp_toolbox_ca_issue/test_detailed_error.py
- ✅ **Successful response**: Returns proper schema information and
conversational answers
- ✅ **All BigQuery tool tests pass**: No regression in other tools
- ✅ **Build successful**: No compilation errors

## Impact
- **Fixes**: Cloud Run deployment authentication errors
- **Maintains**: Local development functionality
- **Preserves**: All existing BigQuery tool functionality

---------

Co-authored-by: Huan Chen <142538604+Genesis929@users.noreply.github.com> 80b7488
github-actions bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Sep 17, 2025
…ion scope error in Cloud Run (googleapis#1381)

## Problem
Fixes googleapis#1378 - BigQuery Conversational Analytics tool fails with
`ACCESS_TOKEN_SCOPE_INSUFFICIENT` error in Cloud Run environments while
other BigQuery tools work fine.

## Root Cause
The conversational analytics tool was using `BigQueryTokenSource()` with
limited `bigqueryapi.Scope`, but the Gemini Data Analytics API
(`geminidataanalytics.googleapis.com`) requires broader `cloud-platform`
scope.

## Solution
- Replace ADC token acquisition to use `google.DefaultTokenSource` with
`cloud-platform` scope
- Remove dependency on limited BigQuery scope from source
- Maintain compatibility with existing OAuth flow

## Testing
- ✅ **Local testing confirmed**: Tool now works perfectly
- ✅ **Test script**:
https://github.com/johanesalxd/bq-agent-app/blob/main/setup/mcp_toolbox_ca_issue/test_detailed_error.py
- ✅ **Successful response**: Returns proper schema information and
conversational answers
- ✅ **All BigQuery tool tests pass**: No regression in other tools
- ✅ **Build successful**: No compilation errors

## Impact
- **Fixes**: Cloud Run deployment authentication errors
- **Maintains**: Local development functionality
- **Preserves**: All existing BigQuery tool functionality

---------

Co-authored-by: Huan Chen <142538604+Genesis929@users.noreply.github.com> 80b7488
Yuan325 added a commit that referenced this pull request Sep 19, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.15.0](v0.14.0...v0.15.0)
(2025-09-18)


### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([#1421](#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([#1449](#1449))

### Features

* Add AlloyDB admin source
([#1369](#1369))
([33beb71](33beb71))
* Add Cloud monitoring source and tool
([#1311](#1311))
([d661f53](d661f53))
* Add YugabyteDB Source and Tool
([#732](#732))
([664711f](664711f))
* **prebuilt:** Update default values for prebuilt tools
([#1355](#1355))
([70e832b](70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([#1310](#1310))
([0171228](0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([#1453](#1453))
([a1bc044](a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([#1383](#1383))
([77919c7](77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([#1406](#1406))
([3a6b517](3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([#1454](#1454))
([e6a6c61](e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([#1455](#1455))
([bf6266b](bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([#1440](#1440))
([b176523](b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([#1434](#1434))
([15b628d](15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([#1232](#1232))
([#1347](#1347))
([0cd3f16](0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([#1403](#1403))
([d302499](d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([#1474](#1474))
([1a42e05](1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([#1318](#1318))
([4b32c2a](4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([#1352](#1352))
([f819e26](f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([#1425](#1425))
([236be89](236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([#1473](#1473))
([edca9dc](edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([#1227](#1227))
([681c2b4](681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([#1448](#1448))
([9710014](9710014))
* **source/bigquery:** Add support for datasets selection
([#1313](#1313))
([aa39724](aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([#1472](#1472))
([92680b1](92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([#1441](#1441))
([56b6574](56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([#1408](#1408))
([4f46782](4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([#1306](#1306))
([3aef2bb](3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([#1331](#1331))
([76bb876](76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([#1379](#1379))
([091cd9a](091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([#1380](#1380))
([ab3fd26](ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([#1420](#1420))
([c181dab](c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([#1435](#1435))
([f2d9e3b](f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([#1436](#1436))
([677254e](677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([#1319](#1319))
([d4a9eb0](d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([#1357](#1357))
([93c1b30](93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([#1377](#1377))
([3a8a65c](3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([#1223](#1223))
([81d239b](81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([#1411](#1411))
([345bd6a](345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([#1382](#1382))
([bffb39d](bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([#1431](#1431))
([fe2999a](fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([#1274](#1274))
([e515d92](e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([#1505](#1505))
([7450482](7450482))
* **tools/firestore:** Add `firestore-query` tool
([#1305](#1305))
([cce602f](cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([#1410](#1410))
([2036c8e](2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([#1433](#1433))
([b036047](b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([#1471](#1471))
([ed54cd6](ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([#1479](#1479))
([fe651d8](fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([#1493](#1493))
([9eb821a](9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([#1287](#1287))
([6c8460b](6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([#1400](#1400))
([b2b06c7](b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([#1284](#1284))
([71f360d](71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([#1404](#1404))
([7d384dc](7d384dc))


### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([#1386](#1386))
([b5f9780](b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([#1494](#1494))
([30f1d3a](30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([#1468](#1468))
([6c140d7](6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([#1381](#1381))
([80b7488](80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([#1439](#1439))
([da24661](da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([#1428](#1428))
([4babc4e](4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
github-actions bot pushed a commit that referenced this pull request Sep 19, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.15.0](v0.14.0...v0.15.0)
(2025-09-18)

### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([#1421](#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([#1449](#1449))

### Features

* Add AlloyDB admin source
([#1369](#1369))
([33beb71](33beb71))
* Add Cloud monitoring source and tool
([#1311](#1311))
([d661f53](d661f53))
* Add YugabyteDB Source and Tool
([#732](#732))
([664711f](664711f))
* **prebuilt:** Update default values for prebuilt tools
([#1355](#1355))
([70e832b](70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([#1310](#1310))
([0171228](0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([#1453](#1453))
([a1bc044](a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([#1383](#1383))
([77919c7](77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([#1406](#1406))
([3a6b517](3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([#1454](#1454))
([e6a6c61](e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([#1455](#1455))
([bf6266b](bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([#1440](#1440))
([b176523](b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([#1434](#1434))
([15b628d](15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([#1232](#1232))
([#1347](#1347))
([0cd3f16](0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([#1403](#1403))
([d302499](d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([#1474](#1474))
([1a42e05](1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([#1318](#1318))
([4b32c2a](4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([#1352](#1352))
([f819e26](f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([#1425](#1425))
([236be89](236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([#1473](#1473))
([edca9dc](edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([#1227](#1227))
([681c2b4](681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([#1448](#1448))
([9710014](9710014))
* **source/bigquery:** Add support for datasets selection
([#1313](#1313))
([aa39724](aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([#1472](#1472))
([92680b1](92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([#1441](#1441))
([56b6574](56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([#1408](#1408))
([4f46782](4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([#1306](#1306))
([3aef2bb](3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([#1331](#1331))
([76bb876](76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([#1379](#1379))
([091cd9a](091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([#1380](#1380))
([ab3fd26](ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([#1420](#1420))
([c181dab](c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([#1435](#1435))
([f2d9e3b](f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([#1436](#1436))
([677254e](677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([#1319](#1319))
([d4a9eb0](d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([#1357](#1357))
([93c1b30](93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([#1377](#1377))
([3a8a65c](3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([#1223](#1223))
([81d239b](81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([#1411](#1411))
([345bd6a](345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([#1382](#1382))
([bffb39d](bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([#1431](#1431))
([fe2999a](fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([#1274](#1274))
([e515d92](e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([#1505](#1505))
([7450482](7450482))
* **tools/firestore:** Add `firestore-query` tool
([#1305](#1305))
([cce602f](cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([#1410](#1410))
([2036c8e](2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([#1433](#1433))
([b036047](b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([#1471](#1471))
([ed54cd6](ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([#1479](#1479))
([fe651d8](fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([#1493](#1493))
([9eb821a](9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([#1287](#1287))
([6c8460b](6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([#1400](#1400))
([b2b06c7](b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([#1284](#1284))
([71f360d](71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([#1404](#1404))
([7d384dc](7d384dc))

### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([#1386](#1386))
([b5f9780](b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([#1494](#1494))
([30f1d3a](30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([#1468](#1468))
([6c140d7](6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([#1381](#1381))
([80b7488](80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([#1439](#1439))
([da24661](da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([#1428](#1428))
([4babc4e](4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> c934d7a
github-actions bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Sep 19, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.15.0](googleapis/genai-toolbox@v0.14.0...v0.15.0)
(2025-09-18)

### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([googleapis#1421](googleapis#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([googleapis#1449](googleapis#1449))

### Features

* Add AlloyDB admin source
([googleapis#1369](googleapis#1369))
([33beb71](googleapis@33beb71))
* Add Cloud monitoring source and tool
([googleapis#1311](googleapis#1311))
([d661f53](googleapis@d661f53))
* Add YugabyteDB Source and Tool
([googleapis#732](googleapis#732))
([664711f](googleapis@664711f))
* **prebuilt:** Update default values for prebuilt tools
([googleapis#1355](googleapis#1355))
([70e832b](googleapis@70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([googleapis#1310](googleapis#1310))
([0171228](googleapis@0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([googleapis#1453](googleapis#1453))
([a1bc044](googleapis@a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([googleapis#1383](googleapis#1383))
([77919c7](googleapis@77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([googleapis#1406](googleapis#1406))
([3a6b517](googleapis@3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([googleapis#1454](googleapis#1454))
([e6a6c61](googleapis@e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([googleapis#1455](googleapis#1455))
([bf6266b](googleapis@bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([googleapis#1440](googleapis#1440))
([b176523](googleapis@b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([googleapis#1434](googleapis#1434))
([15b628d](googleapis@15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([googleapis#1232](googleapis#1232))
([googleapis#1347](googleapis#1347))
([0cd3f16](googleapis@0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([googleapis#1403](googleapis#1403))
([d302499](googleapis@d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([googleapis#1474](googleapis#1474))
([1a42e05](googleapis@1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([googleapis#1318](googleapis#1318))
([4b32c2a](googleapis@4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([googleapis#1352](googleapis#1352))
([f819e26](googleapis@f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([googleapis#1425](googleapis#1425))
([236be89](googleapis@236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([googleapis#1473](googleapis#1473))
([edca9dc](googleapis@edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([googleapis#1227](googleapis#1227))
([681c2b4](googleapis@681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([googleapis#1448](googleapis#1448))
([9710014](googleapis@9710014))
* **source/bigquery:** Add support for datasets selection
([googleapis#1313](googleapis#1313))
([aa39724](googleapis@aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([googleapis#1472](googleapis#1472))
([92680b1](googleapis@92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([googleapis#1441](googleapis#1441))
([56b6574](googleapis@56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([googleapis#1408](googleapis#1408))
([4f46782](googleapis@4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([googleapis#1306](googleapis#1306))
([3aef2bb](googleapis@3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([googleapis#1331](googleapis#1331))
([76bb876](googleapis@76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([googleapis#1379](googleapis#1379))
([091cd9a](googleapis@091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([googleapis#1380](googleapis#1380))
([ab3fd26](googleapis@ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([googleapis#1420](googleapis#1420))
([c181dab](googleapis@c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([googleapis#1435](googleapis#1435))
([f2d9e3b](googleapis@f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([googleapis#1436](googleapis#1436))
([677254e](googleapis@677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([googleapis#1319](googleapis#1319))
([d4a9eb0](googleapis@d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([googleapis#1357](googleapis#1357))
([93c1b30](googleapis@93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([googleapis#1377](googleapis#1377))
([3a8a65c](googleapis@3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([googleapis#1223](googleapis#1223))
([81d239b](googleapis@81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([googleapis#1411](googleapis#1411))
([345bd6a](googleapis@345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([googleapis#1382](googleapis#1382))
([bffb39d](googleapis@bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([googleapis#1431](googleapis#1431))
([fe2999a](googleapis@fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([googleapis#1274](googleapis#1274))
([e515d92](googleapis@e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([googleapis#1505](googleapis#1505))
([7450482](googleapis@7450482))
* **tools/firestore:** Add `firestore-query` tool
([googleapis#1305](googleapis#1305))
([cce602f](googleapis@cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([googleapis#1410](googleapis#1410))
([2036c8e](googleapis@2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([googleapis#1433](googleapis#1433))
([b036047](googleapis@b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([googleapis#1471](googleapis#1471))
([ed54cd6](googleapis@ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([googleapis#1479](googleapis#1479))
([fe651d8](googleapis@fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([googleapis#1493](googleapis#1493))
([9eb821a](googleapis@9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([googleapis#1287](googleapis#1287))
([6c8460b](googleapis@6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([googleapis#1400](googleapis#1400))
([b2b06c7](googleapis@b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([googleapis#1284](googleapis#1284))
([71f360d](googleapis@71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([googleapis#1404](googleapis#1404))
([7d384dc](googleapis@7d384dc))

### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([googleapis#1386](googleapis#1386))
([b5f9780](googleapis@b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([googleapis#1494](googleapis#1494))
([30f1d3a](googleapis@30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([googleapis#1468](googleapis#1468))
([6c140d7](googleapis@6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([googleapis#1381](googleapis#1381))
([80b7488](googleapis@80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([googleapis#1439](googleapis#1439))
([da24661](googleapis@da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([googleapis#1428](googleapis#1428))
([4babc4e](googleapis@4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> c934d7a
github-actions bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Sep 19, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.15.0](googleapis/genai-toolbox@v0.14.0...v0.15.0)
(2025-09-18)

### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([googleapis#1421](googleapis#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([googleapis#1449](googleapis#1449))

### Features

* Add AlloyDB admin source
([googleapis#1369](googleapis#1369))
([33beb71](googleapis@33beb71))
* Add Cloud monitoring source and tool
([googleapis#1311](googleapis#1311))
([d661f53](googleapis@d661f53))
* Add YugabyteDB Source and Tool
([googleapis#732](googleapis#732))
([664711f](googleapis@664711f))
* **prebuilt:** Update default values for prebuilt tools
([googleapis#1355](googleapis#1355))
([70e832b](googleapis@70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([googleapis#1310](googleapis#1310))
([0171228](googleapis@0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([googleapis#1453](googleapis#1453))
([a1bc044](googleapis@a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([googleapis#1383](googleapis#1383))
([77919c7](googleapis@77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([googleapis#1406](googleapis#1406))
([3a6b517](googleapis@3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([googleapis#1454](googleapis#1454))
([e6a6c61](googleapis@e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([googleapis#1455](googleapis#1455))
([bf6266b](googleapis@bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([googleapis#1440](googleapis#1440))
([b176523](googleapis@b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([googleapis#1434](googleapis#1434))
([15b628d](googleapis@15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([googleapis#1232](googleapis#1232))
([googleapis#1347](googleapis#1347))
([0cd3f16](googleapis@0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([googleapis#1403](googleapis#1403))
([d302499](googleapis@d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([googleapis#1474](googleapis#1474))
([1a42e05](googleapis@1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([googleapis#1318](googleapis#1318))
([4b32c2a](googleapis@4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([googleapis#1352](googleapis#1352))
([f819e26](googleapis@f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([googleapis#1425](googleapis#1425))
([236be89](googleapis@236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([googleapis#1473](googleapis#1473))
([edca9dc](googleapis@edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([googleapis#1227](googleapis#1227))
([681c2b4](googleapis@681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([googleapis#1448](googleapis#1448))
([9710014](googleapis@9710014))
* **source/bigquery:** Add support for datasets selection
([googleapis#1313](googleapis#1313))
([aa39724](googleapis@aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([googleapis#1472](googleapis#1472))
([92680b1](googleapis@92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([googleapis#1441](googleapis#1441))
([56b6574](googleapis@56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([googleapis#1408](googleapis#1408))
([4f46782](googleapis@4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([googleapis#1306](googleapis#1306))
([3aef2bb](googleapis@3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([googleapis#1331](googleapis#1331))
([76bb876](googleapis@76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([googleapis#1379](googleapis#1379))
([091cd9a](googleapis@091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([googleapis#1380](googleapis#1380))
([ab3fd26](googleapis@ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([googleapis#1420](googleapis#1420))
([c181dab](googleapis@c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([googleapis#1435](googleapis#1435))
([f2d9e3b](googleapis@f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([googleapis#1436](googleapis#1436))
([677254e](googleapis@677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([googleapis#1319](googleapis#1319))
([d4a9eb0](googleapis@d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([googleapis#1357](googleapis#1357))
([93c1b30](googleapis@93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([googleapis#1377](googleapis#1377))
([3a8a65c](googleapis@3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([googleapis#1223](googleapis#1223))
([81d239b](googleapis@81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([googleapis#1411](googleapis#1411))
([345bd6a](googleapis@345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([googleapis#1382](googleapis#1382))
([bffb39d](googleapis@bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([googleapis#1431](googleapis#1431))
([fe2999a](googleapis@fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([googleapis#1274](googleapis#1274))
([e515d92](googleapis@e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([googleapis#1505](googleapis#1505))
([7450482](googleapis@7450482))
* **tools/firestore:** Add `firestore-query` tool
([googleapis#1305](googleapis#1305))
([cce602f](googleapis@cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([googleapis#1410](googleapis#1410))
([2036c8e](googleapis@2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([googleapis#1433](googleapis#1433))
([b036047](googleapis@b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([googleapis#1471](googleapis#1471))
([ed54cd6](googleapis@ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([googleapis#1479](googleapis#1479))
([fe651d8](googleapis@fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([googleapis#1493](googleapis#1493))
([9eb821a](googleapis@9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([googleapis#1287](googleapis#1287))
([6c8460b](googleapis@6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([googleapis#1400](googleapis#1400))
([b2b06c7](googleapis@b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([googleapis#1284](googleapis#1284))
([71f360d](googleapis@71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([googleapis#1404](googleapis#1404))
([7d384dc](googleapis@7d384dc))

### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([googleapis#1386](googleapis#1386))
([b5f9780](googleapis@b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([googleapis#1494](googleapis#1494))
([30f1d3a](googleapis@30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([googleapis#1468](googleapis#1468))
([6c140d7](googleapis@6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([googleapis#1381](googleapis#1381))
([80b7488](googleapis@80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([googleapis#1439](googleapis#1439))
([da24661](googleapis@da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([googleapis#1428](googleapis#1428))
([4babc4e](googleapis@4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> c934d7a
github-actions bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Sep 19, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.15.0](googleapis/genai-toolbox@v0.14.0...v0.15.0)
(2025-09-18)

### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([googleapis#1421](googleapis#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([googleapis#1449](googleapis#1449))

### Features

* Add AlloyDB admin source
([googleapis#1369](googleapis#1369))
([33beb71](googleapis@33beb71))
* Add Cloud monitoring source and tool
([googleapis#1311](googleapis#1311))
([d661f53](googleapis@d661f53))
* Add YugabyteDB Source and Tool
([googleapis#732](googleapis#732))
([664711f](googleapis@664711f))
* **prebuilt:** Update default values for prebuilt tools
([googleapis#1355](googleapis#1355))
([70e832b](googleapis@70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([googleapis#1310](googleapis#1310))
([0171228](googleapis@0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([googleapis#1453](googleapis#1453))
([a1bc044](googleapis@a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([googleapis#1383](googleapis#1383))
([77919c7](googleapis@77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([googleapis#1406](googleapis#1406))
([3a6b517](googleapis@3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([googleapis#1454](googleapis#1454))
([e6a6c61](googleapis@e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([googleapis#1455](googleapis#1455))
([bf6266b](googleapis@bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([googleapis#1440](googleapis#1440))
([b176523](googleapis@b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([googleapis#1434](googleapis#1434))
([15b628d](googleapis@15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([googleapis#1232](googleapis#1232))
([googleapis#1347](googleapis#1347))
([0cd3f16](googleapis@0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([googleapis#1403](googleapis#1403))
([d302499](googleapis@d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([googleapis#1474](googleapis#1474))
([1a42e05](googleapis@1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([googleapis#1318](googleapis#1318))
([4b32c2a](googleapis@4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([googleapis#1352](googleapis#1352))
([f819e26](googleapis@f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([googleapis#1425](googleapis#1425))
([236be89](googleapis@236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([googleapis#1473](googleapis#1473))
([edca9dc](googleapis@edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([googleapis#1227](googleapis#1227))
([681c2b4](googleapis@681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([googleapis#1448](googleapis#1448))
([9710014](googleapis@9710014))
* **source/bigquery:** Add support for datasets selection
([googleapis#1313](googleapis#1313))
([aa39724](googleapis@aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([googleapis#1472](googleapis#1472))
([92680b1](googleapis@92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([googleapis#1441](googleapis#1441))
([56b6574](googleapis@56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([googleapis#1408](googleapis#1408))
([4f46782](googleapis@4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([googleapis#1306](googleapis#1306))
([3aef2bb](googleapis@3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([googleapis#1331](googleapis#1331))
([76bb876](googleapis@76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([googleapis#1379](googleapis#1379))
([091cd9a](googleapis@091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([googleapis#1380](googleapis#1380))
([ab3fd26](googleapis@ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([googleapis#1420](googleapis#1420))
([c181dab](googleapis@c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([googleapis#1435](googleapis#1435))
([f2d9e3b](googleapis@f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([googleapis#1436](googleapis#1436))
([677254e](googleapis@677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([googleapis#1319](googleapis#1319))
([d4a9eb0](googleapis@d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([googleapis#1357](googleapis#1357))
([93c1b30](googleapis@93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([googleapis#1377](googleapis#1377))
([3a8a65c](googleapis@3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([googleapis#1223](googleapis#1223))
([81d239b](googleapis@81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([googleapis#1411](googleapis#1411))
([345bd6a](googleapis@345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([googleapis#1382](googleapis#1382))
([bffb39d](googleapis@bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([googleapis#1431](googleapis#1431))
([fe2999a](googleapis@fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([googleapis#1274](googleapis#1274))
([e515d92](googleapis@e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([googleapis#1505](googleapis#1505))
([7450482](googleapis@7450482))
* **tools/firestore:** Add `firestore-query` tool
([googleapis#1305](googleapis#1305))
([cce602f](googleapis@cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([googleapis#1410](googleapis#1410))
([2036c8e](googleapis@2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([googleapis#1433](googleapis#1433))
([b036047](googleapis@b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([googleapis#1471](googleapis#1471))
([ed54cd6](googleapis@ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([googleapis#1479](googleapis#1479))
([fe651d8](googleapis@fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([googleapis#1493](googleapis#1493))
([9eb821a](googleapis@9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([googleapis#1287](googleapis#1287))
([6c8460b](googleapis@6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([googleapis#1400](googleapis#1400))
([b2b06c7](googleapis@b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([googleapis#1284](googleapis#1284))
([71f360d](googleapis@71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([googleapis#1404](googleapis#1404))
([7d384dc](googleapis@7d384dc))

### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([googleapis#1386](googleapis#1386))
([b5f9780](googleapis@b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([googleapis#1494](googleapis#1494))
([30f1d3a](googleapis@30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([googleapis#1468](googleapis#1468))
([6c140d7](googleapis@6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([googleapis#1381](googleapis#1381))
([80b7488](googleapis@80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([googleapis#1439](googleapis#1439))
([da24661](googleapis@da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([googleapis#1428](googleapis#1428))
([4babc4e](googleapis@4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> c934d7a
rapid-killer-9 pushed a commit that referenced this pull request Sep 23, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.15.0](v0.14.0...v0.15.0)
(2025-09-18)


### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([#1421](#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([#1449](#1449))

### Features

* Add AlloyDB admin source
([#1369](#1369))
([33beb71](33beb71))
* Add Cloud monitoring source and tool
([#1311](#1311))
([d661f53](d661f53))
* Add YugabyteDB Source and Tool
([#732](#732))
([664711f](664711f))
* **prebuilt:** Update default values for prebuilt tools
([#1355](#1355))
([70e832b](70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([#1310](#1310))
([0171228](0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([#1453](#1453))
([a1bc044](a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([#1383](#1383))
([77919c7](77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([#1406](#1406))
([3a6b517](3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([#1454](#1454))
([e6a6c61](e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([#1455](#1455))
([bf6266b](bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([#1440](#1440))
([b176523](b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([#1434](#1434))
([15b628d](15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([#1232](#1232))
([#1347](#1347))
([0cd3f16](0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([#1403](#1403))
([d302499](d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([#1474](#1474))
([1a42e05](1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([#1318](#1318))
([4b32c2a](4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([#1352](#1352))
([f819e26](f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([#1425](#1425))
([236be89](236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([#1473](#1473))
([edca9dc](edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([#1227](#1227))
([681c2b4](681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([#1448](#1448))
([9710014](9710014))
* **source/bigquery:** Add support for datasets selection
([#1313](#1313))
([aa39724](aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([#1472](#1472))
([92680b1](92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([#1441](#1441))
([56b6574](56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([#1408](#1408))
([4f46782](4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([#1306](#1306))
([3aef2bb](3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([#1331](#1331))
([76bb876](76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([#1379](#1379))
([091cd9a](091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([#1380](#1380))
([ab3fd26](ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([#1420](#1420))
([c181dab](c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([#1435](#1435))
([f2d9e3b](f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([#1436](#1436))
([677254e](677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([#1319](#1319))
([d4a9eb0](d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([#1357](#1357))
([93c1b30](93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([#1377](#1377))
([3a8a65c](3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([#1223](#1223))
([81d239b](81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([#1411](#1411))
([345bd6a](345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([#1382](#1382))
([bffb39d](bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([#1431](#1431))
([fe2999a](fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([#1274](#1274))
([e515d92](e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([#1505](#1505))
([7450482](7450482))
* **tools/firestore:** Add `firestore-query` tool
([#1305](#1305))
([cce602f](cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([#1410](#1410))
([2036c8e](2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([#1433](#1433))
([b036047](b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([#1471](#1471))
([ed54cd6](ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([#1479](#1479))
([fe651d8](fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([#1493](#1493))
([9eb821a](9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([#1287](#1287))
([6c8460b](6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([#1400](#1400))
([b2b06c7](b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([#1284](#1284))
([71f360d](71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([#1404](#1404))
([7d384dc](7d384dc))


### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([#1386](#1386))
([b5f9780](b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([#1494](#1494))
([30f1d3a](30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([#1468](#1468))
([6c140d7](6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([#1381](#1381))
([80b7488](80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([#1439](#1439))
([da24661](da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([#1428](#1428))
([4babc4e](4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
rahulpinto19 pushed a commit that referenced this pull request Sep 30, 2025
…e error in Cloud Run (#1381)

## Problem
Fixes #1378 - BigQuery Conversational Analytics tool fails with
`ACCESS_TOKEN_SCOPE_INSUFFICIENT` error in Cloud Run environments while
other BigQuery tools work fine.

## Root Cause
The conversational analytics tool was using `BigQueryTokenSource()` with
limited `bigqueryapi.Scope`, but the Gemini Data Analytics API
(`geminidataanalytics.googleapis.com`) requires broader `cloud-platform`
scope.

## Solution
- Replace ADC token acquisition to use `google.DefaultTokenSource` with
`cloud-platform` scope
- Remove dependency on limited BigQuery scope from source
- Maintain compatibility with existing OAuth flow

## Testing
- ✅ **Local testing confirmed**: Tool now works perfectly
- ✅ **Test script**:
https://github.com/johanesalxd/bq-agent-app/blob/main/setup/mcp_toolbox_ca_issue/test_detailed_error.py
- ✅ **Successful response**: Returns proper schema information and
conversational answers
- ✅ **All BigQuery tool tests pass**: No regression in other tools
- ✅ **Build successful**: No compilation errors

## Impact
- **Fixes**: Cloud Run deployment authentication errors
- **Maintains**: Local development functionality  
- **Preserves**: All existing BigQuery tool functionality

---------

Co-authored-by: Huan Chen <142538604+Genesis929@users.noreply.github.com>
rahulpinto19 pushed a commit that referenced this pull request Sep 30, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.15.0](v0.14.0...v0.15.0)
(2025-09-18)


### ⚠ BREAKING CHANGES

* **prebuilt:** update prebuilt tool names to use consistent guidance
([#1421](#1421))
* **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to
`alloydb-wait-for-operation` tool
([#1449](#1449))

### Features

* Add AlloyDB admin source
([#1369](#1369))
([33beb71](33beb71))
* Add Cloud monitoring source and tool
([#1311](#1311))
([d661f53](d661f53))
* Add YugabyteDB Source and Tool
([#732](#732))
([664711f](664711f))
* **prebuilt:** Update default values for prebuilt tools
([#1355](#1355))
([70e832b](70e832b))
* **prebuilt/cloud-sql:** Add list instances tool for cloudsql
([#1310](#1310))
([0171228](0171228))
* **prebuilt/cloud-sql:** Add cloud sql create database tool.
([#1453](#1453))
([a1bc044](a1bc044))
* **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool
([#1383](#1383))
([77919c7](77919c7))
* **prebuilt/cloud-sql:** Add create user tool for cloud sql
([#1406](#1406))
([3a6b517](3a6b517))
* **prebuilt/cloud-sql:** Add list databases tool for cloud sql
([#1454](#1454))
([e6a6c61](e6a6c61))
* **prebuilt/cloud-sql:** Package cloud sql tools
([#1455](#1455))
([bf6266b](bf6266b))
* **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql
([#1440](#1440))
([b176523](b176523))
* **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL
MySQL ([#1434](#1434))
([15b628d](15b628d))
* **prebuilt/cloud-sql-mysql:** Add env var support for IP Type
([#1232](#1232))
([#1347](#1347))
([0cd3f16](0cd3f16))
* **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool
([#1403](#1403))
([d302499](d302499))
* **prebuilt/mysql:** Add a new tool to show query plan of a given query
in MySQL
([#1474](#1474))
([1a42e05](1a42e05))
* **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config
([#1318](#1318))
([4b32c2a](4b32c2a))
* **prebuilt/neo4j:** Add prebuiltconfig support for neo4j
([#1352](#1352))
([f819e26](f819e26))
* **prebuilt/observability:** Add cloud sql observability tools
([#1425](#1425))
([236be89](236be89))
* **prebuilt/postgres:** Add postgres prebuilt tools
([#1473](#1473))
([edca9dc](edca9dc))
* **prebuilt/sqlite:** Prebuilt tools for the sqlite.
([#1227](#1227))
([681c2b4](681c2b4))
* **source/alloydb-admin:** Add user agent and attach alloydb api in
`alloydb-admin` source
([#1448](#1448))
([9710014](9710014))
* **source/bigquery:** Add support for datasets selection
([#1313](#1313))
([aa39724](aa39724))
* **source/cloud-monitoring:** Add support for user agent in cloud
monitoring source
([#1472](#1472))
([92680b1](92680b1))
* **source/cloud-sql-admin:** Add User agent and attach sqldmin in
`cloud-sql-admin` source.
([#1441](#1441))
([56b6574](56b6574))
* **source/cloudsqladmin:** Add cloud sql admin source
([#1408](#1408))
([4f46782](4f46782))
* **tool/cloudsql:** Add cloud sql wait for operation tool with
exponential backoff
([#1306](#1306))
([3aef2bb](3aef2bb))
* **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB
create cluster
([#1331](#1331))
([76bb876](76bb876))
* **tools/alloydb-create-instance:** Add new custom tool kind for
AlloyDB
([#1379](#1379))
([091cd9a](091cd9a))
* **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB
create user
([#1380](#1380))
([ab3fd26](ab3fd26))
* **tools/alloydb-get-cluster:** Add new tool for AlloyDB
([#1420](#1420))
([c181dab](c181dab))
* **tools/alloydb-get-instance:** Add new for AlloyDB
([#1435](#1435))
([f2d9e3b](f2d9e3b))
* **tools/alloydb-get-user:** Add new tool for AlloyDB
([#1436](#1436))
([677254e](677254e))
* **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB
([#1319](#1319))
([d4a9eb0](d4a9eb0))
* **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB
([#1357](#1357))
([93c1b30](93c1b30))
* **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB
([#1377](#1377))
([3a8a65c](3a8a65c))
* **tools/bigquery-analyze-contribution:** Add analyze contribution tool
([#1223](#1223))
([81d239b](81d239b))
* **tools/bigquery-conversational-analytics:** Add allowed datasets
support
([#1411](#1411))
([345bd6a](345bd6a))
* **tools/bigquery-search-catalog:** Add new tool to BigQuery
([#1382](#1382))
([bffb39d](bffb39d))
* **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source
config
([#1431](#1431))
([fe2999a](fe2999a))
* **tools/clickhouse-list-databases:** Add `list-databases` tool to
clickhouse source
([#1274](#1274))
([e515d92](e515d92))
* **tools/firestore-get-rules:** Add `databaseId` to the Firestore
source and `firestore-get-rules` tool
([#1505](#1505))
([7450482](7450482))
* **tools/firestore:** Add `firestore-query` tool
([#1305](#1305))
([cce602f](cce602f))
* **tools/looker:** Query tracking for MCP Toolbox in Looker System
Activity views
([#1410](#1410))
([2036c8e](2036c8e))
* **tools/mssql-list-tables:** Add new tool for sql server
([#1433](#1433))
([b036047](b036047))
* **tools/mysql-list-active-queries:** Add a new tool to list ongoing
queries in a MySQL instance
([#1471](#1471))
([ed54cd6](ed54cd6))
* **tools/mysql-list-table-fragmentation:** Add a new tool to list table
fragmentation in a MySQL instance
([#1479](#1479))
([fe651d8](fe651d8))
* **tools/mysql-list-tables-missing-index:** Add a new tool to list
tables that do not have primary or unique keys in a MySQL instance
([#1493](#1493))
([9eb821a](9eb821a))
* **tools/mysql-list-tables:** Add new tool for MySQL
([#1287](#1287))
([6c8460b](6c8460b))
* **tools/postgres-list-active-queries:** Add new
`postgres-list-active-queries` tool
([#1400](#1400))
([b2b06c7](b2b06c7))
* **tools/postgres-list-tables:** Add new tool to postgres source
([#1284](#1284))
([71f360d](71f360d))
* **tools/spanner-list-tables:** Add new tool `spanner-list-tables`
([#1404](#1404))
([7d384dc](7d384dc))


### Bug Fixes

* **bigquery:** Add `Bearer` parsing to auth token
([#1386](#1386))
([b5f9780](b5f9780))
* **source/alloydb-admin, source/cloudsql-admin:** Post append new user
agent ([#1494](#1494))
([30f1d3a](30f1d3a))
* **tools/alloydb:** Update parameter names and set default description
for AlloyDB control plane tools
([#1468](#1468))
([6c140d7](6c140d7))
* **tools/bigquery-conversational-analytics:** Fix authentication scope
error in Cloud Run
([#1381](#1381))
([80b7488](80b7488))
* **tools/mysql-list-tables:** Update `mysql-list-tables` table_names
parameter with default value
([#1439](#1439))
([da24661](da24661))
* **tools/neo4j:** Implement value conversion for Neo4j types to
JSON-compatible
([#1428](#1428))
([4babc4e](4babc4e))
---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

GitHub Issue: BigQuery Conversational Analytics Authentication Scope Error

4 participants