feat(tool/Postgresql): Set default host and port for Postgresql source#1927
Merged
Conversation
averikitsch
requested changes
Nov 11, 2025
averikitsch
approved these changes
Nov 11, 2025
Contributor
|
/gcbrun |
Contributor
|
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! |
Contributor
|
Update the description as per changes. |
Contributor
|
FAIL: TestPostgres/invoke_list_active_queries_when_1_ongoing_query_should_show_up (5.06s) in integration tests. Please fix. |
Contributor
Author
|
Contributor
Author
|
Contributor
Author
|
averikitsch
approved these changes
Nov 12, 2025
Contributor
|
/gcbrun |
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>
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
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
host: ${POSTGRES_HOST:localhost}andport: ${POSTGRES_PORT:5432}. This allows the configuration loader to directly use"localhost"or"5432"as a fallback if thePOSTGRES_HOSTorPOSTGRES_PORTenvironment 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:
CONTRIBUTING.md
bug/issue
before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
🛠️ Fixes #41