Skip to content

feat: add postgres-execute-sql tool - #490

Merged
Yuan325 merged 5 commits into
mainfrom
execute-sql
May 1, 2025
Merged

feat: add postgres-execute-sql tool#490
Yuan325 merged 5 commits into
mainfrom
execute-sql

Conversation

@Yuan325

@Yuan325 Yuan325 commented Apr 25, 2025 •
edited
Loading

Copy link
Copy Markdown
Contributor

This tool can be used across all postgres sources.

postgres-execute-sql config is as below:

tools:
  postgres_execute_sql_tool:
    kind: "postgres-execute-sql"
    source: my-alloydb-source // or any other sources that is compatible with this tool
    description: Use this tool to execute sql.

The postgres-execute-sql tool takes one parameter. Example request as follow:

curl -X POST -H "Content-Type: application/json" -d '{"sql": "SELECT 1"}' http://127.0.0.1:5000/api/tool/postgres_execute_sql_tool/invoke

@Yuan325
Yuan325 requested a review from a team April 25, 2025 21:26
@Yuan325
Yuan325 marked this pull request as draft April 25, 2025 21:26
kurtisvg
kurtisvg reviewed Apr 25, 2025
View reviewed changes
Comment thread internal/tools/executesql/executesql.go Outdated
@Yuan325
Yuan325 requested a review from kurtisvg April 25, 2025 23:11
@Yuan325
Yuan325 marked this pull request as ready for review April 25, 2025 23:11
@Yuan325 Yuan325 changed the title feat: add execute-sql tool feat: add pg-execute-sql tool Apr 25, 2025
@Yuan325 Yuan325 changed the title feat: add pg-execute-sql tool feat: add postgres-execute-sql tool Apr 25, 2025
@github-actions

github-actions Bot commented Apr 25, 2025

Copy link
Copy Markdown
Contributor

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

1 similar comment
@github-actions

github-actions Bot commented Apr 25, 2025

Copy link
Copy Markdown
Contributor

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

averikitsch
averikitsch reviewed Apr 29, 2025
View reviewed changes
Comment thread docs/en/resources/tools/postgres-execute-sql.md Outdated
averikitsch
averikitsch reviewed Apr 29, 2025
View reviewed changes
Comment thread docs/en/resources/tools/postgres-execute-sql.md
averikitsch
averikitsch reviewed Apr 29, 2025
View reviewed changes
Comment thread docs/en/resources/tools/postgres-execute-sql.md Outdated
averikitsch
averikitsch reviewed Apr 29, 2025
View reviewed changes
Comment thread internal/tools/postgresexecutesql/postgresexecutesql.go
averikitsch
averikitsch reviewed Apr 29, 2025
View reviewed changes
Comment thread internal/tools/postgresexecutesql/postgresexecutesql.go
@github-actions

github-actions Bot commented Apr 30, 2025

Copy link
Copy Markdown
Contributor

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

@Yuan325
Yuan325 requested a review from averikitsch April 30, 2025 21:04
averikitsch
averikitsch reviewed Apr 30, 2025
View reviewed changes
Comment thread internal/tools/postgresexecutesql/postgresexecutesql.go Outdated
averikitsch
averikitsch reviewed Apr 30, 2025
View reviewed changes
Comment thread internal/tools/postgresexecutesql/postgresexecutesql.go
@Yuan325
Yuan325 enabled auto-merge (squash) May 1, 2025 17:40
@github-actions

github-actions Bot commented May 1, 2025

Copy link
Copy Markdown
Contributor

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

@Yuan325
Yuan325 merged commit 11ea7bc into main May 1, 2025
@Yuan325
Yuan325 deleted the execute-sql branch May 1, 2025 17:43
@github-actions

github-actions Bot commented May 1, 2025

Copy link
Copy Markdown
Contributor

🧨 Preview deployments removed.

github-actions Bot pushed a commit that referenced this pull request May 1, 2025
@Yuan325
deploy: feat: add postgres-execute-sql tool (#490)
b41dc30 
This tool can be used across all postgres sources.

`postgres-execute-sql` config is as below:

```
tools:
  postgres_execute_sql_tool:
    kind: "postgres-execute-sql"
    source: my-alloydb-source // or any other sources that is compatible with this tool
    description: Use this tool to execute sql.
```

The `postgres-execute-sql` tool takes one parameter. Example request as
follow:
```
curl -X POST -H "Content-Type: application/json" -d '{"sql": "SELECT 1"}' http://127.0.0.1:5000/api/tool/postgres_execute_sql_tool/invoke
``` 11ea7bc
@release-please release-please Bot mentioned this pull request May 1, 2025
Merged
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request May 1, 2025
@renovate-bot
deploy: feat: add postgres-execute-sql tool (googleapis#490)
f630762 
This tool can be used across all postgres sources.

`postgres-execute-sql` config is as below:

```
tools:
  postgres_execute_sql_tool:
    kind: "postgres-execute-sql"
    source: my-alloydb-source // or any other sources that is compatible with this tool
    description: Use this tool to execute sql.
```

The `postgres-execute-sql` tool takes one parameter. Example request as
follow:
```
curl -X POST -H "Content-Type: application/json" -d '{"sql": "SELECT 1"}' http://127.0.0.1:5000/api/tool/postgres_execute_sql_tool/invoke
``` 11ea7bc
Yuan325 added a commit that referenced this pull request May 6, 2025
@release-please @Yuan325
chore(main): release 0.5.0 (#484)
9a5d76e 
🤖 I have created a release *beep* *boop*
---


##
[0.5.0](v0.4.0...v0.5.0)
(2025-05-06)


### Features

* Add Couchbase as Source and Tool
([#307](#307))
([d7390b0](d7390b0))
* Add postgres-execute-sql tool
([#490](#490))
([11ea7bc](11ea7bc))


### Bug Fixes

* **deps:** Update module cloud.google.com/go/cloudsqlconn to v1.17.0
([#500](#500))
([ad040cf](ad040cf))
* **deps:** Update module cloud.google.com/go/spanner to v1.80.0
([#481](#481))
([1e1348f](1e1348f))
* **deps:** Update module google.golang.org/api to v0.231.0
([#505](#505))
([50ec7f4](50ec7f4))

---
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 <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <yuanteoh@google.com>
github-actions Bot pushed a commit that referenced this pull request May 6, 2025
@Yuan325 @release-please
deploy: chore(main): release 0.5.0 (#484)
7795c94 
🤖 I have created a release *beep* *boop*
---

##
[0.5.0](v0.4.0...v0.5.0)
(2025-05-06)

### Features

* Add Couchbase as Source and Tool
([#307](#307))
([d7390b0](d7390b0))
* Add postgres-execute-sql tool
([#490](#490))
([11ea7bc](11ea7bc))

### Bug Fixes

* **deps:** Update module cloud.google.com/go/cloudsqlconn to v1.17.0
([#500](#500))
([ad040cf](ad040cf))
* **deps:** Update module cloud.google.com/go/spanner to v1.80.0
([#481](#481))
([1e1348f](1e1348f))
* **deps:** Update module google.golang.org/api to v0.231.0
([#505](#505))
([50ec7f4](50ec7f4))

---
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 <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <yuanteoh@google.com> 9a5d76e
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request May 6, 2025
@renovate-bot @release-please @Yuan325
deploy: chore(main): release 0.5.0 (googleapis#484)
705d8bd 
🤖 I have created a release *beep* *boop*
---

##
[0.5.0](googleapis/mcp-toolbox@v0.4.0...v0.5.0)
(2025-05-06)

### Features

* Add Couchbase as Source and Tool
([googleapis#307](googleapis#307))
([d7390b0](googleapis@d7390b0))
* Add postgres-execute-sql tool
([googleapis#490](googleapis#490))
([11ea7bc](googleapis@11ea7bc))

### Bug Fixes

* **deps:** Update module cloud.google.com/go/cloudsqlconn to v1.17.0
([googleapis#500](googleapis#500))
([ad040cf](googleapis@ad040cf))
* **deps:** Update module cloud.google.com/go/spanner to v1.80.0
([googleapis#481](googleapis#481))
([1e1348f](googleapis@1e1348f))
* **deps:** Update module google.golang.org/api to v0.231.0
([googleapis#505](googleapis#505))
([50ec7f4](googleapis@50ec7f4))

---
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 <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <yuanteoh@google.com> 9a5d76e
jeffreyrubi pushed a commit to jeffreyrubi/genai-toolbox that referenced this pull request Jun 7, 2025
@Yuan325 @jeffreyrubi
feat: add postgres-execute-sql tool (googleapis#490)
be158b9 
This tool can be used across all postgres sources.

`postgres-execute-sql` config is as below:

```
tools:
  postgres_execute_sql_tool:
    kind: "postgres-execute-sql"
    source: my-alloydb-source // or any other sources that is compatible with this tool
    description: Use this tool to execute sql.
```

The `postgres-execute-sql` tool takes one parameter. Example request as
follow:
```
curl -X POST -H "Content-Type: application/json" -d '{"sql": "SELECT 1"}' http://127.0.0.1:5000/api/tool/postgres_execute_sql_tool/invoke
```
jeffreyrubi pushed a commit to jeffreyrubi/genai-toolbox that referenced this pull request Jun 7, 2025
@release-please @Yuan325 @jeffreyrubi
chore(main): release 0.5.0 (googleapis#484)
ea8c34d 
🤖 I have created a release *beep* *boop*
---


##
[0.5.0](googleapis/mcp-toolbox@v0.4.0...v0.5.0)
(2025-05-06)


### Features

* Add Couchbase as Source and Tool
([googleapis#307](googleapis#307))
([d7390b0](googleapis@d7390b0))
* Add postgres-execute-sql tool
([googleapis#490](googleapis#490))
([11ea7bc](googleapis@11ea7bc))


### Bug Fixes

* **deps:** Update module cloud.google.com/go/cloudsqlconn to v1.17.0
([googleapis#500](googleapis#500))
([ad040cf](googleapis@ad040cf))
* **deps:** Update module cloud.google.com/go/spanner to v1.80.0
([googleapis#481](googleapis#481))
([1e1348f](googleapis@1e1348f))
* **deps:** Update module google.golang.org/api to v0.231.0
([googleapis#505](googleapis#505))
([50ec7f4](googleapis@50ec7f4))

---
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 <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <yuanteoh@google.com>
This was referenced Feb 18, 2026
Closed
Closed
Open
Open
NightStack15 added a commit to NightStack15/googleapis-_-genai-toolbox that referenced this pull request Mar 20, 2026
@NightStack15 @release-please @Yuan325
chore(main): release 0.5.0 (#484)
75b041d 
🤖 I have created a release *beep* *boop*
---


##
[0.5.0](googleapis/mcp-toolbox@v0.4.0...v0.5.0)
(2025-05-06)


### Features

* Add Couchbase as Source and Tool
([#307](googleapis/mcp-toolbox#307))
([d7390b0](googleapis/mcp-toolbox@d7390b0))
* Add postgres-execute-sql tool
([#490](googleapis/mcp-toolbox#490))
([11ea7bc](googleapis/mcp-toolbox@11ea7bc))


### Bug Fixes

* **deps:** Update module cloud.google.com/go/cloudsqlconn to v1.17.0
([#500](googleapis/mcp-toolbox#500))
([ad040cf](googleapis/mcp-toolbox@ad040cf))
* **deps:** Update module cloud.google.com/go/spanner to v1.80.0
([#481](googleapis/mcp-toolbox#481))
([1e1348f](googleapis/mcp-toolbox@1e1348f))
* **deps:** Update module google.golang.org/api to v0.231.0
([#505](googleapis/mcp-toolbox#505))
([50ec7f4](googleapis/mcp-toolbox@50ec7f4))

---
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 <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <yuanteoh@google.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@averikitsch averikitsch averikitsch approved these changes
@kurtisvg kurtisvg Awaiting requested review from kurtisvg

Assignees

@kurtisvg kurtisvg

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

3 participants

@Yuan325 @averikitsch @kurtisvg