feat(tools/bigquerysql): add semantic search support by duwenxin99 · Pull Request #2890 · googleapis/mcp-toolbox

duwenxin99 · 2026-03-30T01:59:10Z

No description provided.

gemini-code-assist

Code Review

This pull request introduces support for vector parameters in BigQuery SQL tools by handling []float32 slices and converting them to []float64 arrays for compatibility with the BigQuery Go client. It also adds integration tests for semantic search, including a new vector table setup and test cases for vector-based queries. I have no feedback to provide.

github-actions · 2026-03-30T19:05:23Z

🚀 Cloudflare Preview Ready!

🔎 View Preview: https://pr-2890.toolbox-docs-6xc.pages.dev

(Note: Subsequent pushes to this PR will automatically update the preview at this same URL)

github-actions · 2026-03-30T19:06:26Z

🔎 Preview at https://googleapis.github.io/genai-toolbox/previews/PR-2890/

github-actions · 2026-04-09T20:25:38Z

🧨 Preview deployments removed.

Cloudflare Pages environments for pr-2890 have been deleted.

…62c396

…pis#2890) 862c396

🤖 I have created a release *beep* *boop* --- ## [1.0.0](v0.32.0...v1.0.0) (2026-04-10) > [!IMPORTANT] > This is the first stable release. Please review the [UPGRADING.md](UPGRADING.md) guide for instructions on migrating from previous beta versions. ### ⚠ BREAKING CHANGES * **tools/elasticsearch:** add vector search support and remove query passing through param ([#2891](#2891)) * **tools/looker:** refactor looker-git-branch tool into 5 separate tools ([#2976](#2976)) ### Features * **auth:** Support opaque token validation for `generic` authService ([#2944](#2944)) ([c924701](c924701)) * **cloudsqlpg:** Run `SELECT 1` after successful connection attempt ([#2997](#2997)) ([6ed9700](6ed9700)) * **tools/bigquerysql:** Add semantic search support ([#2890](#2890)) ([862c396](862c396)) * **tools/elasticsearch-execute-esql:** Add Tool to execute arbitrary ES/QL queries ([#3013](#3013)) ([ae49fb7](ae49fb7)) * **tools/elasticsearch:** Add vector search support and remove query passing through param ([#2891](#2891)) ([d44e879](d44e879)) * **tools/looker:** Refactor looker-git-branch tool into 5 separate tools ([#2976](#2976)) ([b2472d4](b2472d4)) * **tools/mysql:** Add list-table-stats-tool to list table statistics in MySQL and Cloud SQL MySQL source. ([#2938](#2938)) ([dc2c2b4](dc2c2b4)) --- 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>

🤖 I have created a release *beep* *boop* --- ## [1.0.0](v0.32.0...v1.0.0) (2026-04-10) > [!IMPORTANT] > This is the first stable release. Please review the [UPGRADING.md](UPGRADING.md) guide for instructions on migrating from previous beta versions. ### ⚠ BREAKING CHANGES * **tools/elasticsearch:** add vector search support and remove query passing through param ([#2891](#2891)) * **tools/looker:** refactor looker-git-branch tool into 5 separate tools ([#2976](#2976)) ### Features * **auth:** Support opaque token validation for `generic` authService ([#2944](#2944)) ([c924701](c924701)) * **cloudsqlpg:** Run `SELECT 1` after successful connection attempt ([#2997](#2997)) ([6ed9700](6ed9700)) * **tools/bigquerysql:** Add semantic search support ([#2890](#2890)) ([862c396](862c396)) * **tools/elasticsearch-execute-esql:** Add Tool to execute arbitrary ES/QL queries ([#3013](#3013)) ([ae49fb7](ae49fb7)) * **tools/elasticsearch:** Add vector search support and remove query passing through param ([#2891](#2891)) ([d44e879](d44e879)) * **tools/looker:** Refactor looker-git-branch tool into 5 separate tools ([#2976](#2976)) ([b2472d4](b2472d4)) * **tools/mysql:** Add list-table-stats-tool to list table statistics in MySQL and Cloud SQL MySQL source. ([#2938](#2938)) ([dc2c2b4](dc2c2b4)) --- 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> 8b07b2d

🤖 I have created a release *beep* *boop* --- ## [1.0.0](googleapis/mcp-toolbox@v0.32.0...v1.0.0) (2026-04-10) > [!IMPORTANT] > This is the first stable release. Please review the [UPGRADING.md](UPGRADING.md) guide for instructions on migrating from previous beta versions. ### ⚠ BREAKING CHANGES * **tools/elasticsearch:** add vector search support and remove query passing through param ([googleapis#2891](googleapis#2891)) * **tools/looker:** refactor looker-git-branch tool into 5 separate tools ([googleapis#2976](googleapis#2976)) ### Features * **auth:** Support opaque token validation for `generic` authService ([googleapis#2944](googleapis#2944)) ([c924701](googleapis@c924701)) * **cloudsqlpg:** Run `SELECT 1` after successful connection attempt ([googleapis#2997](googleapis#2997)) ([6ed9700](googleapis@6ed9700)) * **tools/bigquerysql:** Add semantic search support ([googleapis#2890](googleapis#2890)) ([862c396](googleapis@862c396)) * **tools/elasticsearch-execute-esql:** Add Tool to execute arbitrary ES/QL queries ([googleapis#3013](googleapis#3013)) ([ae49fb7](googleapis@ae49fb7)) * **tools/elasticsearch:** Add vector search support and remove query passing through param ([googleapis#2891](googleapis#2891)) ([d44e879](googleapis@d44e879)) * **tools/looker:** Refactor looker-git-branch tool into 5 separate tools ([googleapis#2976](googleapis#2976)) ([b2472d4](googleapis@b2472d4)) * **tools/mysql:** Add list-table-stats-tool to list table statistics in MySQL and Cloud SQL MySQL source. ([googleapis#2938](googleapis#2938)) ([dc2c2b4](googleapis@dc2c2b4)) --- 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> 8b07b2d

🤖 I have created a release *beep* *boop* --- ## [1.0.0](googleapis/mcp-toolbox@v0.32.0...v1.0.0) (2026-04-10) > [!IMPORTANT] > This is the first stable release. Please review the [UPGRADING.md](UPGRADING.md) guide for instructions on migrating from previous beta versions. ### ⚠ BREAKING CHANGES * **tools/elasticsearch:** add vector search support and remove query passing through param ([googleapis#2891](googleapis#2891)) * **tools/looker:** refactor looker-git-branch tool into 5 separate tools ([googleapis#2976](googleapis#2976)) ### Features * **auth:** Support opaque token validation for `generic` authService ([googleapis#2944](googleapis#2944)) ([c924701](googleapis@c924701)) * **cloudsqlpg:** Run `SELECT 1` after successful connection attempt ([googleapis#2997](googleapis#2997)) ([6ed9700](googleapis@6ed9700)) * **tools/bigquerysql:** Add semantic search support ([googleapis#2890](googleapis#2890)) ([862c396](googleapis@862c396)) * **tools/elasticsearch-execute-esql:** Add Tool to execute arbitrary ES/QL queries ([googleapis#3013](googleapis#3013)) ([ae49fb7](googleapis@ae49fb7)) * **tools/elasticsearch:** Add vector search support and remove query passing through param ([googleapis#2891](googleapis#2891)) ([d44e879](googleapis@d44e879)) * **tools/looker:** Refactor looker-git-branch tool into 5 separate tools ([googleapis#2976](googleapis#2976)) ([b2472d4](googleapis@b2472d4)) * **tools/mysql:** Add list-table-stats-tool to list table statistics in MySQL and Cloud SQL MySQL source. ([googleapis#2938](googleapis#2938)) ([dc2c2b4](googleapis@dc2c2b4)) --- 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>

duwenxin99 requested review from a team as code owners March 30, 2026 01:59

blunderbuss-gcf Bot assigned Yuan325 Mar 30, 2026

gemini-code-assist Bot reviewed Mar 30, 2026

View reviewed changes

duwenxin99 force-pushed the feat/bigquery-semantic-search branch 2 times, most recently from 3c26329 to a6e31ae Compare March 30, 2026 18:35

duwenxin99 changed the title ~~feat(source/bigquery): add semantic search integration tests~~ feat(source/bigquery): add semantic search integration tests and docs Mar 30, 2026

duwenxin99 mentioned this pull request Mar 30, 2026

Support all vector databases #2415

Open

1 task

duwenxin99 changed the title ~~feat(source/bigquery): add semantic search integration tests and docs~~ chore(source/bigquery): add semantic search support Mar 30, 2026

duwenxin99 changed the title ~~chore(source/bigquery): add semantic search support~~ chore(tools/bigquerysql): add semantic search support Mar 30, 2026

duwenxin99 changed the title ~~chore(tools/bigquerysql): add semantic search support~~ feat(tools/bigquerysql): add semantic search support Mar 30, 2026

averikitsch reviewed Apr 1, 2026

View reviewed changes

Comment thread internal/tools/bigquery/bigquerysql/bigquerysql.go Outdated

Deeven-Seru mentioned this pull request Apr 5, 2026

Support image ingestion and semantic vectorization as a first-class database source #2948

Open

1 task

duwenxin99 requested a review from averikitsch April 6, 2026 22:16

duwenxin99 added the release candidate Use label to signal PR should be included in the next release. label Apr 9, 2026

averikitsch approved these changes Apr 9, 2026

View reviewed changes

averikitsch added the do not merge Indicates a pull request not ready for merge, due to either quality or timing. label Apr 9, 2026

Genesis929 approved these changes Apr 9, 2026

View reviewed changes

averikitsch removed the do not merge Indicates a pull request not ready for merge, due to either quality or timing. label Apr 9, 2026

duwenxin99 enabled auto-merge (squash) April 9, 2026 18:55

duwenxin99 added 8 commits April 9, 2026 16:09

feat(source/bigquery): add semantic search integration tests

eb24eaa

add bq API_KEY to cb yaml

475501a

add bq formatter

6c1916b

update cb yaml

d5b5e9f

update test statements

3e5b007

update bq slice

4708fa3

fix lint

3926f0b

fix array item type

cfa3fc0

duwenxin99 added 2 commits April 9, 2026 16:09

add bq tool docs

2acd51c

fix comment

039560e

duwenxin99 force-pushed the feat/bigquery-semantic-search branch from a4207f4 to 039560e Compare April 9, 2026 20:09

duwenxin99 merged commit 862c396 into main Apr 9, 2026
26 checks passed

duwenxin99 deleted the feat/bigquery-semantic-search branch April 9, 2026 20:25

release-please Bot mentioned this pull request Apr 9, 2026

chore(main): release 1.0.0 #3010

Merged

github-actions Bot pushed a commit that referenced this pull request Apr 9, 2026

deploy: feat(tools/bigquerysql): add semantic search support (#2890) 8…

7b197f9

…62c396

github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Apr 9, 2026

deploy: feat(tools/bigquerysql): add semantic search support (googlea…

001d57d

…pis#2890) 862c396

BrewTestBot mentioned this pull request Apr 10, 2026

mcp-toolbox 1.0.0 Homebrew/homebrew-core#276922

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

feat(tools/bigquerysql): add semantic search support#2890

feat(tools/bigquerysql): add semantic search support#2890
duwenxin99 merged 10 commits into
mainfrom
feat/bigquery-semantic-search

duwenxin99 commented Mar 30, 2026

Uh oh!

gemini-code-assist Bot left a comment

Uh oh!

github-actions Bot commented Mar 30, 2026

Uh oh!

github-actions Bot commented Mar 30, 2026

Uh oh!

Uh oh!

Uh oh!

github-actions Bot commented Apr 9, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

4 participants

Conversation

duwenxin99 commented Mar 30, 2026

Uh oh!

gemini-code-assist Bot left a comment

Choose a reason for hiding this comment

Code Review

Uh oh!

github-actions Bot commented Mar 30, 2026

Uh oh!

github-actions Bot commented Mar 30, 2026

Uh oh!

Uh oh!

Uh oh!

github-actions Bot commented Apr 9, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

4 participants