-
Notifications
You must be signed in to change notification settings - Fork 1.1k
Fix(tools/bigquery-conversational-analytics): fix authentication scope error in Cloud Run #1381
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Merged
Genesis929
merged 8 commits into
googleapis:main
from
johanesalxd:fix/bigquery-conversational-analytics-scope-issue
Sep 17, 2025
Merged
Fix(tools/bigquery-conversational-analytics): fix authentication scope error in Cloud Run #1381
Genesis929
merged 8 commits into
googleapis:main
from
johanesalxd:fix/bigquery-conversational-analytics-scope-issue
Sep 17, 2025
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Contributor
|
Hi @Genesis929, could you take a look at this PR? Thanks! |
Genesis929
previously approved these changes
Sep 10, 2025
Genesis929
reviewed
Sep 10, 2025
internal/tools/bigquery/bigqueryconversationalanalytics/bigqueryconversationalanalytics.go
Outdated
Show resolved
Hide resolved
- 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
2b18c28 to
aa1695a
Compare
Genesis929
approved these changes
Sep 12, 2025
johanesalxd
added a commit
to johanesalxd/bq-agent-app
that referenced
this pull request
Sep 13, 2025
Contributor
Author
|
thanks @Genesis929 and @duwenxin99 . just want to check if anything else needed from my side? |
duwenxin99
approved these changes
Sep 16, 2025
Contributor
|
/gcbrun |
Contributor
Thanks for your great work! We will merge it soon. |
Contributor
|
/gcbrun |
Contributor
|
/gcbrun |
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
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Problem
Fixes #1378 - BigQuery Conversational Analytics tool fails with
ACCESS_TOKEN_SCOPE_INSUFFICIENTerror in Cloud Run environments while other BigQuery tools work fine.Root Cause
The conversational analytics tool was using
BigQueryTokenSource()with limitedbigqueryapi.Scope, but the Gemini Data Analytics API (geminidataanalytics.googleapis.com) requires broadercloud-platformscope.Solution
google.DefaultTokenSourcewithcloud-platformscopeTesting
Impact