feat(cockroachdb): add CockroachDB integration with cockroach-go by viragtripathi · Pull Request #2006 · googleapis/mcp-toolbox

viragtripathi · 2025-11-20T19:00:14Z

Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry.

Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx
Implement 4 tools: execute-sql, sql, list-tables, list-schemas
Use UUID primary keys (CockroachDB best practice)
Add unit tests for source and all tools
Add integration tests with retry verification
Update Cloud Build configuration for CI

Fixes #2005

Description

Should include a concise description of the changes (bug or feature), it's
impact, along with a summary of the solution

PR Checklist

Thank you for opening a Pull Request! Before submitting your PR, there are a
few things you can do to make sure it goes smoothly:

Make sure you reviewed
CONTRIBUTING.md
Make sure to open an issue as a
bug/issue
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
Ensure the tests and linter pass
Code coverage does not decrease (if any source code was changed)
Appropriate docs were updated (if necessary)
Make sure to add ! if this involve a breaking change

🛠️ Fixes #<issue_number_goes_here>

gemini-code-assist · 2025-11-20T19:00:38Z

Summary of Changes

Hello @viragtripathi, I'm Gemini Code Assist¹! I'm currently reviewing this pull request and will post my feedback shortly. In the meantime, here's a summary to help you and other reviewers quickly get up to speed!

This pull request significantly expands the toolbox's capabilities by introducing a robust integration with CockroachDB. It provides a reliable mechanism for interacting with CockroachDB instances, including automatic transaction retries for enhanced fault tolerance. Developers can now leverage a set of specialized tools to execute SQL, query schema and table metadata, streamlining database operations within the ecosystem. The changes also ensure that the new integration adheres to CockroachDB best practices and is thoroughly tested through both unit and integration tests, with updated CI to reflect these additions.

Highlights

CockroachDB Integration: Full support for CockroachDB v25.4.0+ has been added, leveraging the official cockroach-go/v2 library.
Automatic Transaction Retry: The integration includes ExecuteTxWithRetry using crdbpgx.ExecuteTx to handle transient errors and ensure transaction consistency.
New Database Tools: Four new tools are introduced for CockroachDB: execute-sql (for general SQL execution), sql (for parameterized SQL queries), list-tables (to retrieve table metadata), and list-schemas (to list database schemas).
UUID Primary Keys: The implementation promotes CockroachDB best practices by utilizing UUID primary keys.
Comprehensive Testing: New unit tests cover the CockroachDB source and all new tools, alongside integration tests that specifically verify the retry mechanism.
CI/CD Updates: The Cloud Build configuration has been updated to include the new CockroachDB integration tests in the continuous integration pipeline.

Using Gemini Code Assist

The full guide for Gemini Code Assist can be found on our documentation page, here are some quick tips.

Invoking Gemini

You can request assistance from Gemini at any point by creating a comment using either /gemini <command> or @gemini-code-assist <command>. Below is a summary of the supported commands on the current page.

Feature	Command	Description
Code Review	`/gemini review`	Performs a code review for the current pull request in its current state.
Pull Request Summary	`/gemini summary`	Provides a summary of the current pull request in its current state.
Comment	@gemini-code-assist	Responds in comments when explicitly tagged, both in pull request comments and review comments.
Help	`/gemini help`	Displays a list of available commands.

Customization

To customize Gemini Code Assist for GitHub experience, repository maintainers can create a configuration file and/or provide a custom code review style guide (such as PEP-8 for Python) by creating and adding files to a .gemini/ folder in the base of the repository. Detailed instructions can be found here.

Limitations & Feedback

Gemini Code Assist may make mistakes. Please leave feedback on any instances where its feedback is incorrect or counter productive. You can react with 👍 and 👎 on @gemini-code-assist comments. If you're interested in giving your feedback about your experience with Gemini Code Assist for Github and other Google products, sign up here.

You can also get AI-powered code generation, chat, as well as code reviews directly in the IDE at no cost with the Gemini Code Assist IDE Extension.

Review the Privacy Notices, Generative AI Prohibited Use Policy, Terms of Service, and learn how to configure Gemini Code Assist in GitHub here. Gemini can make mistakes, so double check it and use code with caution. ↩

gemini-code-assist

Code Review

This pull request introduces CockroachDB integration, including a new source and four tools. The implementation correctly uses the cockroach-go/v2 library for its core retry logic in the source. However, a critical oversight is that none of the new tools actually use this retry mechanism, instead interacting with the connection pool directly. This undermines a key benefit of the integration. Additionally, there's a bug in how connection string query parameters are constructed, which could fail with special characters. I've also noted some inconsistencies in result formatting and error handling compared to existing tools. The integration and unit tests are a good start but could be expanded to cover these tools more directly.

duwenxin99 · 2025-12-17T16:52:05Z

Hi @viragtripathi, sorry for the delayed review due to my OOO. The PR looks good overall with some changes needed on integration tests. Could you share a link I can follow to set up a CockroachDB instance (preferably docker image) to be used for CI/CD? Thanks!

Yuan325

Hi, please see the following updates from #2204 . Let me know if there's any questions :) Thank you!

Yuan325

Hi, please see the following updates from #2204 . Let me know if there's any questions :) Thank you!

viragtripathi · 2025-12-20T16:33:19Z

Hi @viragtripathi, sorry for the delayed review due to my OOO. The PR looks good overall with some changes needed on integration tests. Could you share a link I can follow to set up a CockroachDB instance (preferably docker image) to be used for CI/CD? Thanks!

Hi @duwenxin99, no worries, I will make the integration test related changes. Here are a couple of examples of setting up CockroachDB instance as part of CI, https://github.com/viragtripathi/cockroachdb-jdbc-wrapper/blob/main/.github/workflows/ci.yml#L25 and https://github.com/viragtripathi/crdb-dump/blob/main/.github/workflows/python-ci.yml#L28.

viragtripathi · 2025-12-20T16:40:28Z

Hi, please see the following updates from #2204 . Let me know if there's any questions :) Thank you!

Thanks, @Yuan325. LGTM :) Is it ok to commit all these changes related to #2204 and test?

duwenxin99 · 2026-01-06T20:26:23Z

Hi @viragtripathi the test instance is set up and running. Feel free to rebase on the latest changes to test. Let me know when you need the integration test to be triggered. Thanks!

Add complete CockroachDB v25.4.0+ integration using official cockroach-go/v2 library for automatic transaction retry. - Add source with Query() for read operations - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add comprehensive unit and integration tests (18 tests) - Add complete documentation for source and all tools - Update Cloud Build configuration for CI Tested on CockroachDB v25.4.0 multi-region cluster. Fixes googleapis#2005

viragtripathi · 2026-01-13T06:59:03Z

Hi @viragtripathi the test instance is set up and running. Feel free to rebase on the latest changes to test. Let me know when you need the integration test to be triggered. Thanks!

Hi @duwenxin99 I just pushed all the changes and I am ready for the integration test.

duwenxin99 · 2026-01-13T15:18:14Z

/gcbrun

- Add MCP security layer with read-only mode, write-mode opt-in, query limits, and telemetry - Implement 7 new tools: describe_table, list_indexes, list_databases, explain_query, show_running_queries, create_database, create_table - Add comprehensive unit tests (12 test packages, 48 test cases) - Add security_test.go with 8 test suites for security features - Update documentation for all 10 tools with accurate parameter descriptions - Add integration tests for all tools - Configure CI/CD with all tool test targets for insecure mode - Follow MCP best practices: stateless design, stable APIs, observability - Fix copyright headers to 2026 - Remove size columns from list_databases (not supported in CockroachDB) - Fix CI configuration for insecure CockroachDB mode

- Add MCP security layer with read-only mode, write-mode opt-in, query limits, and telemetry - Implement 7 new tools: describe_table, list_indexes, list_databases, explain_query, show_running_queries, create_database, create_table - Add comprehensive unit tests (12 test packages, 48 test cases) - Add security_test.go with 8 test suites for security features - Update documentation for all 10 tools with accurate parameter descriptions - Add integration tests for all tools - Configure CI/CD with substitution variables for insecure CockroachDB mode - Follow MCP best practices: stateless design, stable APIs, observability - Fix copyright headers to 2026 - Remove size columns from list_databases (pg_database_size not supported) - Fix go.mod dependencies

duwenxin99 · 2026-01-13T15:50:49Z

Hi @viragtripathi, thanks for updating the PR! We try to limit our PRs to smaller sizes to ensure thorough reviews and reduce the risk of bugs. Could you keep only the main tools in this PR (just sql and execute-sql tools) as an initial integration, and add the rest of the tools in a separate PR? Each extra tool should also come with their own integration test, so trying to fit everything here can make this PR huge. Thanks!

viragtripathi · 2026-01-13T16:57:35Z

Hi @viragtripathi, thanks for updating the PR! We try to limit our PRs to smaller sizes to ensure thorough reviews and reduce the risk of bugs. Could you keep only the main tools in this PR (just sql and execute-sql tools) as an initial integration, and add the rest of the tools in a separate PR? Each extra tool should also come with their own integration test, so trying to fit everything here can make this PR huge. Thanks!

Hi @duwenxin99, thanks for the feedback. I didn’t realize there was an expectation or limit around PR size when I expanded the scope. At this point, reducing it again will require a fair amount of rework.
That said, if keeping the PR limited in scope is a hard requirement, I’m happy to rework this and trim it back to the original set of core tools (the sql and execute-sql tools) as an initial integration, and then follow up with separate PRs for the additional tools, each with their own integration tests.

Please let me know if that’s the preferred path forward, and I’ll start working towards that. Thanks for clarifying.

viragtripathi · 2026-02-11T21:32:34Z

Hi @duwenxin99, In the latest commit (b414b13), I added a separate write-enabled source (my-write-instance) with enableWriteMode: true and readOnlyMode: false specifically for the execute-sql tools. The main source stays read-only. This should resolve the remaining failures. Thanks for re-running!

…-go (#2006) Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes #2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> 1fdd99a

duwenxin99 · 2026-02-11T22:09:24Z

@viragtripathi PR merged. Thanks for the contribution!

…-go (googleapis#2006) Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes googleapis#2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> 1fdd99a

viragtripathi · 2026-02-11T22:41:45Z

@viragtripathi PR merged. Thanks for the contribution!

Thanks @duwenxin99! Appreciate all the help with reviews and CI runs. Looking forward to the follow-up PRs for the remaining tools.

…-go (googleapis#2006) Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes googleapis#2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> 1fdd99a

🤖 I have created a release *beep* *boop* --- ## [0.27.0](v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([#1987](#1987)) ([478a0bd](478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([#2353](#2353)) ([6e49ba4](6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([#2392](#2392)) ([80ef346](80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([#2137](#2137)) ([252fc30](252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([#2006](#2006)) ([1fdd99a](1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([#2340](#2340)) ([e995349](e995349)) * **server:** Add Tool call error categories ([#2387](#2387)) ([32cb4db](32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([#2430](#2430)) ([a15a128](a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([#2347](#2347)) ([1d7c498](1d7c498)) * **sources/cockroachdb:** Update kind to type ([#2465](#2465)) ([2d341ac](2d341ac)) * Surface Dataplex API errors in MCP results ([#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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* --- ## [0.27.0](v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([#1987](#1987)) ([478a0bd](478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([#2353](#2353)) ([6e49ba4](6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([#2392](#2392)) ([80ef346](80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([#2137](#2137)) ([252fc30](252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([#2006](#2006)) ([1fdd99a](1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([#2340](#2340)) ([e995349](e995349)) * **server:** Add Tool call error categories ([#2387](#2387)) ([32cb4db](32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([#2430](#2430)) ([a15a128](a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([#2347](#2347)) ([1d7c498](1d7c498)) * **sources/cockroachdb:** Update kind to type ([#2465](#2465)) ([2d341ac](2d341ac)) * Surface Dataplex API errors in MCP results ([#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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> c5524d3

🤖 I have created a release *beep* *boop* --- ## [0.27.0](googleapis/mcp-toolbox@v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([googleapis#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([googleapis#1987](googleapis#1987)) ([478a0bd](googleapis@478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([googleapis#2353](googleapis#2353)) ([6e49ba4](googleapis@6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([googleapis#2392](googleapis#2392)) ([80ef346](googleapis@80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([googleapis#2137](googleapis#2137)) ([252fc30](googleapis@252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([googleapis#2006](googleapis#2006)) ([1fdd99a](googleapis@1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([googleapis#2340](googleapis#2340)) ([e995349](googleapis@e995349)) * **server:** Add Tool call error categories ([googleapis#2387](googleapis#2387)) ([32cb4db](googleapis@32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([googleapis#2430](googleapis#2430)) ([a15a128](googleapis@a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([googleapis#2347](googleapis#2347)) ([1d7c498](googleapis@1d7c498)) * **sources/cockroachdb:** Update kind to type ([googleapis#2465](googleapis#2465)) ([2d341ac](googleapis@2d341ac)) * Surface Dataplex API errors in MCP results ([googleapis#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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> c5524d3

…-go (googleapis#2006) Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes googleapis#2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> 1fdd99a

🤖 I have created a release *beep* *boop* --- ## [0.27.0](googleapis/mcp-toolbox@v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([googleapis#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([googleapis#1987](googleapis#1987)) ([478a0bd](googleapis@478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([googleapis#2353](googleapis#2353)) ([6e49ba4](googleapis@6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([googleapis#2392](googleapis#2392)) ([80ef346](googleapis@80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([googleapis#2137](googleapis#2137)) ([252fc30](googleapis@252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([googleapis#2006](googleapis#2006)) ([1fdd99a](googleapis@1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([googleapis#2340](googleapis#2340)) ([e995349](googleapis@e995349)) * **server:** Add Tool call error categories ([googleapis#2387](googleapis#2387)) ([32cb4db](googleapis@32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([googleapis#2430](googleapis#2430)) ([a15a128](googleapis@a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([googleapis#2347](googleapis#2347)) ([1d7c498](googleapis@1d7c498)) * **sources/cockroachdb:** Update kind to type ([googleapis#2465](googleapis#2465)) ([2d341ac](googleapis@2d341ac)) * Surface Dataplex API errors in MCP results ([googleapis#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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> c5524d3

Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes #2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com>

🤖 I have created a release *beep* *boop* --- ## [0.27.0](v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([#1987](#1987)) ([478a0bd](478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([#2353](#2353)) ([6e49ba4](6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([#2392](#2392)) ([80ef346](80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([#2137](#2137)) ([252fc30](252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([#2006](#2006)) ([1fdd99a](1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([#2340](#2340)) ([e995349](e995349)) * **server:** Add Tool call error categories ([#2387](#2387)) ([32cb4db](32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([#2430](#2430)) ([a15a128](a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([#2347](#2347)) ([1d7c498](1d7c498)) * **sources/cockroachdb:** Update kind to type ([#2465](#2465)) ([2d341ac](2d341ac)) * Surface Dataplex API errors in MCP results ([#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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>

…gleapis#2006) Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes googleapis#2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com>

🤖 I have created a release *beep* *boop* --- ## [0.27.0](googleapis/mcp-toolbox@v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([googleapis#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([googleapis#1987](googleapis#1987)) ([478a0bd](googleapis@478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([googleapis#2353](googleapis#2353)) ([6e49ba4](googleapis@6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([googleapis#2392](googleapis#2392)) ([80ef346](googleapis@80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([googleapis#2137](googleapis#2137)) ([252fc30](googleapis@252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([googleapis#2006](googleapis#2006)) ([1fdd99a](googleapis@1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([googleapis#2340](googleapis#2340)) ([e995349](googleapis@e995349)) * **server:** Add Tool call error categories ([googleapis#2387](googleapis#2387)) ([32cb4db](googleapis@32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([googleapis#2430](googleapis#2430)) ([a15a128](googleapis@a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([googleapis#2347](googleapis#2347)) ([1d7c498](googleapis@1d7c498)) * **sources/cockroachdb:** Update kind to type ([googleapis#2465](googleapis#2465)) ([2d341ac](googleapis@2d341ac)) * Surface Dataplex API errors in MCP results ([googleapis#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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>

…gleapis#2006) Add support for CockroachDB v25.4.0+ using the official cockroach-go/v2 library for automatic transaction retry. - Add CockroachDB source with ExecuteTxWithRetry using crdbpgx.ExecuteTx - Implement 4 tools: execute-sql, sql, list-tables, list-schemas - Use UUID primary keys (CockroachDB best practice) - Add unit tests for source and all tools - Add integration tests with retry verification - Update Cloud Build configuration for CI Fixes googleapis#2005 ## Description > Should include a concise description of the changes (bug or feature), it's > impact, along with a summary of the solution ## PR Checklist > Thank you for opening a Pull Request! Before submitting your PR, there are a > few things you can do to make sure it goes smoothly: - [ ] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [ ] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [ ] Ensure the tests and linter pass - [ ] Code coverage does not decrease (if any source code was changed) - [ ] Appropriate docs were updated (if necessary) - [ ] Make sure to add `!` if this involve a breaking change 🛠️ Fixes #<issue_number_goes_here> --------- Co-authored-by: duwenxin99 <duwenxin@google.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com>

🤖 I have created a release *beep* *boop* --- ## [0.27.0](googleapis/mcp-toolbox@v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([googleapis#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([googleapis#1987](googleapis#1987)) ([478a0bd](googleapis@478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([googleapis#2353](googleapis#2353)) ([6e49ba4](googleapis@6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([googleapis#2392](googleapis#2392)) ([80ef346](googleapis@80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([googleapis#2137](googleapis#2137)) ([252fc30](googleapis@252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([googleapis#2006](googleapis#2006)) ([1fdd99a](googleapis@1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([googleapis#2340](googleapis#2340)) ([e995349](googleapis@e995349)) * **server:** Add Tool call error categories ([googleapis#2387](googleapis#2387)) ([32cb4db](googleapis@32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([googleapis#2430](googleapis#2430)) ([a15a128](googleapis@a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([googleapis#2347](googleapis#2347)) ([1d7c498](googleapis@1d7c498)) * **sources/cockroachdb:** Update kind to type ([googleapis#2465](googleapis#2465)) ([2d341ac](googleapis@2d341ac)) * Surface Dataplex API errors in MCP results ([googleapis#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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* --- ## [0.27.0](googleapis/mcp-toolbox@v0.26.0...v0.27.0) (2026-02-12) ### ⚠ BREAKING CHANGES * Update configuration file v2 ([#2369](https://github.com/googleapis/genai-toolbox/issues/2369))([293c1d6](https://github.com/googleapis/genai-toolbox/commit/293c1d6889c39807855ba5e01d4c13ba2a4c50ce)) * Update/add detailed telemetry for mcp endpoint compliant with OTEL semantic convention ([#1987](googleapis/mcp-toolbox#1987)) ([478a0bd](googleapis/mcp-toolbox@478a0bd)) ### Features * **cli/invoke:** Add support for direct tool invocation from CLI ([#2353](googleapis/mcp-toolbox#2353)) ([6e49ba4](googleapis/mcp-toolbox@6e49ba4)) * **cli/skills:** Add support for generating agent skills from toolset ([#2392](googleapis/mcp-toolbox#2392)) ([80ef346](googleapis/mcp-toolbox@80ef346)) * **cloud-logging-admin:** Add source, tools, integration test and docs ([#2137](googleapis/mcp-toolbox#2137)) ([252fc30](googleapis/mcp-toolbox@252fc30)) * **cockroachdb:** Add CockroachDB integration with cockroach-go ([#2006](googleapis/mcp-toolbox#2006)) ([1fdd99a](googleapis/mcp-toolbox@1fdd99a)) * **prebuiltconfigs/alloydb-omni:** Implement Alloydb omni dataplane tools ([#2340](googleapis/mcp-toolbox#2340)) ([e995349](googleapis/mcp-toolbox@e995349)) * **server:** Add Tool call error categories ([#2387](googleapis/mcp-toolbox#2387)) ([32cb4db](googleapis/mcp-toolbox@32cb4db)) * **tools/looker:** support `looker-validate-project` tool ([#2430](googleapis/mcp-toolbox#2430)) ([a15a128](googleapis/mcp-toolbox@a15a128)) ### Bug Fixes * **dataplex:** Capture GCP HTTP errors in MCP Toolbox ([#2347](googleapis/mcp-toolbox#2347)) ([1d7c498](googleapis/mcp-toolbox@1d7c498)) * **sources/cockroachdb:** Update kind to type ([#2465](googleapis/mcp-toolbox#2465)) ([2d341ac](googleapis/mcp-toolbox@2d341ac)) * Surface Dataplex API errors in MCP results ([#2347](https://github.com/googleapis/genai-toolbox/pull/2347))([1d7c498](https://github.com/googleapis/genai-toolbox/commit/1d7c4981164c34b4d7bc8edecfd449f57ad11e15)) --- 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>

viragtripathi requested a review from a team November 20, 2025 19:00

blunderbuss-gcf Bot assigned Yuan325 Nov 20, 2025

gemini-code-assist Bot reviewed Nov 20, 2025

View reviewed changes

duwenxin99 assigned duwenxin99 and unassigned Yuan325 Nov 21, 2025

viragtripathi force-pushed the feat/cockroachdb-integration branch from c90de3d to ea146d7 Compare November 22, 2025 03:03

duwenxin99 requested changes Dec 17, 2025

View reviewed changes

Comment thread internal/sources/cockroachdb/cockroachdb_test.go

Comment thread tests/cockroachdb/cockroachdb_integration_test.go

Yuan325 reviewed Dec 20, 2025

View reviewed changes

Yuan325 added the priority: p2 Moderately-important priority. Fix may not be included in next release. label Dec 27, 2025

viragtripathi force-pushed the feat/cockroachdb-integration branch 3 times, most recently from 498b784 to da5d44f Compare January 13, 2026 06:56

viragtripathi requested a review from duwenxin99 January 13, 2026 06:59

duwenxin99 added the tests: run Label to trigger Github Action tests. label Jan 13, 2026

github-actions Bot removed the tests: run Label to trigger Github Action tests. label Jan 13, 2026

viragtripathi force-pushed the feat/cockroachdb-integration branch from da5d44f to faaa7e0 Compare January 13, 2026 15:38

duwenxin99 and others added 2 commits January 13, 2026 10:46

update test config

5dad5f0

duwenxin99 added the tests: run Label to trigger Github Action tests. label Feb 11, 2026

github-actions Bot removed the tests: run Label to trigger Github Action tests. label Feb 11, 2026

duwenxin99 enabled auto-merge (squash) February 11, 2026 22:04

duwenxin99 merged commit 1fdd99a into googleapis:main Feb 11, 2026
13 checks passed

release-please Bot mentioned this pull request Feb 11, 2026

chore(main): release 0.27.0 #2363

Merged

BrewTestBot mentioned this pull request Feb 13, 2026

mcp-toolbox 0.27.0 Homebrew/homebrew-core#267330

Merged

viragtripathi deleted the feat/cockroachdb-integration branch February 14, 2026 00:37

github-actions Bot mentioned this pull request Feb 20, 2026

feat(tools/looker): Enable Get All Lookml Tests tool for Looker Anthrino/genai-toolbox#3

Open

6 tasks

Conversation

viragtripathi commented Nov 20, 2025

Description

PR Checklist

Uh oh!

gemini-code-assist Bot commented Nov 20, 2025

Summary of Changes

Highlights

Footnotes

Uh oh!

gemini-code-assist Bot left a comment

Choose a reason for hiding this comment

Code Review

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

duwenxin99 commented Dec 17, 2025

Uh oh!

Yuan325 left a comment

Choose a reason for hiding this comment

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Yuan325 left a comment

Choose a reason for hiding this comment

Uh oh!

viragtripathi commented Dec 20, 2025

Uh oh!

viragtripathi commented Dec 20, 2025

Uh oh!

duwenxin99 commented Jan 6, 2026

Uh oh!

viragtripathi commented Jan 13, 2026

Uh oh!

duwenxin99 commented Jan 13, 2026

Uh oh!

duwenxin99 commented Jan 13, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

viragtripathi commented Jan 13, 2026

Uh oh!

viragtripathi commented Feb 11, 2026

Uh oh!

Uh oh!

duwenxin99 commented Feb 11, 2026

Uh oh!

viragtripathi commented Feb 11, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

duwenxin99 commented Jan 13, 2026 •

edited

Loading