Skip to content

feat(tool/Postgresql): Set default host and port for Postgresql source#1927

Merged
averikitsch merged 7 commits into
googleapis:mainfrom
Sathwikshetty16:postgres-test
Nov 12, 2025
Merged

feat(tool/Postgresql): Set default host and port for Postgresql source#1927
averikitsch merged 7 commits into
googleapis:mainfrom
Sathwikshetty16:postgres-test

Conversation

@Sathwikshetty16

@Sathwikshetty16 Sathwikshetty16 commented Nov 11, 2025

Copy link
Copy Markdown
Contributor

Description

This pull request addresses issue #41.by implementing default connection values for the Postgresql data source. When a user does not specify a host or port, the connection will now automatically default to localhost:5432.


Detailed Changes

  • docs/en/reference/prebuilt-tools.md
    -updated the env variables host and port to optional in the doc

  • internal/prebuiltconfigs/tools/postgres.yaml

    • Added the default values to host and port. Specifically, they are now host: ${POSTGRES_HOST:localhost} and port: ${POSTGRES_PORT:5432}. This allows the configuration loader to directly use "localhost" or "5432" as a fallback if the POSTGRES_HOST or POSTGRES_PORT environment variables are not set.

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 #41

Comment thread internal/sources/postgres/postgres.go Outdated
@averikitsch averikitsch added the tests: run Label to trigger Github Action tests. label Nov 11, 2025
@averikitsch

Copy link
Copy Markdown
Contributor

/gcbrun

@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Nov 11, 2025
@averikitsch

Copy link
Copy Markdown
Contributor

@prernakakkar-google

Copy link
Copy Markdown
Contributor

Update the description as per changes.

@prernakakkar-google

Copy link
Copy Markdown
Contributor

FAIL: TestPostgres/invoke_list_active_queries_when_1_ongoing_query_should_show_up (5.06s) in integration tests. Please fix.

@Sathwikshetty16

Copy link
Copy Markdown
Contributor Author

Can you update

https://github.com/googleapis/genai-toolbox/blob/cd56ea44fbdd149fcb92324e70ee36ac747635db/docs/en/reference/prebuilt-tools.md?plain=1#L492-L493

to mark these env vars as optional? Thanks!

i have updated in the doc

@Sathwikshetty16

Sathwikshetty16 commented Nov 12, 2025

Copy link
Copy Markdown
Contributor Author

Updated the description as per changes.

@Sathwikshetty16 Sathwikshetty16 added the tests: run Label to trigger Github Action tests. label Nov 12, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Nov 12, 2025
@Sathwikshetty16

Copy link
Copy Markdown
Contributor Author

FAIL: TestPostgres/invoke_list_active_queries_when_1_ongoing_query_should_show_up (5.06s) in integration tests. Please fix.

fixed the test now

@averikitsch averikitsch enabled auto-merge (squash) November 12, 2025 18:09
@averikitsch

Copy link
Copy Markdown
Contributor

/gcbrun

@averikitsch averikitsch added the tests: run Label to trigger Github Action tests. label Nov 12, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Nov 12, 2025
@averikitsch averikitsch merged commit 7e6e88a into googleapis:main Nov 12, 2025
15 checks passed
github-actions Bot pushed a commit that referenced this pull request Nov 12, 2025
…ql source (#1927)

### Description

This pull request addresses issue #41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** #41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com> 7e6e88a
github-actions Bot pushed a commit that referenced this pull request Nov 12, 2025
…ql source (#1927)

### Description

This pull request addresses issue #41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** #41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com> 7e6e88a
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Nov 12, 2025
…ql source (googleapis#1927)

### Description

This pull request addresses issue googleapis#41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** googleapis#41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com> 7e6e88a
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Nov 12, 2025
…ql source (googleapis#1927)

### Description

This pull request addresses issue googleapis#41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** googleapis#41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com> 7e6e88a
github-actions Bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Nov 13, 2025
…ql source (googleapis#1927)

### Description

This pull request addresses issue #41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** #41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com> 7e6e88a
github-actions Bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Nov 13, 2025
…ql source (googleapis#1927)

### Description

This pull request addresses issue #41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** #41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com> 7e6e88a
Yuan325 added a commit that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.20.0](v0.19.1...v0.20.0)
(2025-11-14)


### Features

* Added prompt support for toolbox
([#1798](#1798))
([cd56ea4](cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([#1588](#1588))
([12bdd95](12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([#1922](#1922))
([2c228ef](2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([#1927](#1927))
([7e6e88a](7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([#1877](#1877))
([ef63860](ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([#1912](#1912))
([a4c9287](a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([#1765](#1765))
([897c63d](897c63d))

---
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>
github-actions Bot pushed a commit that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([#1798](#1798))
([cd56ea4](cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([#1588](#1588))
([12bdd95](12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([#1922](#1922))
([2c228ef](2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([#1927](#1927))
([7e6e88a](7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([#1877](#1877))
([ef63860](ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([#1912](#1912))
([a4c9287](a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([#1765](#1765))
([897c63d](897c63d))

---
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> 5156db2
github-actions Bot pushed a commit that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([#1798](#1798))
([cd56ea4](cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([#1588](#1588))
([12bdd95](12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([#1922](#1922))
([2c228ef](2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([#1927](#1927))
([7e6e88a](7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([#1877](#1877))
([ef63860](ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([#1912](#1912))
([a4c9287](a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([#1765](#1765))
([897c63d](897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to CrazyForks/genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to CrazyForks/genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
github-actions Bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Nov 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)

### Features

* Added prompt support for toolbox
([googleapis#1798](googleapis#1798))
([cd56ea4](googleapis@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([googleapis#1588](googleapis#1588))
([12bdd95](googleapis@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([googleapis#1922](googleapis#1922))
([2c228ef](googleapis@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([googleapis#1927](googleapis#1927))
([7e6e88a](googleapis@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([googleapis#1877](googleapis#1877))
([ef63860](googleapis@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([googleapis#1912](googleapis#1912))
([a4c9287](googleapis@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([googleapis#1765](googleapis#1765))
([897c63d](googleapis@897c63d))

---
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> 5156db2
rahulpinto19 pushed a commit that referenced this pull request Nov 18, 2025
#1927)

### Description

This pull request addresses issue #41 by implementing default connection
values for the Postgresql data source. When a user does not specify a
host or port, the connection will now automatically default to
`localhost:5432`.

---

### Detailed Changes

- **docs/en/reference/prebuilt-tools.md**
   -updated the env variables host and port to optional in the doc

- **internal/prebuiltconfigs/tools/postgres.yaml**
- Added the default values to host and port. Specifically, they are now
`host: ${POSTGRES_HOST:localhost}` and `port: ${POSTGRES_PORT:5432}`.
This allows the configuration loader to directly use `"localhost"` or
`"5432"` as a fallback if the `POSTGRES_HOST` or `POSTGRES_PORT`
environment variables are not set.

---

### 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** #41

---------

Co-authored-by: Averi Kitsch <akitsch@google.com>
rahulpinto19 pushed a commit that referenced this pull request Nov 18, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.20.0](v0.19.1...v0.20.0)
(2025-11-14)


### Features

* Added prompt support for toolbox
([#1798](#1798))
([cd56ea4](cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([#1588](#1588))
([12bdd95](12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([#1922](#1922))
([2c228ef](2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([#1927](#1927))
([7e6e88a](7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([#1877](#1877))
([ef63860](ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([#1912](#1912))
([a4c9287](a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([#1765](#1765))
([897c63d](897c63d))

---
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>
NightStack15 added a commit to NightStack15/googleapis-_-genai-toolbox that referenced this pull request Mar 20, 2026
🤖 I have created a release *beep* *boop*
---


##
[0.20.0](googleapis/mcp-toolbox@v0.19.1...v0.20.0)
(2025-11-14)


### Features

* Added prompt support for toolbox
([#1798](googleapis/mcp-toolbox#1798))
([cd56ea4](googleapis/mcp-toolbox@cd56ea4))
* **source/alloydb,
source/cloud-sql-postgres,source/cloud-sql-mysql,source/cloud-sql-mssql:**
Use project from env for alloydb and cloud sql control plane tools
([#1588](googleapis/mcp-toolbox#1588))
([12bdd95](googleapis/mcp-toolbox@12bdd95))
* **source/mysql:** Set default host and port for MySQL source
([#1922](googleapis/mcp-toolbox#1922))
([2c228ef](googleapis/mcp-toolbox@2c228ef))
* **source/Postgresql:** Set default host and port for Postgresql source
([#1927](googleapis/mcp-toolbox#1927))
([7e6e88a](googleapis/mcp-toolbox@7e6e88a))
* **tool/looker-generate-embed-url:** Adding generate embed url tool
([#1877](googleapis/mcp-toolbox#1877))
([ef63860](googleapis/mcp-toolbox@ef63860))
* **tools/postgres:** Add `list_triggers`, `database_overview` tools for
postgres
([#1912](googleapis/mcp-toolbox#1912))
([a4c9287](googleapis/mcp-toolbox@a4c9287))
* **tools/postgres:** Add list_indexes, list_sequences tools for
postgres
([#1765](googleapis/mcp-toolbox#1765))
([897c63d](googleapis/mcp-toolbox@897c63d))

---
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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants