feat(source/oracledb): add Oracle DB for MCP tools and configurations, updated tools and documentation by dumians · Pull Request #2625 · googleapis/mcp-toolbox

dumians · 2026-03-04T18:06:59Z

Subject

   Oracle DB MCP Toolbox

Type : Feature

Description

Add Oracle DB MCP tools and documentation to reflect functionality for gemini cli extension

🛠️ Feature #<475844916>

…nding (googleapis#2219) ## Summary Adds MCP tool annotations (`readOnlyHint`, `destructiveHint`) to all 9 MongoDB tools to help LLMs better understand tool behavior and make safer decisions. ## Changes | Tool | Annotation | |------|------------| | mongodb-find | `readOnlyHint: true` | | mongodb-find-one | `readOnlyHint: true` | | mongodb-aggregate | `readOnlyHint: true` | | mongodb-insert-one | `destructiveHint: true` | | mongodb-insert-many | `destructiveHint: true` | | mongodb-update-one | `destructiveHint: true` | | mongodb-update-many | `destructiveHint: true` | | mongodb-delete-one | `destructiveHint: true` | | mongodb-delete-many | `destructiveHint: true` | ## Implementation Each tool now: 1. Has an `Annotations` field in its Config struct for YAML configurability 2. Provides default annotations if not explicitly configured 3. Passes annotations to `GetMcpManifest()` instead of `nil` This follows the exact pattern established by the Looker tools (e.g., `lookergetconnectionschemas`, `lookerupdateprojectfile`). ## Why This Matters - **Semantic metadata**: Annotations provide information beyond just the tool description - **Safety signals**: `readOnlyHint` tells LLMs a tool is safe to call without side effects - **Destructive awareness**: `destructiveHint` signals LLMs should be more careful before executing - **Better tool selection**: LLMs can prioritize read-only tools for information gathering - **MCP compliance**: Follows the [MCP tool annotations specification](https://modelcontextprotocol.io/specification/2025-06-18/schema#toolannotations) ## Testing - [ ] CI builds successfully - [ ] `tools/list` returns annotations in MCP response ## Files Changed - `internal/tools/mongodb/mongodbfind/mongodbfind.go` - `internal/tools/mongodb/mongodbfindone/mongodbfindone.go` - `internal/tools/mongodb/mongodbaggregate/mongodbaggregate.go` - `internal/tools/mongodb/mongodbinsertone/mongodbinsertone.go` - `internal/tools/mongodb/mongodbinsertmany/mongodbinsertmany.go` - `internal/tools/mongodb/mongodbupdateone/mongodbupdateone.go` - `internal/tools/mongodb/mongodbupdatemany/mongodbupdatemany.go` - `internal/tools/mongodb/mongodbdeleteone/mongodbdeleteone.go` - `internal/tools/mongodb/mongodbdeletemany/mongodbdeletemany.go` 🤖 Generated with [Claude Code](https://claude.com/claude-code) --------- Co-authored-by: triepod-ai <199543909+triepod-ai@users.noreply.github.com> Co-authored-by: bryankthompson <199543909+bryankthompson@users.noreply.github.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com>

google-cla · 2026-03-04T18:07:24Z

Thanks for your pull request! It looks like this may be your first contribution to a Google open source project. Before we can look at your pull request, you'll need to sign a Contributor License Agreement (CLA).

View this failed invocation of the CLA check for more information.

For the most up to date status, view the checks section at the bottom of the pull request.

gemini-code-assist · 2026-03-04T18:09:33Z

Summary of Changes

Hello, 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 introduces comprehensive support for Oracle Database within the Model Context Protocol (MCP) tools, enabling seamless integration with various IDEs and LLM assistants. It focuses on expanding the capabilities of the MCP Toolbox to interact with Oracle DB, ensuring that developers can leverage AI-powered assistance for Oracle-related tasks. The changes include core tool definitions, CI updates, and extensive user-facing documentation.

Highlights

Oracle DB Integration: Added full support for Oracle Database as a data source for Model Context Protocol (MCP) tools.
New Prebuilt Tools: Introduced a suite of prebuilt tools for Oracle DB, including list_tables, execute_sql, list_active_sessions, get_query_plan, list_top_sql_by_resource, list_tablespace_usage, and list_invalid_objects.
Updated Documentation: Provided detailed guides for connecting various IDEs and LLM clients (like Claude, Cursor, VS Code, Gemini CLI/Code Assist) to Oracle DB via MCP, along with reference documentation for Oracle-specific environment variables and tools.
CI/Testing Enhancements: Updated the CI pipeline to use a newer Go version and added test configurations for Oracle DB environment variables and prebuilt tools.

Changelog

.ci/integration.cloudbuild.yaml
- Updated the Go version used in the CI pipeline from 1.25.1 to 1.25.5.
.github/release-please.yml
- Added docs/en/how-to/connect-ide/oracle_mcp.md to the extraFiles list for release management.
cmd/internal/tools_file_test.go
- Added environment variables for Oracle DB connection parameters (username, password, host, port, OCI usage, wallet location, TNS admin) for testing purposes.
- Included a new test case to verify the loading of Oracle prebuilt tools.
docs/en/how-to/connect-ide/oracle_mcp.md
- Added a new documentation page detailing how to connect various IDEs and LLM clients (Claude, Cline, Cursor, VS Code, Windsurf, Gemini CLI, Gemini Code Assist) to Oracle DB using MCP Toolbox.
docs/en/reference/prebuilt-tools.md
- Appended a new section for Oracle prebuilt tools, listing available tools and required environment variables.
docs/en/resources/sources/oracle.md
- Added walletLocation as a configuration option for Oracle sources.
docs/en/resources/tools/oracle/oracle-list-tables.md
- Added a new documentation page specifically for the list_tables Oracle tool, explaining its purpose and providing an example.
docs/en/samples/oracle/_index.md
- Added a new index file for Oracle samples documentation.
internal/prebuiltconfigs/prebuiltconfigs_test.go
- Included oracledb in the list of expected tool sources for testing.
- Added logic to fetch and verify the oracledb prebuilt configuration.
internal/prebuiltconfigs/tools/oracledb.yaml
- Added a new YAML configuration file defining the oracle-source and a comprehensive set of Oracle-specific tools (list_tables, list_active_sessions, get_query_plan, list_top_sql_by_resource, list_tablespace_usage, list_invalid_objects) and a oracle_database_tools toolset.

Activity

No human activity (comments, reviews, etc.) has been recorded for this pull request yet.

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 adds support for Oracle DB as a new data source, including prebuilt tools, configurations, and extensive documentation, and introduces a new annotations feature for tools to provide semantic metadata. A critical security issue was identified in the mongodb-aggregate tool where its safety hint may incorrectly indicate it's read-only even when configured for destructive operations, potentially leading to accidental data modification. Additionally, several inconsistencies and errors were found in the documentation and prebuilt tool definitions, specifically regarding environment variables, tool lists not matching implementation, and incorrect or confusing prebuilt SQL queries for Oracle tools.

I am having trouble creating individual review comments. Click here to see my feedback.

docs/en/how-to/connect-ide/oracle_mcp.md (95-103)

The environment variables in this configuration example are inconsistent with the implementation in internal/prebuiltconfigs/tools/oracledb.yaml. The prebuilt configuration uses ORACLE_CONNECTION_STRING instead of ORACLE_HOST, ORACLE_PORT, and ORACLE_SERVICE. It also expects ORACLE_WALLET, not ORACLE_WALLET_LOCATION.

This discrepancy is present across all configuration tabs in this document and will likely cause user connections to fail. Please update the documentation to use the correct environment variables.

          "env": {
            "ORACLE_CONNECTION_STRING": "",
            "ORACLE_USER": "",
            "ORACLE_PASSWORD": "",
            "ORACLE_WALLET": "",
            "ORACLE_USE_OCI": "false"
          }

docs/en/reference/prebuilt-tools.md (878-884)

The environment variables section for Oracle has a few issues:

The descriptions for ORACLE_CONNECTION_STRING, ORACLE_USER, and ORACLE_PASSWORD are incomplete, simply stating "The".
The list includes ORACLE_HOST and ORACLE_PORT, which are not used by the prebuilt configuration. The configuration relies on ORACLE_CONNECTION_STRING instead.

Please correct the descriptions and remove the unused environment variables to avoid confusing users.

    *   `ORACLE_CONNECTION_STRING`: The connection string for the Oracle server (e.g., "hostname:port/servicename").
    *   `ORACLE_USER`: The database username.
    *   `ORACLE_PASSWORD`: The password for the database user.
    *   `ORACLE_WALLET`: The path to the Oracle DB Wallet file for databases that support this authentication type.
    *   `ORACLE_USE_OCI`: A boolean flag (`true` or `false`) indicating if the Oracle Database is a cloud deployment that requires the OCI driver.

internal/prebuiltconfigs/tools/oracledb.yaml (63-77)

This tool is intended to list top SQL statements by a resource metric, but the query is missing an ORDER BY clause. Using FETCH FIRST 5 ROWS ONLY without ordering will return an arbitrary, non-deterministic set of rows. To fix this, you should add an ORDER BY clause based on a relevant resource metric like cpu_time, elapsed_time, or disk_reads.

        statement: | 
            SELECT
                sql_id,
                executions,
                buffer_gets,
                disk_reads,
                cpu_time / 1000000 AS cpu_seconds,
                elapsed_time / 1000000 AS elapsed_seconds
            FROM
                v$sql
            ORDER BY
                elapsed_time DESC
            FETCH FIRST 5 ROWS ONLY;

internal/tools/mongodb/mongodbaggregate/mongodbaggregate.go (87)

The mongodb-aggregate tool defaults its MCP ReadOnlyHint to true via tools.NewReadOnlyAnnotations, regardless of the actual readOnly configuration of the tool. If a tool is configured with readOnly: false (which allows destructive aggregation stages like $out or $merge), the MCP client will still receive a hint that the tool is read-only. This could lead to users accidentally executing destructive operations without being prompted for confirmation by the client, bypassing a key safety mechanism of the Model Context Protocol.

cmd/internal/tools_file_test.go (1959-1964)

This test case for "Oracle prebuilt tools" has a couple of discrepancies with the configuration in internal/prebuiltconfigs/tools/oracledb.yaml:

The toolset name in the test is "oracle_tools", but the name in the YAML file is "oracle_database_tools".
The list of ToolNames is missing the "list_invalid_objects" tool, which is present in the YAML toolset.

Please update the test to accurately reflect the prebuilt configuration.

            wantToolset: server.ToolsetConfigs{
				"oracle_database_tools": tools.ToolsetConfig{
					Name:      "oracle_database_tools",
					ToolNames: []string{"execute_sql", "list_tables", "list_active_sessions", "get_query_plan", "list_top_sql_by_resource", "list_tablespace_usage", "list_invalid_objects"},
				},
			},

docs/en/how-to/connect-ide/oracle_mcp.md (335-336)

This list of available tools is incomplete. The prebuilt Oracle configuration provides several other tools, including list_active_sessions, get_query_plan, and list_invalid_objects. Please update the documentation to include all available tools to give users a complete picture of the functionality.

1. **execute_sql**: execute any SQL statement
2. **list_tables**: lists tables and descriptions
3. **list_active_sessions**: Lists active database sessions.
4. **get_query_plan**: Gets the execution plan for a SQL statement.
5. **list_top_sql_by_resource**: Lists top SQL statements by resource usage.
6. **list_tablespace_usage**: Lists tablespace usage.
7. **list_invalid_objects**: Lists invalid objects.

docs/en/reference/prebuilt-tools.md (897-901)

These tool entries are duplicates of the ones listed just above. Please remove these repeated lines to improve clarity.

internal/prebuiltconfigs/tools/oracledb.yaml (32-55)

The description for this tool states it lists the "top N (default 50)" sessions, but the query hardcodes a limit of 10. This is inconsistent. Additionally, using COALESCE(10) for a hardcoded limit is unusual; simply using 10 would be more direct. Please consider making the limit a parameter or updating the description to match the hardcoded value.

internal/prebuiltconfigs/tools/oracledb.yaml (57-61)

The description for get_query_plan is confusing. It mentions an example EXPLAIN PLAN FOR {{&query}};, but the actual statement is SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());, which doesn't take a query as input. This suggests a multi-step process (running EXPLAIN PLAN first) that isn't documented or supported by this single tool definition. Please clarify the description and intended usage of this tool.

duwenxin99 · 2026-03-04T20:06:02Z

Code Review

This pull request adds support for Oracle DB as a new data source, including prebuilt tools, configurations, and extensive documentation, and introduces a new annotations feature for tools to provide semantic metadata. A critical security issue was identified in the mongodb-aggregate tool where its safety hint may incorrectly indicate it's read-only even when configured for destructive operations, potentially leading to accidental data modification. Additionally, several inconsistencies and errors were found in the documentation and prebuilt tool definitions, specifically regarding environment variables, tool lists not matching implementation, and incorrect or confusing prebuilt SQL queries for Oracle tools.

I am having trouble creating individual review comments. Click here to see my feedback.

docs/en/how-to/connect-ide/oracle_mcp.md (95-103)

The environment variables in this configuration example are inconsistent with the implementation in internal/prebuiltconfigs/tools/oracledb.yaml. The prebuilt configuration uses ORACLE_CONNECTION_STRING instead of ORACLE_HOST, ORACLE_PORT, and ORACLE_SERVICE. It also expects ORACLE_WALLET, not ORACLE_WALLET_LOCATION.

This discrepancy is present across all configuration tabs in this document and will likely cause user connections to fail. Please update the documentation to use the correct environment variables.
          "env": {
            "ORACLE_CONNECTION_STRING": "",
            "ORACLE_USER": "",
            "ORACLE_PASSWORD": "",
            "ORACLE_WALLET": "",
            "ORACLE_USE_OCI": "false"
          }
docs/en/reference/prebuilt-tools.md (878-884)

The environment variables section for Oracle has a few issues:

The descriptions for ORACLE_CONNECTION_STRING, ORACLE_USER, and ORACLE_PASSWORD are incomplete, simply stating "The".

The list includes ORACLE_HOST and ORACLE_PORT, which are not used by the prebuilt configuration. The configuration relies on ORACLE_CONNECTION_STRING instead.

Please correct the descriptions and remove the unused environment variables to avoid confusing users.
    *   `ORACLE_CONNECTION_STRING`: The connection string for the Oracle server (e.g., "hostname:port/servicename").
    *   `ORACLE_USER`: The database username.
    *   `ORACLE_PASSWORD`: The password for the database user.
    *   `ORACLE_WALLET`: The path to the Oracle DB Wallet file for databases that support this authentication type.
    *   `ORACLE_USE_OCI`: A boolean flag (`true` or `false`) indicating if the Oracle Database is a cloud deployment that requires the OCI driver.
internal/prebuiltconfigs/tools/oracledb.yaml (63-77)

This tool is intended to list top SQL statements by a resource metric, but the query is missing an ORDER BY clause. Using FETCH FIRST 5 ROWS ONLY without ordering will return an arbitrary, non-deterministic set of rows. To fix this, you should add an ORDER BY clause based on a relevant resource metric like cpu_time, elapsed_time, or disk_reads.
        statement: | 
            SELECT
                sql_id,
                executions,
                buffer_gets,
                disk_reads,
                cpu_time / 1000000 AS cpu_seconds,
                elapsed_time / 1000000 AS elapsed_seconds
            FROM
                v$sql
            ORDER BY
                elapsed_time DESC
            FETCH FIRST 5 ROWS ONLY;
internal/tools/mongodb/mongodbaggregate/mongodbaggregate.go (87)

The mongodb-aggregate tool defaults its MCP ReadOnlyHint to true via tools.NewReadOnlyAnnotations, regardless of the actual readOnly configuration of the tool. If a tool is configured with readOnly: false (which allows destructive aggregation stages like $out or $merge), the MCP client will still receive a hint that the tool is read-only. This could lead to users accidentally executing destructive operations without being prompted for confirmation by the client, bypassing a key safety mechanism of the Model Context Protocol.

cmd/internal/tools_file_test.go (1959-1964)

This test case for "Oracle prebuilt tools" has a couple of discrepancies with the configuration in internal/prebuiltconfigs/tools/oracledb.yaml:

The toolset name in the test is "oracle_tools", but the name in the YAML file is "oracle_database_tools".

The list of ToolNames is missing the "list_invalid_objects" tool, which is present in the YAML toolset.

Please update the test to accurately reflect the prebuilt configuration.
            wantToolset: server.ToolsetConfigs{
				"oracle_database_tools": tools.ToolsetConfig{
					Name:      "oracle_database_tools",
					ToolNames: []string{"execute_sql", "list_tables", "list_active_sessions", "get_query_plan", "list_top_sql_by_resource", "list_tablespace_usage", "list_invalid_objects"},
				},
			},
docs/en/how-to/connect-ide/oracle_mcp.md (335-336)

This list of available tools is incomplete. The prebuilt Oracle configuration provides several other tools, including list_active_sessions, get_query_plan, and list_invalid_objects. Please update the documentation to include all available tools to give users a complete picture of the functionality.
1. **execute_sql**: execute any SQL statement
2. **list_tables**: lists tables and descriptions
3. **list_active_sessions**: Lists active database sessions.
4. **get_query_plan**: Gets the execution plan for a SQL statement.
5. **list_top_sql_by_resource**: Lists top SQL statements by resource usage.
6. **list_tablespace_usage**: Lists tablespace usage.
7. **list_invalid_objects**: Lists invalid objects.
docs/en/reference/prebuilt-tools.md (897-901)

These tool entries are duplicates of the ones listed just above. Please remove these repeated lines to improve clarity.

internal/prebuiltconfigs/tools/oracledb.yaml (32-55)

The description for this tool states it lists the "top N (default 50)" sessions, but the query hardcodes a limit of 10. This is inconsistent. Additionally, using COALESCE(10) for a hardcoded limit is unusual; simply using 10 would be more direct. Please consider making the limit a parameter or updating the description to match the hardcoded value.

internal/prebuiltconfigs/tools/oracledb.yaml (57-61)

The description for get_query_plan is confusing. It mentions an example EXPLAIN PLAN FOR {{&query}};, but the actual statement is SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());, which doesn't take a query as input. This suggests a multi-step process (running EXPLAIN PLAN first) that isn't documented or supported by this single tool definition. Please clarify the description and intended usage of this tool.

Could you resolve these Gemini commands and tag me once it's ready? I'll re-review and trigger the integration tests for you.

…tation variables consitency

…rmatting

duwenxin99 · 2026-03-05T17:17:12Z

/gemini review

gemini-code-assist

Code Review

This pull request introduces support for Oracle DB as a data source, including new tools, configurations, and documentation. However, a high-severity SQL injection vulnerability was identified in the get_query_plan prebuilt tool configuration due to the use of raw template substitution for user-supplied queries. Additionally, the inclusion of the execute_sql tool in the default toolset poses a significant risk when exposed to Large Language Models (LLMs) due to its arbitrary SQL execution capability. Beyond security concerns, the review also identified critical and high-severity issues in prebuilt tool definitions, such as mismatches between tool descriptions and SQL statements, and a tool (get_query_plan) that is implemented in a way that will cause it to fail. Documentation errors, like using the wrong name for the prebuilt configuration, also need to be addressed to ensure the feature is reliable and usable.

…umentation inconsistencies

dumians · 2026-03-06T14:01:38Z

/gemini review

gemini-code-assist

Code Review

This pull request introduces support for Oracle DB as a data source, including pre-built tools and associated documentation. A high-severity SQL injection vulnerability was identified in the prebuilt configuration for the get_query_plan tool due to the use of unescaped template parameters. Additionally, the get_query_plan tool is functionally broken as it attempts to execute multiple SQL statements, which is not supported. There is also an invalid JSON configuration example in the new documentation, inconsistencies between tool descriptions and their actual queries, and minor documentation improvements needed.

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

…n and configuration files

dumians · 2026-03-09T10:11:48Z

/gemini review

duwenxin99 · 2026-03-17T16:51:44Z

/gcbrun

github-actions · 2026-03-17T16:58:31Z

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

duwenxin99 · 2026-03-18T01:24:02Z

/gcbrun

github-actions · 2026-03-18T01:28:36Z

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

duwenxin99 · 2026-03-18T14:37:10Z

/gcbrun

github-actions · 2026-03-18T14:51:01Z

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

duwenxin99 · 2026-03-18T19:09:55Z

/gcbrun

github-actions · 2026-03-18T19:13:18Z

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

…urations, updated tools and documentation (#2625) ## Subject Oracle DB MCP Toolbox ## Type : Feature ## Description Add Oracle DB MCP tools and documentation to reflect functionality for gemini cli extension 🛠️ Feature #<475844916> --------- Co-authored-by: Bryan Thompson <bthompson@maillocker.net> Co-authored-by: triepod-ai <199543909+triepod-ai@users.noreply.github.com> Co-authored-by: bryankthompson <199543909+bryankthompson@users.noreply.github.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com> e350fc7

…urations, updated tools and documentation (googleapis#2625) ## Subject Oracle DB MCP Toolbox ## Type : Feature ## Description Add Oracle DB MCP tools and documentation to reflect functionality for gemini cli extension 🛠️ Feature #<475844916> --------- Co-authored-by: Bryan Thompson <bthompson@maillocker.net> Co-authored-by: triepod-ai <199543909+triepod-ai@users.noreply.github.com> Co-authored-by: bryankthompson <199543909+bryankthompson@users.noreply.github.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com> e350fc7

🤖 I have created a release *beep* *boop* --- ## [0.30.0](v0.29.0...v0.30.0) (2026-03-20) ### Features * **cli:** Add migrate subcommand ([#2679](#2679)) ([12171f7](12171f7)) * **cli:** Add serve subcommand ([#2550](#2550)) ([1e2c7c7](1e2c7c7)) * **skill:** One skill per toolset ([#2733](#2733)) ([5b85c65](5b85c65)) * **source/oracledb:** Add Oracle DB for MCP tools and configurations, updated tools and documentation ([#2625](#2625)) ([e350fc7](e350fc7)) * **tools/looker:** Support git_branch tools for looker. ([#2718](#2718)) ([70ed8a0](70ed8a0)) * **tools/dataplex-search-entries:** Add `scope` support to search_entries tool ([#2740](#2740)) ([10af468](10af468)) ### Bug Fixes * **cloudloggingadmin:** Increase log injesting time and add auth test ([#2772](#2772)) ([50b4457](50b4457)) * **oracle:** Normalize encoded proxy usernames in go-ora DSN ([#2469](#2469)) ([b1333cd](b1333cd)) * **postgres:** Update execute-sql tool to avoid multi-statements parameter ([#2707](#2707)) ([58bc772](58bc772)) * **skills:** Improve flag validation and silence unit test output ([#2759](#2759)) ([f3da6aa](f3da6aa)) * **test:** Address flaky healthcare integration test run ([#2742](#2742)) ([9590821](9590821)) ### Reverts * **ci:** Implement conditional sharding logic in integration tests ([#2763](#2763)) ([1528d7c](1528d7c)) --- 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.30.0](v0.29.0...v0.30.0) (2026-03-20) ### Features * **cli:** Add migrate subcommand ([#2679](#2679)) ([12171f7](12171f7)) * **cli:** Add serve subcommand ([#2550](#2550)) ([1e2c7c7](1e2c7c7)) * **skill:** One skill per toolset ([#2733](#2733)) ([5b85c65](5b85c65)) * **source/oracledb:** Add Oracle DB for MCP tools and configurations, updated tools and documentation ([#2625](#2625)) ([e350fc7](e350fc7)) * **tools/looker:** Support git_branch tools for looker. ([#2718](#2718)) ([70ed8a0](70ed8a0)) * **tools/dataplex-search-entries:** Add `scope` support to search_entries tool ([#2740](#2740)) ([10af468](10af468)) ### Bug Fixes * **cloudloggingadmin:** Increase log injesting time and add auth test ([#2772](#2772)) ([50b4457](50b4457)) * **oracle:** Normalize encoded proxy usernames in go-ora DSN ([#2469](#2469)) ([b1333cd](b1333cd)) * **postgres:** Update execute-sql tool to avoid multi-statements parameter ([#2707](#2707)) ([58bc772](58bc772)) * **skills:** Improve flag validation and silence unit test output ([#2759](#2759)) ([f3da6aa](f3da6aa)) * **test:** Address flaky healthcare integration test run ([#2742](#2742)) ([9590821](9590821)) ### Reverts * **ci:** Implement conditional sharding logic in integration tests ([#2763](#2763)) ([1528d7c](1528d7c)) --- 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> 5ef1c0d

🤖 I have created a release *beep* *boop* --- ## [0.30.0](googleapis/mcp-toolbox@v0.29.0...v0.30.0) (2026-03-20) ### Features * **cli:** Add migrate subcommand ([googleapis#2679](googleapis#2679)) ([12171f7](googleapis@12171f7)) * **cli:** Add serve subcommand ([googleapis#2550](googleapis#2550)) ([1e2c7c7](googleapis@1e2c7c7)) * **skill:** One skill per toolset ([googleapis#2733](googleapis#2733)) ([5b85c65](googleapis@5b85c65)) * **source/oracledb:** Add Oracle DB for MCP tools and configurations, updated tools and documentation ([googleapis#2625](googleapis#2625)) ([e350fc7](googleapis@e350fc7)) * **tools/looker:** Support git_branch tools for looker. ([googleapis#2718](googleapis#2718)) ([70ed8a0](googleapis@70ed8a0)) * **tools/dataplex-search-entries:** Add `scope` support to search_entries tool ([googleapis#2740](googleapis#2740)) ([10af468](googleapis@10af468)) ### Bug Fixes * **cloudloggingadmin:** Increase log injesting time and add auth test ([googleapis#2772](googleapis#2772)) ([50b4457](googleapis@50b4457)) * **oracle:** Normalize encoded proxy usernames in go-ora DSN ([googleapis#2469](googleapis#2469)) ([b1333cd](googleapis@b1333cd)) * **postgres:** Update execute-sql tool to avoid multi-statements parameter ([googleapis#2707](googleapis#2707)) ([58bc772](googleapis@58bc772)) * **skills:** Improve flag validation and silence unit test output ([googleapis#2759](googleapis#2759)) ([f3da6aa](googleapis@f3da6aa)) * **test:** Address flaky healthcare integration test run ([googleapis#2742](googleapis#2742)) ([9590821](googleapis@9590821)) ### Reverts * **ci:** Implement conditional sharding logic in integration tests ([googleapis#2763](googleapis#2763)) ([1528d7c](googleapis@1528d7c)) --- 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> 5ef1c0d

…, updated tools and documentation (googleapis#2625) ## Subject Oracle DB MCP Toolbox ## Type : Feature ## Description Add Oracle DB MCP tools and documentation to reflect functionality for gemini cli extension 🛠️ Feature #<475844916> --------- Co-authored-by: Bryan Thompson <bthompson@maillocker.net> Co-authored-by: triepod-ai <199543909+triepod-ai@users.noreply.github.com> Co-authored-by: bryankthompson <199543909+bryankthompson@users.noreply.github.com> Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

🤖 I have created a release *beep* *boop* --- ## [0.30.0](googleapis/mcp-toolbox@v0.29.0...v0.30.0) (2026-03-20) ### Features * **cli:** Add migrate subcommand ([googleapis#2679](googleapis#2679)) ([12171f7](googleapis@12171f7)) * **cli:** Add serve subcommand ([googleapis#2550](googleapis#2550)) ([1e2c7c7](googleapis@1e2c7c7)) * **skill:** One skill per toolset ([googleapis#2733](googleapis#2733)) ([5b85c65](googleapis@5b85c65)) * **source/oracledb:** Add Oracle DB for MCP tools and configurations, updated tools and documentation ([googleapis#2625](googleapis#2625)) ([e350fc7](googleapis@e350fc7)) * **tools/looker:** Support git_branch tools for looker. ([googleapis#2718](googleapis#2718)) ([70ed8a0](googleapis@70ed8a0)) * **tools/dataplex-search-entries:** Add `scope` support to search_entries tool ([googleapis#2740](googleapis#2740)) ([10af468](googleapis@10af468)) ### Bug Fixes * **cloudloggingadmin:** Increase log injesting time and add auth test ([googleapis#2772](googleapis#2772)) ([50b4457](googleapis@50b4457)) * **oracle:** Normalize encoded proxy usernames in go-ora DSN ([googleapis#2469](googleapis#2469)) ([b1333cd](googleapis@b1333cd)) * **postgres:** Update execute-sql tool to avoid multi-statements parameter ([googleapis#2707](googleapis#2707)) ([58bc772](googleapis@58bc772)) * **skills:** Improve flag validation and silence unit test output ([googleapis#2759](googleapis#2759)) ([f3da6aa](googleapis@f3da6aa)) * **test:** Address flaky healthcare integration test run ([googleapis#2742](googleapis#2742)) ([9590821](googleapis@9590821)) ### Reverts * **ci:** Implement conditional sharding logic in integration tests ([googleapis#2763](googleapis#2763)) ([1528d7c](googleapis@1528d7c)) --- 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>

dumians and others added 2 commits March 4, 2026 18:39

feat(oracle): add Oracle prebuilt tools and documentation

cd93496

dumians requested a review from a team as a code owner March 4, 2026 18:06

blunderbuss-gcf Bot assigned duwenxin99 Mar 4, 2026

Merge branch 'main' into OracleToolbox

efb7365

dumians changed the title ~~add Oracle DB for MCP tools and configurations, updated tools and documentation (#2219)~~ add Oracle DB for MCP tools and configurations, updated tools and documentation Mar 4, 2026

gemini-code-assist Bot reviewed Mar 4, 2026

View reviewed changes

Fix formatting issue in tools_file_test.go

6b70521

dumians changed the title ~~add Oracle DB for MCP tools and configurations, updated tools and documentation~~ feat(sources): add Oracle DB for MCP tools and configurations, updated tools and documentation Mar 4, 2026

Fix formatting in tools_file_test.go

fcdb408

dumians added 2 commits March 5, 2026 16:28

fix(tests): correct syntax in TestPrebuiltTools functions and documen…

38b4568

…tation variables consitency

Merge branch 'main' into OracleToolbox

06fdc05

duwenxin99 reviewed Mar 5, 2026

View reviewed changes

Comment thread cmd/internal/tools_file_test.go Outdated

dumians added 2 commits March 5, 2026 17:25

feat(tests): fix struct initialization in TestPrebuiltTools function

fa5df75

feat(tests): add Oracle configuration to TestPrebuiltTools and fix fo…

9d689d9

…rmatting

gemini-code-assist Bot reviewed Mar 5, 2026

View reviewed changes

fix(docs): update Oracle prebuilt tool configurations and correct doc…

eb59a94

…umentation inconsistencies

dumians changed the title ~~feat(sources): add Oracle DB for MCP tools and configurations, updated tools and documentation~~ feat(source/oracledb): add Oracle DB for MCP tools and configurations, updated tools and documentation Mar 5, 2026

Merge branch 'main' into OracleToolbox

c76833f

gemini-code-assist Bot reviewed Mar 6, 2026

View reviewed changes

dumians and others added 4 commits March 6, 2026 18:15

Update docs/en/how-to/connect-ide/oracle_mcp.md

3e34a24

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

Update docs/en/reference/prebuilt-tools.md

5e7461d

Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>

Merge branch 'main' into OracleToolbox

3bac4ab

fix(docs): correct descriptions and formatting in Oracle documentatio…

9ae8294

…n and configuration files

Merge branch 'main' into OracleToolbox

31912d2

duwenxin99 approved these changes Mar 18, 2026

View reviewed changes

dumians requested a review from duwenxin99 March 18, 2026 09:22

Merge branch 'main' into OracleToolbox

ff7441c

Merge branch 'main' into OracleToolbox

3b2946a

duwenxin99 enabled auto-merge (squash) March 18, 2026 19:14

duwenxin99 merged commit e350fc7 into googleapis:main Mar 18, 2026
21 checks passed

release-please Bot mentioned this pull request Mar 18, 2026

chore(main): release 0.30.0 #2758

Merged

BrewTestBot mentioned this pull request Mar 20, 2026

mcp-toolbox 0.30.0 Homebrew/homebrew-core#273330

Merged

duwenxin99 mentioned this pull request Mar 24, 2026

feat: add Oracle DB for MCP tools and configurations , also updated documentation #2325

Closed

Conversation

dumians commented Mar 4, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Subject

Type : Feature

Description

Uh oh!

google-cla Bot commented Mar 4, 2026

Uh oh!

gemini-code-assist Bot commented Mar 4, 2026

Summary of Changes

Highlights

Footnotes

Uh oh!

gemini-code-assist Bot left a comment

Choose a reason for hiding this comment

Code Review

docs/en/how-to/connect-ide/oracle_mcp.md (95-103)

docs/en/reference/prebuilt-tools.md (878-884)

internal/prebuiltconfigs/tools/oracledb.yaml (63-77)

internal/tools/mongodb/mongodbaggregate/mongodbaggregate.go (87)

cmd/internal/tools_file_test.go (1959-1964)

docs/en/how-to/connect-ide/oracle_mcp.md (335-336)

docs/en/reference/prebuilt-tools.md (897-901)

internal/prebuiltconfigs/tools/oracledb.yaml (32-55)

internal/prebuiltconfigs/tools/oracledb.yaml (57-61)

Uh oh!

duwenxin99 commented Mar 4, 2026

Code Review

docs/en/how-to/connect-ide/oracle_mcp.md (95-103)

docs/en/reference/prebuilt-tools.md (878-884)

internal/prebuiltconfigs/tools/oracledb.yaml (63-77)

internal/tools/mongodb/mongodbaggregate/mongodbaggregate.go (87)

cmd/internal/tools_file_test.go (1959-1964)

docs/en/how-to/connect-ide/oracle_mcp.md (335-336)

docs/en/reference/prebuilt-tools.md (897-901)

internal/prebuiltconfigs/tools/oracledb.yaml (32-55)

internal/prebuiltconfigs/tools/oracledb.yaml (57-61)

Uh oh!

Uh oh!

duwenxin99 commented Mar 5, 2026

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!

dumians commented Mar 6, 2026

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!

dumians commented Mar 9, 2026

Uh oh!

duwenxin99 commented Mar 17, 2026

Uh oh!

github-actions Bot commented Mar 17, 2026

Uh oh!

duwenxin99 commented Mar 18, 2026

Uh oh!

github-actions Bot commented Mar 18, 2026

Uh oh!

duwenxin99 commented Mar 18, 2026

Uh oh!

dumians commented Mar 4, 2026 •

edited

Loading