feat(sources/oracle): Add Oracle OCI and Wallet support by duwenxin99 · Pull Request #1945 · googleapis/mcp-toolbox

duwenxin99 · 2025-11-13T16:07:16Z

Previously we used go-ora (a pure Go Oracle driver) because our release pipeline did not support cross-compilation with CGO. Now that it's fixed, we want to add support for Oracle OCI driver for advanced features including digital wallet etc.

Users will be able to configure a source to use OCI by specifying a UseOCI: true field. The source defaults to use the pure Go driver otherwise.

Oracle Wallet:

OCI users should use the tnsAdmin to set the wallet location
Non-OCI users can should use the walletLocation field.

fix: #1779

github-actions · 2025-11-13T16:10:21Z

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

averikitsch

Is this just reverting the changes required for the first release?

github-actions · 2025-11-14T21:36:10Z

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

github-actions · 2025-11-14T21:49:27Z

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

github-actions · 2025-11-14T22:00:37Z

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

duwenxin99 · 2025-11-14T22:12:21Z

Is this just reverting the changes required for the first release?

@averikitsch Not really. This adds a config field UseOCI that allows users to freely choose whether or not to use the OCI driver. The initial PR only used the OCI driver.

github-actions · 2025-11-14T22:13:53Z

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

github-actions · 2025-11-15T00:14:01Z

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

github-actions · 2025-12-05T00:00:09Z

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

github-actions · 2025-12-09T19:35:15Z

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

github-actions · 2025-12-09T20:11:26Z

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

github-actions · 2025-12-09T20:25:42Z

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

github-actions · 2025-12-17T21:49:52Z

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

github-actions · 2025-12-18T00:09:36Z

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

github-actions · 2025-12-18T05:18:00Z

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

github-actions · 2025-12-18T05:24:12Z

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

github-actions · 2025-12-18T17:08:05Z

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

github-actions · 2025-12-18T19:03:18Z

🧨 Preview deployments removed.

Previously we used go-ora (a pure Go Oracle driver) because our release pipeline did not support cross-compilation with CGO. Now that it's fixed, we want to add support for Oracle OCI driver for advanced features including digital wallet etc. Users will be able to configure a source to use OCI by specifying a `UseOCI: true` field. The source defaults to use the pure Go driver otherwise. Oracle Wallet: - OCI users should use the `tnsAdmin` to set the wallet location - Non-OCI users can should use the `walletLocation` field. fix: #1779 8ea39ec

…leapis#1945) Previously we used go-ora (a pure Go Oracle driver) because our release pipeline did not support cross-compilation with CGO. Now that it's fixed, we want to add support for Oracle OCI driver for advanced features including digital wallet etc. Users will be able to configure a source to use OCI by specifying a `UseOCI: true` field. The source defaults to use the pure Go driver otherwise. Oracle Wallet: - OCI users should use the `tnsAdmin` to set the wallet location - Non-OCI users can should use the `walletLocation` field. fix: googleapis#1779 8ea39ec

🤖 I have created a release *beep* *boop* --- ## [0.24.0](v0.23.0...v0.24.0) (2025-12-19) ### Features * **sources/cloud-gemini-data-analytics:** Add the Gemini Data Analytics (GDA) integration for DB NL2SQL conversion to Toolbox ([#2181](#2181)) ([aa270b2](aa270b2)) * **source/cloudsqlmysql:** Add support for IAM authentication in Cloud SQL MySQL source ([#2050](#2050)) ([af3d3c5](af3d3c5)) * **sources/oracle:** Add Oracle OCI and Wallet support ([#1945](#1945)) ([8ea39ec](8ea39ec)) * Support combining prebuilt and custom tool configurations ([#2188](#2188)) ([5788605](5788605)) * **tools/mysql-get-query-plan:** Add new `mysql-get-query-plan` tool for MySQL source ([#2123](#2123)) ([0641da0](0641da0)) ### Bug Fixes * **spanner:** Move list graphs validation to runtime ([#2154](#2154)) ([914b3ee](914b3ee)) --- 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.24.0](v0.23.0...v0.24.0) (2025-12-19) ### Features * **sources/cloud-gemini-data-analytics:** Add the Gemini Data Analytics (GDA) integration for DB NL2SQL conversion to Toolbox ([#2181](#2181)) ([aa270b2](aa270b2)) * **source/cloudsqlmysql:** Add support for IAM authentication in Cloud SQL MySQL source ([#2050](#2050)) ([af3d3c5](af3d3c5)) * **sources/oracle:** Add Oracle OCI and Wallet support ([#1945](#1945)) ([8ea39ec](8ea39ec)) * Support combining prebuilt and custom tool configurations ([#2188](#2188)) ([5788605](5788605)) * **tools/mysql-get-query-plan:** Add new `mysql-get-query-plan` tool for MySQL source ([#2123](#2123)) ([0641da0](0641da0)) ### Bug Fixes * **spanner:** Move list graphs validation to runtime ([#2154](#2154)) ([914b3ee](914b3ee)) --- 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> f520b4e

🤖 I have created a release *beep* *boop* --- ## [0.24.0](googleapis/mcp-toolbox@v0.23.0...v0.24.0) (2025-12-19) ### Features * **sources/cloud-gemini-data-analytics:** Add the Gemini Data Analytics (GDA) integration for DB NL2SQL conversion to Toolbox ([googleapis#2181](googleapis#2181)) ([aa270b2](googleapis@aa270b2)) * **source/cloudsqlmysql:** Add support for IAM authentication in Cloud SQL MySQL source ([googleapis#2050](googleapis#2050)) ([af3d3c5](googleapis@af3d3c5)) * **sources/oracle:** Add Oracle OCI and Wallet support ([googleapis#1945](googleapis#1945)) ([8ea39ec](googleapis@8ea39ec)) * Support combining prebuilt and custom tool configurations ([googleapis#2188](googleapis#2188)) ([5788605](googleapis@5788605)) * **tools/mysql-get-query-plan:** Add new `mysql-get-query-plan` tool for MySQL source ([googleapis#2123](googleapis#2123)) ([0641da0](googleapis@0641da0)) ### Bug Fixes * **spanner:** Move list graphs validation to runtime ([googleapis#2154](googleapis#2154)) ([914b3ee](googleapis@914b3ee)) --- 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> f520b4e

…leapis#1945) Previously we used go-ora (a pure Go Oracle driver) because our release pipeline did not support cross-compilation with CGO. Now that it's fixed, we want to add support for Oracle OCI driver for advanced features including digital wallet etc. Users will be able to configure a source to use OCI by specifying a `UseOCI: true` field. The source defaults to use the pure Go driver otherwise. Oracle Wallet: - OCI users should use the `tnsAdmin` to set the wallet location - Non-OCI users can should use the `walletLocation` field. fix: googleapis#1779 8ea39ec

🤖 I have created a release *beep* *boop* --- ## [0.24.0](googleapis/mcp-toolbox@v0.23.0...v0.24.0) (2025-12-19) ### Features * **sources/cloud-gemini-data-analytics:** Add the Gemini Data Analytics (GDA) integration for DB NL2SQL conversion to Toolbox ([googleapis#2181](googleapis#2181)) ([aa270b2](googleapis@aa270b2)) * **source/cloudsqlmysql:** Add support for IAM authentication in Cloud SQL MySQL source ([googleapis#2050](googleapis#2050)) ([af3d3c5](googleapis@af3d3c5)) * **sources/oracle:** Add Oracle OCI and Wallet support ([googleapis#1945](googleapis#1945)) ([8ea39ec](googleapis@8ea39ec)) * Support combining prebuilt and custom tool configurations ([googleapis#2188](googleapis#2188)) ([5788605](googleapis@5788605)) * **tools/mysql-get-query-plan:** Add new `mysql-get-query-plan` tool for MySQL source ([googleapis#2123](googleapis#2123)) ([0641da0](googleapis@0641da0)) ### Bug Fixes * **spanner:** Move list graphs validation to runtime ([googleapis#2154](googleapis#2154)) ([914b3ee](googleapis@914b3ee)) --- 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> f520b4e

) Previously we used go-ora (a pure Go Oracle driver) because our release pipeline did not support cross-compilation with CGO. Now that it's fixed, we want to add support for Oracle OCI driver for advanced features including digital wallet etc. Users will be able to configure a source to use OCI by specifying a `UseOCI: true` field. The source defaults to use the pure Go driver otherwise. Oracle Wallet: - OCI users should use the `tnsAdmin` to set the wallet location - Non-OCI users can should use the `walletLocation` field. fix: googleapis#1779

🤖 I have created a release *beep* *boop* --- ## [0.24.0](googleapis/mcp-toolbox@v0.23.0...v0.24.0) (2025-12-19) ### Features * **sources/cloud-gemini-data-analytics:** Add the Gemini Data Analytics (GDA) integration for DB NL2SQL conversion to Toolbox ([googleapis#2181](googleapis#2181)) ([aa270b2](googleapis@aa270b2)) * **source/cloudsqlmysql:** Add support for IAM authentication in Cloud SQL MySQL source ([googleapis#2050](googleapis#2050)) ([af3d3c5](googleapis@af3d3c5)) * **sources/oracle:** Add Oracle OCI and Wallet support ([googleapis#1945](googleapis#1945)) ([8ea39ec](googleapis@8ea39ec)) * Support combining prebuilt and custom tool configurations ([googleapis#2188](googleapis#2188)) ([5788605](googleapis@5788605)) * **tools/mysql-get-query-plan:** Add new `mysql-get-query-plan` tool for MySQL source ([googleapis#2123](googleapis#2123)) ([0641da0](googleapis@0641da0)) ### Bug Fixes * **spanner:** Move list graphs validation to runtime ([googleapis#2154](googleapis#2154)) ([914b3ee](googleapis@914b3ee)) --- 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.24.0](googleapis/mcp-toolbox@v0.23.0...v0.24.0) (2025-12-19) ### Features * **sources/cloud-gemini-data-analytics:** Add the Gemini Data Analytics (GDA) integration for DB NL2SQL conversion to Toolbox ([#2181](googleapis/mcp-toolbox#2181)) ([aa270b2](googleapis/mcp-toolbox@aa270b2)) * **source/cloudsqlmysql:** Add support for IAM authentication in Cloud SQL MySQL source ([#2050](googleapis/mcp-toolbox#2050)) ([af3d3c5](googleapis/mcp-toolbox@af3d3c5)) * **sources/oracle:** Add Oracle OCI and Wallet support ([#1945](googleapis/mcp-toolbox#1945)) ([8ea39ec](googleapis/mcp-toolbox@8ea39ec)) * Support combining prebuilt and custom tool configurations ([#2188](googleapis/mcp-toolbox#2188)) ([5788605](googleapis/mcp-toolbox@5788605)) * **tools/mysql-get-query-plan:** Add new `mysql-get-query-plan` tool for MySQL source ([#2123](googleapis/mcp-toolbox#2123)) ([0641da0](googleapis/mcp-toolbox@0641da0)) ### Bug Fixes * **spanner:** Move list graphs validation to runtime ([#2154](googleapis/mcp-toolbox#2154)) ([914b3ee](googleapis/mcp-toolbox@914b3ee)) --- 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 a review from a team November 13, 2025 16:07

blunderbuss-gcf Bot assigned averikitsch Nov 13, 2025

duwenxin99 changed the base branch from main to cross-comp November 13, 2025 16:07

duwenxin99 force-pushed the oracle-oic branch from aa32a69 to 7e85bfa Compare November 13, 2025 17:36

duwenxin99 changed the title ~~feat(sources/oracle): Add Oracle OIC support~~ feat(sources/oracle): Add Oracle OCI support Nov 13, 2025

averikitsch reviewed Nov 14, 2025

View reviewed changes

Comment thread internal/sources/oracle/oracle.go

averikitsch reviewed Nov 17, 2025

View reviewed changes

Comment thread .ci/integration.cloudbuild.yaml Outdated

averikitsch reviewed Nov 17, 2025

View reviewed changes

Comment thread docs/en/resources/sources/oracle.md

averikitsch reviewed Nov 17, 2025

View reviewed changes

Comment thread internal/sources/oracle/oracle.go

averikitsch reviewed Nov 17, 2025

View reviewed changes

Comment thread internal/tools/oracle/oracleexecutesql/oracleexecutesql.go

duwenxin99 force-pushed the cross-comp branch from da1b4e7 to 322a87d Compare November 24, 2025 01:26

Base automatically changed from cross-comp to main November 24, 2025 04:34

duwenxin99 force-pushed the oracle-oic branch from 1c76ef3 to 8df5463 Compare December 4, 2025 23:56

duwenxin99 force-pushed the oracle-oic branch from 2511d67 to d4597b3 Compare December 9, 2025 19:32

averikitsch approved these changes Dec 12, 2025

View reviewed changes

averikitsch reviewed Dec 12, 2025

View reviewed changes

Comment thread .ci/versioned.release.cloudbuild.yaml Outdated

duwenxin99 added 2 commits December 17, 2025 17:01

update all

44755d1

update dockerfile

b479212

update coverage check for oracle

cbe0c00

update coverage check for oracle

a2a10ed

duwenxin99 and others added 3 commits December 18, 2025 11:35

update coverage check for oracle

4c3b0bd

reduce coverage

b87a241

Merge branch 'main' into oracle-oic

47d8987

duwenxin99 added 2 commits December 18, 2025 12:57

Merge branch 'main' into oracle-oic

d528f28

Merge branch 'main' into oracle-oic

e2208c8

duwenxin99 merged commit 8ea39ec into main Dec 18, 2025
11 of 12 checks passed

duwenxin99 deleted the oracle-oic branch December 18, 2025 19:02

release-please Bot mentioned this pull request Dec 18, 2025

chore(main): release 0.24.0 #2162

Merged

BrewTestBot mentioned this pull request Dec 19, 2025

mcp-toolbox 0.24.0 Homebrew/homebrew-core#259301

Merged

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

github-actions Bot mentioned this pull request Mar 12, 2026

chore(main): release 0.29.0 #2608

Merged

Conversation

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

Uh oh!

Uh oh!

github-actions Bot commented Nov 13, 2025

Uh oh!

averikitsch left a comment

Choose a reason for hiding this comment

Uh oh!

Uh oh!

github-actions Bot commented Nov 14, 2025

Uh oh!

github-actions Bot commented Nov 14, 2025

Uh oh!

github-actions Bot commented Nov 14, 2025

Uh oh!

duwenxin99 commented Nov 14, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

github-actions Bot commented Nov 14, 2025

Uh oh!

github-actions Bot commented Nov 15, 2025

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

github-actions Bot commented Dec 5, 2025

Uh oh!

github-actions Bot commented Dec 9, 2025

Uh oh!

github-actions Bot commented Dec 9, 2025

Uh oh!

github-actions Bot commented Dec 9, 2025

Uh oh!

Uh oh!

github-actions Bot commented Dec 17, 2025

Uh oh!

github-actions Bot commented Dec 18, 2025

Uh oh!

github-actions Bot commented Dec 18, 2025

Uh oh!

github-actions Bot commented Dec 18, 2025

Uh oh!

github-actions Bot commented Dec 18, 2025

Uh oh!

Uh oh!

github-actions Bot commented Dec 18, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

duwenxin99 commented Nov 13, 2025 •

edited

Loading

duwenxin99 commented Nov 14, 2025 •

edited

Loading