feat(tool/cloudsqladmin): add `cloud-sql-admin-execute-sql-many` and `cloud-sql-admin-sql-many` by duwenxin99 · Pull Request #3083 · googleapis/mcp-toolbox

duwenxin99 · 2026-04-16T21:17:45Z

Add 2 new tools using the Cloud SQL Admin instances.executeSql API to enable SQL execution against instances provided at runtime:

cloud-sql-admin-execute-sql-many: Allows execution of arbitrary SQL statements on a specific database provided at runtime.
cloud-sql-admin-sql-many: Allows execution of prepared SQL statement on a specific instance provided at runtime.

gemini-code-assist

Code Review

This pull request introduces the postgres-execute-sql-many and postgres-sql-many tools and adds an ExecuteSql method to the Cloud SQL Admin source. Review feedback identifies several improvement opportunities, including the removal of the unused region parameter in both tools and the cleanup of the postgressqlmany configuration by removing the unsupported Parameters field and its associated runtime checks.

duwenxin99 · 2026-04-16T22:06:54Z

/gemini review

gemini-code-assist

Code Review

This pull request introduces the postgres-execute-sql-many and postgres-sql-many tools, enabling SQL execution on Cloud SQL Postgres instances provided at runtime. The changes encompass tool implementations, documentation, prebuilt configuration updates, and integration tests. Review feedback suggests appending " Tool" to the documentation titles for both tools to maintain consistency.

add prebuilt tool

Co-authored-by: Kurtis Van Gent <[email protected]>

Resolved comments.

github-actions · 2026-05-18T18:53:38Z

🧨 Preview deployments removed.

Cloudflare Pages environments for pr-3083 have been deleted.

…ny` and `cloud-sql-admin-sql-many` (#3083) Add 2 new tools using the Cloud SQL Admin `instances.executeSql` API to enable SQL execution against instances provided at runtime: - cloud-sql-admin-execute-sql-many: Allows execution of arbitrary SQL statements on a specific database provided at runtime. - cloud-sql-admin-sql-many: Allows execution of prepared SQL statement on a specific instance provided at runtime. --------- Co-authored-by: Kurtis Van Gent <[email protected]> ef300a8

…ny` and `cloud-sql-admin-sql-many` (googleapis#3083) Add 2 new tools using the Cloud SQL Admin `instances.executeSql` API to enable SQL execution against instances provided at runtime: - cloud-sql-admin-execute-sql-many: Allows execution of arbitrary SQL statements on a specific database provided at runtime. - cloud-sql-admin-sql-many: Allows execution of prepared SQL statement on a specific instance provided at runtime. --------- Co-authored-by: Kurtis Van Gent <[email protected]> ef300a8

…`cloud-sql-admin-sql-many` (googleapis#3083) Add 2 new tools using the Cloud SQL Admin `instances.executeSql` API to enable SQL execution against instances provided at runtime: - cloud-sql-admin-execute-sql-many: Allows execution of arbitrary SQL statements on a specific database provided at runtime. - cloud-sql-admin-sql-many: Allows execution of prepared SQL statement on a specific instance provided at runtime. --------- Co-authored-by: Kurtis Van Gent <[email protected]>

🤖 I have created a release *beep* *boop* --- ## [1.3.0](v1.2.0...v1.3.0) (2026-05-21) ### Features * **auth:** Implement MCP auth tool-level scopes validation ([#3049](#3049)) ([c528985](c528985)) * **looker:** Propagate client IP from incoming MCP requests to downstream SDK calls ([#3253](#3253)) ([75da6c2](75da6c2)) * Setup SQLCommenter and allow client metadata ([#3064](#3064)) ([9f1f9b3](9f1f9b3)) * **tool/cloudsqladmin:** Add `cloud-sql-admin-execute-sql-many` and `cloud-sql-admin-sql-many` ([#3083](#3083)) ([ef300a8](ef300a8)) ### Bug Fixes * **auth/generic:** Fix generic auth expiration field and integration with `authRequired` ([#3251](#3251)) ([f4d16c0](f4d16c0)) * Enforce toolset/promptset boundary on tools/call and prompts/get ([#3036](#3036)) ([c739b80](c739b80)) * **tools/http:** Prevent path traversal and base path scope escape ([#3218](#3218)) ([80a6602](80a6602)) * **tools/looker:** Return a 401 error to MCP client when Looker returns a 401 ([#3233](#3233)) ([4f409a3](4f409a3)) * **tools/looker:** Strip wrapping quotes from filter values for unquoted parameters ([#3273](#3273)) ([1e3de96](1e3de96)) * **tools:** Initialize query result slices to empty array ([#3250](#3250)) ([60ddf48](60ddf48)) --- 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 <[email protected]>

🤖 I have created a release *beep* *boop* --- ## [1.3.0](v1.2.0...v1.3.0) (2026-05-21) ### Features * **auth:** Implement MCP auth tool-level scopes validation ([#3049](#3049)) ([c528985](c528985)) * **looker:** Propagate client IP from incoming MCP requests to downstream SDK calls ([#3253](#3253)) ([75da6c2](75da6c2)) * Setup SQLCommenter and allow client metadata ([#3064](#3064)) ([9f1f9b3](9f1f9b3)) * **tool/cloudsqladmin:** Add `cloud-sql-admin-execute-sql-many` and `cloud-sql-admin-sql-many` ([#3083](#3083)) ([ef300a8](ef300a8)) ### Bug Fixes * **auth/generic:** Fix generic auth expiration field and integration with `authRequired` ([#3251](#3251)) ([f4d16c0](f4d16c0)) * Enforce toolset/promptset boundary on tools/call and prompts/get ([#3036](#3036)) ([c739b80](c739b80)) * **tools/http:** Prevent path traversal and base path scope escape ([#3218](#3218)) ([80a6602](80a6602)) * **tools/looker:** Return a 401 error to MCP client when Looker returns a 401 ([#3233](#3233)) ([4f409a3](4f409a3)) * **tools/looker:** Strip wrapping quotes from filter values for unquoted parameters ([#3273](#3273)) ([1e3de96](1e3de96)) * **tools:** Initialize query result slices to empty array ([#3250](#3250)) ([60ddf48](60ddf48)) --- 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 <[email protected]> b001006

🤖 I have created a release *beep* *boop* --- ## [1.3.0](googleapis/mcp-toolbox@v1.2.0...v1.3.0) (2026-05-21) ### Features * **auth:** Implement MCP auth tool-level scopes validation ([googleapis#3049](googleapis#3049)) ([c528985](googleapis@c528985)) * **looker:** Propagate client IP from incoming MCP requests to downstream SDK calls ([googleapis#3253](googleapis#3253)) ([75da6c2](googleapis@75da6c2)) * Setup SQLCommenter and allow client metadata ([googleapis#3064](googleapis#3064)) ([9f1f9b3](googleapis@9f1f9b3)) * **tool/cloudsqladmin:** Add `cloud-sql-admin-execute-sql-many` and `cloud-sql-admin-sql-many` ([googleapis#3083](googleapis#3083)) ([ef300a8](googleapis@ef300a8)) ### Bug Fixes * **auth/generic:** Fix generic auth expiration field and integration with `authRequired` ([googleapis#3251](googleapis#3251)) ([f4d16c0](googleapis@f4d16c0)) * Enforce toolset/promptset boundary on tools/call and prompts/get ([googleapis#3036](googleapis#3036)) ([c739b80](googleapis@c739b80)) * **tools/http:** Prevent path traversal and base path scope escape ([googleapis#3218](googleapis#3218)) ([80a6602](googleapis@80a6602)) * **tools/looker:** Return a 401 error to MCP client when Looker returns a 401 ([googleapis#3233](googleapis#3233)) ([4f409a3](googleapis@4f409a3)) * **tools/looker:** Strip wrapping quotes from filter values for unquoted parameters ([googleapis#3273](googleapis#3273)) ([1e3de96](googleapis@1e3de96)) * **tools:** Initialize query result slices to empty array ([googleapis#3250](googleapis#3250)) ([60ddf48](googleapis@60ddf48)) --- 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 <[email protected]> b001006

duwenxin99 requested a review from a team as a code owner April 16, 2026 21:17

blunderbuss-gcf Bot assigned Yuan325 Apr 16, 2026

gemini-code-assist Bot reviewed Apr 16, 2026

View reviewed changes

Comment thread docs/en/integrations/postgres/tools/postgres-execute-sql-many.md Outdated

Comment thread docs/en/integrations/postgres/tools/postgres-sql-many.md Outdated

averikitsch self-assigned this Apr 16, 2026

duwenxin99 unassigned Yuan325 Apr 20, 2026

duwenxin99 force-pushed the generic-execute-sql branch from 7f7c7bd to f3d09a4 Compare April 20, 2026 20:16

averikitsch reviewed Apr 23, 2026

View reviewed changes

Comment thread internal/prebuiltconfigs/tools/cloud-sql-postgres-admin.yaml

Comment thread internal/tools/cloudsqladmin/cloudsqladminexecutemany/cloudsqladminexecutemany.go

duwenxin99 added 7 commits May 14, 2026 14:36

add initial tools

4428afd

add docs

68d95e2

add test

6c0eb62

commit

1a17f82

add prebuilt tool

resolve comments

ada1f60

fix lint

f6b9e8e

fix test

8c86358

duwenxin99 force-pushed the generic-execute-sql branch from f3d09a4 to 8c86358 Compare May 14, 2026 18:42

resolve comments

d7de0a8

duwenxin99 requested a review from a team as a code owner May 14, 2026 18:47

kurtisvg previously requested changes May 14, 2026

View reviewed changes

rename and move dir

035e992

duwenxin99 changed the title ~~feat(tool/postgres): add postgres-execute-sql-many and postgres-sql-many~~ feat(tool/cloudsqladmin): add clouds-sql-admin-execute-sql-many and clouds-sql-admin-sql-many May 14, 2026

duwenxin99 changed the title ~~feat(tool/cloudsqladmin): add clouds-sql-admin-execute-sql-many and clouds-sql-admin-sql-many~~ feat(tool/cloudsqladmin): add cloud-sql-admin-execute-sql-many and cloud-sql-admin-sql-many May 14, 2026

duwenxin99 and others added 7 commits May 15, 2026 15:27

Update internal/sources/cloudsqladmin/cloud_sql_admin.go

4a8768f

Co-authored-by: Kurtis Van Gent <[email protected]>

update instance ID

194dbb2

update error log

0f1630d

rebase

624470d

rebase

259b2dd

Merge branch 'main' into generic-execute-sql

d329f55

update integration test

4355059

Yuan325 approved these changes May 15, 2026

View reviewed changes

Comment thread docs/en/integrations/cloud-sql-admin/tools/cloudsqladminsqlmany.md

Comment thread tests/cloudsql/cloud_sql_execute_sql_test.go

duwenxin99 and others added 3 commits May 18, 2026 13:45

Merge branch 'main' into generic-execute-sql

8895a15

resolve comments

bea3d9e

lint

a22152c

duwenxin99 enabled auto-merge (squash) May 18, 2026 17:52

duwenxin99 and others added 2 commits May 18, 2026 14:38

lint

b03f05e

Merge branch 'main' into generic-execute-sql

9d83e09

duwenxin99 merged commit ef300a8 into main May 18, 2026
26 of 27 checks passed

duwenxin99 deleted the generic-execute-sql branch May 18, 2026 18:53

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

chore(main): release 1.3.0 #3228

Merged

BrewTestBot mentioned this pull request May 21, 2026

mcp-toolbox 1.3.0 Homebrew/homebrew-core#284130

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

feat(tool/cloudsqladmin): add `cloud-sql-admin-execute-sql-many` and `cloud-sql-admin-sql-many`#3083

feat(tool/cloudsqladmin): add `cloud-sql-admin-execute-sql-many` and `cloud-sql-admin-sql-many`#3083
duwenxin99 merged 21 commits into
mainfrom
generic-execute-sql

duwenxin99 commented Apr 16, 2026 •

edited

Loading

Uh oh!

gemini-code-assist Bot left a comment

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

duwenxin99 commented Apr 16, 2026

Uh oh!

gemini-code-assist Bot left a comment

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

github-actions Bot commented May 18, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

4 participants

Conversation

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

Uh oh!

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!

duwenxin99 commented Apr 16, 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!

Uh oh!

Uh oh!

github-actions Bot commented May 18, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

4 participants

duwenxin99 commented Apr 16, 2026 •

edited

Loading