feat(tools/mysql-list-tables-missing-index): Add a new tool to list tables that do not have primary or unique keys in a MySQL instance#1493
Merged
averikitsch merged 7 commits intoSep 18, 2025
Conversation
averikitsch
reviewed
Sep 17, 2025
averikitsch
approved these changes
Sep 17, 2025
ffc2f67 to
94b8f7d
Compare
Contributor
|
/gcbrun |
2 tasks
Contributor
|
/gcbrun |
github-actions Bot
pushed a commit
that referenced
this pull request
Sep 18, 2025
…o list tables that do not have primary or unique keys in a MySQL instance (#1493) ## Description --- A `mysql-list-tables-missing-index` tool searches tables that do not have primary or unique indices in a MySQL database. It's compatible with: - cloud-sql-mysql - mysql `mysql-list-tables-missing-index` outputs table names, including `table_schema` and `table_name` in JSON format. It takes 2 optional input parameters: - `table_schema` (optional): Only check tables in this specific schema/database. Search all visible tables in all visible databases if not specified. - `limit` (optional): max number of queries to return, default `50`. ## Example ```yaml tools: list_tables_missing_index: kind: mysql-list-tables-missing-index source: my-mysql-instance description: Find tables that do not have primary or unique key constraint. A primary key or unique key is the only mechanism that guaranttes a row is unique. Without them, the database-level protection against data integrity issues will be missing. ``` The response is a json array with the following fields: ```json { "table_schema": "the schema/database this table belongs to", "table_name": "name of the table", } ``` ## Reference | **field** | **type** | **required** | **description** | |-------------|:------------------------------------------:|:------------:|--------------------------------------------------------------------------------------------------| | kind | string | true | Must be "mysql-list-active-queries". | | source | string | true | Name of the source the SQL should execute on. | | description | string | true | Description of the tool that is passed to the LLM. | ## 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: - [x] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [x] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [x] Ensure the tests and linter pass - [x] Code coverage does not decrease (if any source code was changed) - [x] Appropriate docs were updated (if necessary) - [x] Make sure to add `!` if this involve a breaking change --------- Co-authored-by: Averi Kitsch <akitsch@google.com> 9eb821a
Yuan325
added a commit
that referenced
this pull request
Sep 19, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([#1421](#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([#1449](#1449)) ### Features * Add AlloyDB admin source ([#1369](#1369)) ([33beb71](33beb71)) * Add Cloud monitoring source and tool ([#1311](#1311)) ([d661f53](d661f53)) * Add YugabyteDB Source and Tool ([#732](#732)) ([664711f](664711f)) * **prebuilt:** Update default values for prebuilt tools ([#1355](#1355)) ([70e832b](70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([#1310](#1310)) ([0171228](0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([#1453](#1453)) ([a1bc044](a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([#1383](#1383)) ([77919c7](77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([#1406](#1406)) ([3a6b517](3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([#1454](#1454)) ([e6a6c61](e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([#1455](#1455)) ([bf6266b](bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([#1440](#1440)) ([b176523](b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([#1434](#1434)) ([15b628d](15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([#1232](#1232)) ([#1347](#1347)) ([0cd3f16](0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([#1403](#1403)) ([d302499](d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([#1474](#1474)) ([1a42e05](1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([#1318](#1318)) ([4b32c2a](4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([#1352](#1352)) ([f819e26](f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([#1425](#1425)) ([236be89](236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([#1473](#1473)) ([edca9dc](edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([#1227](#1227)) ([681c2b4](681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([#1448](#1448)) ([9710014](9710014)) * **source/bigquery:** Add support for datasets selection ([#1313](#1313)) ([aa39724](aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([#1472](#1472)) ([92680b1](92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([#1441](#1441)) ([56b6574](56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([#1408](#1408)) ([4f46782](4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([#1306](#1306)) ([3aef2bb](3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([#1331](#1331)) ([76bb876](76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([#1379](#1379)) ([091cd9a](091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([#1380](#1380)) ([ab3fd26](ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([#1420](#1420)) ([c181dab](c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([#1435](#1435)) ([f2d9e3b](f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([#1436](#1436)) ([677254e](677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([#1319](#1319)) ([d4a9eb0](d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([#1357](#1357)) ([93c1b30](93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([#1377](#1377)) ([3a8a65c](3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([#1223](#1223)) ([81d239b](81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([#1411](#1411)) ([345bd6a](345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([#1382](#1382)) ([bffb39d](bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([#1431](#1431)) ([fe2999a](fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([#1274](#1274)) ([e515d92](e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([#1505](#1505)) ([7450482](7450482)) * **tools/firestore:** Add `firestore-query` tool ([#1305](#1305)) ([cce602f](cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([#1410](#1410)) ([2036c8e](2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([#1433](#1433)) ([b036047](b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([#1471](#1471)) ([ed54cd6](ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([#1479](#1479)) ([fe651d8](fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([#1493](#1493)) ([9eb821a](9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([#1287](#1287)) ([6c8460b](6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([#1400](#1400)) ([b2b06c7](b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([#1284](#1284)) ([71f360d](71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([#1404](#1404)) ([7d384dc](7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([#1386](#1386)) ([b5f9780](b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([#1494](#1494)) ([30f1d3a](30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([#1468](#1468)) ([6c140d7](6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([#1381](#1381)) ([80b7488](80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([#1439](#1439)) ([da24661](da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([#1428](#1428)) ([4babc4e](4babc4e)) --- 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
Sep 19, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([#1421](#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([#1449](#1449)) ### Features * Add AlloyDB admin source ([#1369](#1369)) ([33beb71](33beb71)) * Add Cloud monitoring source and tool ([#1311](#1311)) ([d661f53](d661f53)) * Add YugabyteDB Source and Tool ([#732](#732)) ([664711f](664711f)) * **prebuilt:** Update default values for prebuilt tools ([#1355](#1355)) ([70e832b](70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([#1310](#1310)) ([0171228](0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([#1453](#1453)) ([a1bc044](a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([#1383](#1383)) ([77919c7](77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([#1406](#1406)) ([3a6b517](3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([#1454](#1454)) ([e6a6c61](e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([#1455](#1455)) ([bf6266b](bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([#1440](#1440)) ([b176523](b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([#1434](#1434)) ([15b628d](15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([#1232](#1232)) ([#1347](#1347)) ([0cd3f16](0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([#1403](#1403)) ([d302499](d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([#1474](#1474)) ([1a42e05](1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([#1318](#1318)) ([4b32c2a](4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([#1352](#1352)) ([f819e26](f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([#1425](#1425)) ([236be89](236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([#1473](#1473)) ([edca9dc](edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([#1227](#1227)) ([681c2b4](681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([#1448](#1448)) ([9710014](9710014)) * **source/bigquery:** Add support for datasets selection ([#1313](#1313)) ([aa39724](aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([#1472](#1472)) ([92680b1](92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([#1441](#1441)) ([56b6574](56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([#1408](#1408)) ([4f46782](4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([#1306](#1306)) ([3aef2bb](3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([#1331](#1331)) ([76bb876](76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([#1379](#1379)) ([091cd9a](091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([#1380](#1380)) ([ab3fd26](ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([#1420](#1420)) ([c181dab](c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([#1435](#1435)) ([f2d9e3b](f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([#1436](#1436)) ([677254e](677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([#1319](#1319)) ([d4a9eb0](d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([#1357](#1357)) ([93c1b30](93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([#1377](#1377)) ([3a8a65c](3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([#1223](#1223)) ([81d239b](81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([#1411](#1411)) ([345bd6a](345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([#1382](#1382)) ([bffb39d](bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([#1431](#1431)) ([fe2999a](fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([#1274](#1274)) ([e515d92](e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([#1505](#1505)) ([7450482](7450482)) * **tools/firestore:** Add `firestore-query` tool ([#1305](#1305)) ([cce602f](cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([#1410](#1410)) ([2036c8e](2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([#1433](#1433)) ([b036047](b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([#1471](#1471)) ([ed54cd6](ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([#1479](#1479)) ([fe651d8](fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([#1493](#1493)) ([9eb821a](9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([#1287](#1287)) ([6c8460b](6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([#1400](#1400)) ([b2b06c7](b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([#1284](#1284)) ([71f360d](71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([#1404](#1404)) ([7d384dc](7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([#1386](#1386)) ([b5f9780](b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([#1494](#1494)) ([30f1d3a](30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([#1468](#1468)) ([6c140d7](6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([#1381](#1381)) ([80b7488](80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([#1439](#1439)) ([da24661](da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([#1428](#1428)) ([4babc4e](4babc4e)) --- 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> c934d7a
github-actions Bot
pushed a commit
to renovate-bot/googleapis-_-genai-toolbox
that referenced
this pull request
Sep 19, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](googleapis/mcp-toolbox@v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([googleapis#1421](googleapis#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([googleapis#1449](googleapis#1449)) ### Features * Add AlloyDB admin source ([googleapis#1369](googleapis#1369)) ([33beb71](googleapis@33beb71)) * Add Cloud monitoring source and tool ([googleapis#1311](googleapis#1311)) ([d661f53](googleapis@d661f53)) * Add YugabyteDB Source and Tool ([googleapis#732](googleapis#732)) ([664711f](googleapis@664711f)) * **prebuilt:** Update default values for prebuilt tools ([googleapis#1355](googleapis#1355)) ([70e832b](googleapis@70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([googleapis#1310](googleapis#1310)) ([0171228](googleapis@0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([googleapis#1453](googleapis#1453)) ([a1bc044](googleapis@a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([googleapis#1383](googleapis#1383)) ([77919c7](googleapis@77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([googleapis#1406](googleapis#1406)) ([3a6b517](googleapis@3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([googleapis#1454](googleapis#1454)) ([e6a6c61](googleapis@e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([googleapis#1455](googleapis#1455)) ([bf6266b](googleapis@bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([googleapis#1440](googleapis#1440)) ([b176523](googleapis@b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([googleapis#1434](googleapis#1434)) ([15b628d](googleapis@15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([googleapis#1232](googleapis#1232)) ([googleapis#1347](googleapis#1347)) ([0cd3f16](googleapis@0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([googleapis#1403](googleapis#1403)) ([d302499](googleapis@d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([googleapis#1474](googleapis#1474)) ([1a42e05](googleapis@1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([googleapis#1318](googleapis#1318)) ([4b32c2a](googleapis@4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([googleapis#1352](googleapis#1352)) ([f819e26](googleapis@f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([googleapis#1425](googleapis#1425)) ([236be89](googleapis@236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([googleapis#1473](googleapis#1473)) ([edca9dc](googleapis@edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([googleapis#1227](googleapis#1227)) ([681c2b4](googleapis@681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([googleapis#1448](googleapis#1448)) ([9710014](googleapis@9710014)) * **source/bigquery:** Add support for datasets selection ([googleapis#1313](googleapis#1313)) ([aa39724](googleapis@aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([googleapis#1472](googleapis#1472)) ([92680b1](googleapis@92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([googleapis#1441](googleapis#1441)) ([56b6574](googleapis@56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([googleapis#1408](googleapis#1408)) ([4f46782](googleapis@4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([googleapis#1306](googleapis#1306)) ([3aef2bb](googleapis@3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([googleapis#1331](googleapis#1331)) ([76bb876](googleapis@76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([googleapis#1379](googleapis#1379)) ([091cd9a](googleapis@091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([googleapis#1380](googleapis#1380)) ([ab3fd26](googleapis@ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([googleapis#1420](googleapis#1420)) ([c181dab](googleapis@c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([googleapis#1435](googleapis#1435)) ([f2d9e3b](googleapis@f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([googleapis#1436](googleapis#1436)) ([677254e](googleapis@677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([googleapis#1319](googleapis#1319)) ([d4a9eb0](googleapis@d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([googleapis#1357](googleapis#1357)) ([93c1b30](googleapis@93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([googleapis#1377](googleapis#1377)) ([3a8a65c](googleapis@3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([googleapis#1223](googleapis#1223)) ([81d239b](googleapis@81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([googleapis#1411](googleapis#1411)) ([345bd6a](googleapis@345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([googleapis#1382](googleapis#1382)) ([bffb39d](googleapis@bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([googleapis#1431](googleapis#1431)) ([fe2999a](googleapis@fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([googleapis#1274](googleapis#1274)) ([e515d92](googleapis@e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([googleapis#1505](googleapis#1505)) ([7450482](googleapis@7450482)) * **tools/firestore:** Add `firestore-query` tool ([googleapis#1305](googleapis#1305)) ([cce602f](googleapis@cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([googleapis#1410](googleapis#1410)) ([2036c8e](googleapis@2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([googleapis#1433](googleapis#1433)) ([b036047](googleapis@b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([googleapis#1471](googleapis#1471)) ([ed54cd6](googleapis@ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([googleapis#1479](googleapis#1479)) ([fe651d8](googleapis@fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([googleapis#1493](googleapis#1493)) ([9eb821a](googleapis@9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([googleapis#1287](googleapis#1287)) ([6c8460b](googleapis@6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([googleapis#1400](googleapis#1400)) ([b2b06c7](googleapis@b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([googleapis#1284](googleapis#1284)) ([71f360d](googleapis@71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([googleapis#1404](googleapis#1404)) ([7d384dc](googleapis@7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([googleapis#1386](googleapis#1386)) ([b5f9780](googleapis@b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([googleapis#1494](googleapis#1494)) ([30f1d3a](googleapis@30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([googleapis#1468](googleapis#1468)) ([6c140d7](googleapis@6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([googleapis#1381](googleapis#1381)) ([80b7488](googleapis@80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([googleapis#1439](googleapis#1439)) ([da24661](googleapis@da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([googleapis#1428](googleapis#1428)) ([4babc4e](googleapis@4babc4e)) --- 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> c934d7a
github-actions Bot
pushed a commit
to Jaleel-zhu/genai-toolbox
that referenced
this pull request
Sep 19, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](googleapis/mcp-toolbox@v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([googleapis#1421](googleapis#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([googleapis#1449](googleapis#1449)) ### Features * Add AlloyDB admin source ([googleapis#1369](googleapis#1369)) ([33beb71](googleapis@33beb71)) * Add Cloud monitoring source and tool ([googleapis#1311](googleapis#1311)) ([d661f53](googleapis@d661f53)) * Add YugabyteDB Source and Tool ([googleapis#732](googleapis#732)) ([664711f](googleapis@664711f)) * **prebuilt:** Update default values for prebuilt tools ([googleapis#1355](googleapis#1355)) ([70e832b](googleapis@70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([googleapis#1310](googleapis#1310)) ([0171228](googleapis@0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([googleapis#1453](googleapis#1453)) ([a1bc044](googleapis@a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([googleapis#1383](googleapis#1383)) ([77919c7](googleapis@77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([googleapis#1406](googleapis#1406)) ([3a6b517](googleapis@3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([googleapis#1454](googleapis#1454)) ([e6a6c61](googleapis@e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([googleapis#1455](googleapis#1455)) ([bf6266b](googleapis@bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([googleapis#1440](googleapis#1440)) ([b176523](googleapis@b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([googleapis#1434](googleapis#1434)) ([15b628d](googleapis@15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([googleapis#1232](googleapis#1232)) ([googleapis#1347](googleapis#1347)) ([0cd3f16](googleapis@0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([googleapis#1403](googleapis#1403)) ([d302499](googleapis@d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([googleapis#1474](googleapis#1474)) ([1a42e05](googleapis@1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([googleapis#1318](googleapis#1318)) ([4b32c2a](googleapis@4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([googleapis#1352](googleapis#1352)) ([f819e26](googleapis@f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([googleapis#1425](googleapis#1425)) ([236be89](googleapis@236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([googleapis#1473](googleapis#1473)) ([edca9dc](googleapis@edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([googleapis#1227](googleapis#1227)) ([681c2b4](googleapis@681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([googleapis#1448](googleapis#1448)) ([9710014](googleapis@9710014)) * **source/bigquery:** Add support for datasets selection ([googleapis#1313](googleapis#1313)) ([aa39724](googleapis@aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([googleapis#1472](googleapis#1472)) ([92680b1](googleapis@92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([googleapis#1441](googleapis#1441)) ([56b6574](googleapis@56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([googleapis#1408](googleapis#1408)) ([4f46782](googleapis@4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([googleapis#1306](googleapis#1306)) ([3aef2bb](googleapis@3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([googleapis#1331](googleapis#1331)) ([76bb876](googleapis@76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([googleapis#1379](googleapis#1379)) ([091cd9a](googleapis@091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([googleapis#1380](googleapis#1380)) ([ab3fd26](googleapis@ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([googleapis#1420](googleapis#1420)) ([c181dab](googleapis@c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([googleapis#1435](googleapis#1435)) ([f2d9e3b](googleapis@f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([googleapis#1436](googleapis#1436)) ([677254e](googleapis@677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([googleapis#1319](googleapis#1319)) ([d4a9eb0](googleapis@d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([googleapis#1357](googleapis#1357)) ([93c1b30](googleapis@93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([googleapis#1377](googleapis#1377)) ([3a8a65c](googleapis@3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([googleapis#1223](googleapis#1223)) ([81d239b](googleapis@81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([googleapis#1411](googleapis#1411)) ([345bd6a](googleapis@345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([googleapis#1382](googleapis#1382)) ([bffb39d](googleapis@bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([googleapis#1431](googleapis#1431)) ([fe2999a](googleapis@fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([googleapis#1274](googleapis#1274)) ([e515d92](googleapis@e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([googleapis#1505](googleapis#1505)) ([7450482](googleapis@7450482)) * **tools/firestore:** Add `firestore-query` tool ([googleapis#1305](googleapis#1305)) ([cce602f](googleapis@cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([googleapis#1410](googleapis#1410)) ([2036c8e](googleapis@2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([googleapis#1433](googleapis#1433)) ([b036047](googleapis@b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([googleapis#1471](googleapis#1471)) ([ed54cd6](googleapis@ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([googleapis#1479](googleapis#1479)) ([fe651d8](googleapis@fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([googleapis#1493](googleapis#1493)) ([9eb821a](googleapis@9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([googleapis#1287](googleapis#1287)) ([6c8460b](googleapis@6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([googleapis#1400](googleapis#1400)) ([b2b06c7](googleapis@b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([googleapis#1284](googleapis#1284)) ([71f360d](googleapis@71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([googleapis#1404](googleapis#1404)) ([7d384dc](googleapis@7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([googleapis#1386](googleapis#1386)) ([b5f9780](googleapis@b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([googleapis#1494](googleapis#1494)) ([30f1d3a](googleapis@30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([googleapis#1468](googleapis#1468)) ([6c140d7](googleapis@6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([googleapis#1381](googleapis#1381)) ([80b7488](googleapis@80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([googleapis#1439](googleapis#1439)) ([da24661](googleapis@da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([googleapis#1428](googleapis#1428)) ([4babc4e](googleapis@4babc4e)) --- 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> c934d7a
github-actions Bot
pushed a commit
to bhardwajRahul/genai-toolbox
that referenced
this pull request
Sep 19, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](googleapis/mcp-toolbox@v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([googleapis#1421](googleapis#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([googleapis#1449](googleapis#1449)) ### Features * Add AlloyDB admin source ([googleapis#1369](googleapis#1369)) ([33beb71](googleapis@33beb71)) * Add Cloud monitoring source and tool ([googleapis#1311](googleapis#1311)) ([d661f53](googleapis@d661f53)) * Add YugabyteDB Source and Tool ([googleapis#732](googleapis#732)) ([664711f](googleapis@664711f)) * **prebuilt:** Update default values for prebuilt tools ([googleapis#1355](googleapis#1355)) ([70e832b](googleapis@70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([googleapis#1310](googleapis#1310)) ([0171228](googleapis@0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([googleapis#1453](googleapis#1453)) ([a1bc044](googleapis@a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([googleapis#1383](googleapis#1383)) ([77919c7](googleapis@77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([googleapis#1406](googleapis#1406)) ([3a6b517](googleapis@3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([googleapis#1454](googleapis#1454)) ([e6a6c61](googleapis@e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([googleapis#1455](googleapis#1455)) ([bf6266b](googleapis@bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([googleapis#1440](googleapis#1440)) ([b176523](googleapis@b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([googleapis#1434](googleapis#1434)) ([15b628d](googleapis@15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([googleapis#1232](googleapis#1232)) ([googleapis#1347](googleapis#1347)) ([0cd3f16](googleapis@0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([googleapis#1403](googleapis#1403)) ([d302499](googleapis@d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([googleapis#1474](googleapis#1474)) ([1a42e05](googleapis@1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([googleapis#1318](googleapis#1318)) ([4b32c2a](googleapis@4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([googleapis#1352](googleapis#1352)) ([f819e26](googleapis@f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([googleapis#1425](googleapis#1425)) ([236be89](googleapis@236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([googleapis#1473](googleapis#1473)) ([edca9dc](googleapis@edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([googleapis#1227](googleapis#1227)) ([681c2b4](googleapis@681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([googleapis#1448](googleapis#1448)) ([9710014](googleapis@9710014)) * **source/bigquery:** Add support for datasets selection ([googleapis#1313](googleapis#1313)) ([aa39724](googleapis@aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([googleapis#1472](googleapis#1472)) ([92680b1](googleapis@92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([googleapis#1441](googleapis#1441)) ([56b6574](googleapis@56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([googleapis#1408](googleapis#1408)) ([4f46782](googleapis@4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([googleapis#1306](googleapis#1306)) ([3aef2bb](googleapis@3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([googleapis#1331](googleapis#1331)) ([76bb876](googleapis@76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([googleapis#1379](googleapis#1379)) ([091cd9a](googleapis@091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([googleapis#1380](googleapis#1380)) ([ab3fd26](googleapis@ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([googleapis#1420](googleapis#1420)) ([c181dab](googleapis@c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([googleapis#1435](googleapis#1435)) ([f2d9e3b](googleapis@f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([googleapis#1436](googleapis#1436)) ([677254e](googleapis@677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([googleapis#1319](googleapis#1319)) ([d4a9eb0](googleapis@d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([googleapis#1357](googleapis#1357)) ([93c1b30](googleapis@93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([googleapis#1377](googleapis#1377)) ([3a8a65c](googleapis@3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([googleapis#1223](googleapis#1223)) ([81d239b](googleapis@81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([googleapis#1411](googleapis#1411)) ([345bd6a](googleapis@345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([googleapis#1382](googleapis#1382)) ([bffb39d](googleapis@bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([googleapis#1431](googleapis#1431)) ([fe2999a](googleapis@fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([googleapis#1274](googleapis#1274)) ([e515d92](googleapis@e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([googleapis#1505](googleapis#1505)) ([7450482](googleapis@7450482)) * **tools/firestore:** Add `firestore-query` tool ([googleapis#1305](googleapis#1305)) ([cce602f](googleapis@cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([googleapis#1410](googleapis#1410)) ([2036c8e](googleapis@2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([googleapis#1433](googleapis#1433)) ([b036047](googleapis@b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([googleapis#1471](googleapis#1471)) ([ed54cd6](googleapis@ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([googleapis#1479](googleapis#1479)) ([fe651d8](googleapis@fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([googleapis#1493](googleapis#1493)) ([9eb821a](googleapis@9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([googleapis#1287](googleapis#1287)) ([6c8460b](googleapis@6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([googleapis#1400](googleapis#1400)) ([b2b06c7](googleapis@b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([googleapis#1284](googleapis#1284)) ([71f360d](googleapis@71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([googleapis#1404](googleapis#1404)) ([7d384dc](googleapis@7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([googleapis#1386](googleapis#1386)) ([b5f9780](googleapis@b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([googleapis#1494](googleapis#1494)) ([30f1d3a](googleapis@30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([googleapis#1468](googleapis#1468)) ([6c140d7](googleapis@6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([googleapis#1381](googleapis#1381)) ([80b7488](googleapis@80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([googleapis#1439](googleapis#1439)) ([da24661](googleapis@da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([googleapis#1428](googleapis#1428)) ([4babc4e](googleapis@4babc4e)) --- 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> c934d7a
rapid-killer-9
pushed a commit
that referenced
this pull request
Sep 23, 2025
…ables that do not have primary or unique keys in a MySQL instance (#1493) ## Description --- A `mysql-list-tables-missing-index` tool searches tables that do not have primary or unique indices in a MySQL database. It's compatible with: - cloud-sql-mysql - mysql `mysql-list-tables-missing-index` outputs table names, including `table_schema` and `table_name` in JSON format. It takes 2 optional input parameters: - `table_schema` (optional): Only check tables in this specific schema/database. Search all visible tables in all visible databases if not specified. - `limit` (optional): max number of queries to return, default `50`. ## Example ```yaml tools: list_tables_missing_index: kind: mysql-list-tables-missing-index source: my-mysql-instance description: Find tables that do not have primary or unique key constraint. A primary key or unique key is the only mechanism that guaranttes a row is unique. Without them, the database-level protection against data integrity issues will be missing. ``` The response is a json array with the following fields: ```json { "table_schema": "the schema/database this table belongs to", "table_name": "name of the table", } ``` ## Reference | **field** | **type** | **required** | **description** | |-------------|:------------------------------------------:|:------------:|--------------------------------------------------------------------------------------------------| | kind | string | true | Must be "mysql-list-active-queries". | | source | string | true | Name of the source the SQL should execute on. | | description | string | true | Description of the tool that is passed to the LLM. | ## 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: - [x] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [x] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [x] Ensure the tests and linter pass - [x] Code coverage does not decrease (if any source code was changed) - [x] Appropriate docs were updated (if necessary) - [x] Make sure to add `!` if this involve a breaking change --------- Co-authored-by: Averi Kitsch <akitsch@google.com>
rapid-killer-9
pushed a commit
that referenced
this pull request
Sep 23, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([#1421](#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([#1449](#1449)) ### Features * Add AlloyDB admin source ([#1369](#1369)) ([33beb71](33beb71)) * Add Cloud monitoring source and tool ([#1311](#1311)) ([d661f53](d661f53)) * Add YugabyteDB Source and Tool ([#732](#732)) ([664711f](664711f)) * **prebuilt:** Update default values for prebuilt tools ([#1355](#1355)) ([70e832b](70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([#1310](#1310)) ([0171228](0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([#1453](#1453)) ([a1bc044](a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([#1383](#1383)) ([77919c7](77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([#1406](#1406)) ([3a6b517](3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([#1454](#1454)) ([e6a6c61](e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([#1455](#1455)) ([bf6266b](bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([#1440](#1440)) ([b176523](b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([#1434](#1434)) ([15b628d](15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([#1232](#1232)) ([#1347](#1347)) ([0cd3f16](0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([#1403](#1403)) ([d302499](d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([#1474](#1474)) ([1a42e05](1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([#1318](#1318)) ([4b32c2a](4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([#1352](#1352)) ([f819e26](f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([#1425](#1425)) ([236be89](236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([#1473](#1473)) ([edca9dc](edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([#1227](#1227)) ([681c2b4](681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([#1448](#1448)) ([9710014](9710014)) * **source/bigquery:** Add support for datasets selection ([#1313](#1313)) ([aa39724](aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([#1472](#1472)) ([92680b1](92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([#1441](#1441)) ([56b6574](56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([#1408](#1408)) ([4f46782](4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([#1306](#1306)) ([3aef2bb](3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([#1331](#1331)) ([76bb876](76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([#1379](#1379)) ([091cd9a](091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([#1380](#1380)) ([ab3fd26](ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([#1420](#1420)) ([c181dab](c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([#1435](#1435)) ([f2d9e3b](f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([#1436](#1436)) ([677254e](677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([#1319](#1319)) ([d4a9eb0](d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([#1357](#1357)) ([93c1b30](93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([#1377](#1377)) ([3a8a65c](3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([#1223](#1223)) ([81d239b](81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([#1411](#1411)) ([345bd6a](345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([#1382](#1382)) ([bffb39d](bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([#1431](#1431)) ([fe2999a](fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([#1274](#1274)) ([e515d92](e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([#1505](#1505)) ([7450482](7450482)) * **tools/firestore:** Add `firestore-query` tool ([#1305](#1305)) ([cce602f](cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([#1410](#1410)) ([2036c8e](2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([#1433](#1433)) ([b036047](b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([#1471](#1471)) ([ed54cd6](ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([#1479](#1479)) ([fe651d8](fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([#1493](#1493)) ([9eb821a](9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([#1287](#1287)) ([6c8460b](6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([#1400](#1400)) ([b2b06c7](b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([#1284](#1284)) ([71f360d](71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([#1404](#1404)) ([7d384dc](7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([#1386](#1386)) ([b5f9780](b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([#1494](#1494)) ([30f1d3a](30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([#1468](#1468)) ([6c140d7](6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([#1381](#1381)) ([80b7488](80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([#1439](#1439)) ([da24661](da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([#1428](#1428)) ([4babc4e](4babc4e)) --- 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>
rahulpinto19
pushed a commit
that referenced
this pull request
Sep 30, 2025
…ables that do not have primary or unique keys in a MySQL instance (#1493) ## Description --- A `mysql-list-tables-missing-index` tool searches tables that do not have primary or unique indices in a MySQL database. It's compatible with: - cloud-sql-mysql - mysql `mysql-list-tables-missing-index` outputs table names, including `table_schema` and `table_name` in JSON format. It takes 2 optional input parameters: - `table_schema` (optional): Only check tables in this specific schema/database. Search all visible tables in all visible databases if not specified. - `limit` (optional): max number of queries to return, default `50`. ## Example ```yaml tools: list_tables_missing_index: kind: mysql-list-tables-missing-index source: my-mysql-instance description: Find tables that do not have primary or unique key constraint. A primary key or unique key is the only mechanism that guaranttes a row is unique. Without them, the database-level protection against data integrity issues will be missing. ``` The response is a json array with the following fields: ```json { "table_schema": "the schema/database this table belongs to", "table_name": "name of the table", } ``` ## Reference | **field** | **type** | **required** | **description** | |-------------|:------------------------------------------:|:------------:|--------------------------------------------------------------------------------------------------| | kind | string | true | Must be "mysql-list-active-queries". | | source | string | true | Name of the source the SQL should execute on. | | description | string | true | Description of the tool that is passed to the LLM. | ## 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: - [x] Make sure you reviewed [CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md) - [x] Make sure to open an issue as a [bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose) before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea - [x] Ensure the tests and linter pass - [x] Code coverage does not decrease (if any source code was changed) - [x] Appropriate docs were updated (if necessary) - [x] Make sure to add `!` if this involve a breaking change --------- Co-authored-by: Averi Kitsch <akitsch@google.com>
rahulpinto19
pushed a commit
that referenced
this pull request
Sep 30, 2025
🤖 I have created a release *beep* *boop* --- ## [0.15.0](v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([#1421](#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([#1449](#1449)) ### Features * Add AlloyDB admin source ([#1369](#1369)) ([33beb71](33beb71)) * Add Cloud monitoring source and tool ([#1311](#1311)) ([d661f53](d661f53)) * Add YugabyteDB Source and Tool ([#732](#732)) ([664711f](664711f)) * **prebuilt:** Update default values for prebuilt tools ([#1355](#1355)) ([70e832b](70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([#1310](#1310)) ([0171228](0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([#1453](#1453)) ([a1bc044](a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([#1383](#1383)) ([77919c7](77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([#1406](#1406)) ([3a6b517](3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([#1454](#1454)) ([e6a6c61](e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([#1455](#1455)) ([bf6266b](bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([#1440](#1440)) ([b176523](b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([#1434](#1434)) ([15b628d](15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([#1232](#1232)) ([#1347](#1347)) ([0cd3f16](0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([#1403](#1403)) ([d302499](d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([#1474](#1474)) ([1a42e05](1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([#1318](#1318)) ([4b32c2a](4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([#1352](#1352)) ([f819e26](f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([#1425](#1425)) ([236be89](236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([#1473](#1473)) ([edca9dc](edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([#1227](#1227)) ([681c2b4](681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([#1448](#1448)) ([9710014](9710014)) * **source/bigquery:** Add support for datasets selection ([#1313](#1313)) ([aa39724](aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([#1472](#1472)) ([92680b1](92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([#1441](#1441)) ([56b6574](56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([#1408](#1408)) ([4f46782](4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([#1306](#1306)) ([3aef2bb](3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([#1331](#1331)) ([76bb876](76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([#1379](#1379)) ([091cd9a](091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([#1380](#1380)) ([ab3fd26](ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([#1420](#1420)) ([c181dab](c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([#1435](#1435)) ([f2d9e3b](f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([#1436](#1436)) ([677254e](677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([#1319](#1319)) ([d4a9eb0](d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([#1357](#1357)) ([93c1b30](93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([#1377](#1377)) ([3a8a65c](3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([#1223](#1223)) ([81d239b](81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([#1411](#1411)) ([345bd6a](345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([#1382](#1382)) ([bffb39d](bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([#1431](#1431)) ([fe2999a](fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([#1274](#1274)) ([e515d92](e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([#1505](#1505)) ([7450482](7450482)) * **tools/firestore:** Add `firestore-query` tool ([#1305](#1305)) ([cce602f](cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([#1410](#1410)) ([2036c8e](2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([#1433](#1433)) ([b036047](b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([#1471](#1471)) ([ed54cd6](ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([#1479](#1479)) ([fe651d8](fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([#1493](#1493)) ([9eb821a](9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([#1287](#1287)) ([6c8460b](6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([#1400](#1400)) ([b2b06c7](b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([#1284](#1284)) ([71f360d](71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([#1404](#1404)) ([7d384dc](7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([#1386](#1386)) ([b5f9780](b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([#1494](#1494)) ([30f1d3a](30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([#1468](#1468)) ([6c140d7](6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([#1381](#1381)) ([80b7488](80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([#1439](#1439)) ([da24661](da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([#1428](#1428)) ([4babc4e](4babc4e)) --- 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.15.0](googleapis/mcp-toolbox@v0.14.0...v0.15.0) (2025-09-18) ### ⚠ BREAKING CHANGES * **prebuilt:** update prebuilt tool names to use consistent guidance ([#1421](googleapis/mcp-toolbox#1421)) * **tools/alloydb-wait-for-operation:** Add `alloydb-admin` source to `alloydb-wait-for-operation` tool ([#1449](googleapis/mcp-toolbox#1449)) ### Features * Add AlloyDB admin source ([#1369](googleapis/mcp-toolbox#1369)) ([33beb71](googleapis/mcp-toolbox@33beb71)) * Add Cloud monitoring source and tool ([#1311](googleapis/mcp-toolbox#1311)) ([d661f53](googleapis/mcp-toolbox@d661f53)) * Add YugabyteDB Source and Tool ([#732](googleapis/mcp-toolbox#732)) ([664711f](googleapis/mcp-toolbox@664711f)) * **prebuilt:** Update default values for prebuilt tools ([#1355](googleapis/mcp-toolbox#1355)) ([70e832b](googleapis/mcp-toolbox@70e832b)) * **prebuilt/cloud-sql:** Add list instances tool for cloudsql ([#1310](googleapis/mcp-toolbox#1310)) ([0171228](googleapis/mcp-toolbox@0171228)) * **prebuilt/cloud-sql:** Add cloud sql create database tool. ([#1453](googleapis/mcp-toolbox#1453)) ([a1bc044](googleapis/mcp-toolbox@a1bc044)) * **prebuilt/cloud-sql:** Add `cloud-sql-get-instances` tool ([#1383](googleapis/mcp-toolbox#1383)) ([77919c7](googleapis/mcp-toolbox@77919c7)) * **prebuilt/cloud-sql:** Add create user tool for cloud sql ([#1406](googleapis/mcp-toolbox#1406)) ([3a6b517](googleapis/mcp-toolbox@3a6b517)) * **prebuilt/cloud-sql:** Add list databases tool for cloud sql ([#1454](googleapis/mcp-toolbox#1454)) ([e6a6c61](googleapis/mcp-toolbox@e6a6c61)) * **prebuilt/cloud-sql:** Package cloud sql tools ([#1455](googleapis/mcp-toolbox#1455)) ([bf6266b](googleapis/mcp-toolbox@bf6266b)) * **prebuilt/cloud-sql-mssql:** Add create instance tool for mssql ([#1440](googleapis/mcp-toolbox#1440)) ([b176523](googleapis/mcp-toolbox@b176523)) * **prebuilt/cloud-sql-mysql:** Add create instance tool for Cloud SQL MySQL ([#1434](googleapis/mcp-toolbox#1434)) ([15b628d](googleapis/mcp-toolbox@15b628d)) * **prebuilt/cloud-sql-mysql:** Add env var support for IP Type ([#1232](googleapis/mcp-toolbox#1232)) ([#1347](googleapis/mcp-toolbox#1347)) ([0cd3f16](googleapis/mcp-toolbox@0cd3f16)) * **prebuilt/cloudsqlpg:** Add cloud sql pg create instance tool ([#1403](googleapis/mcp-toolbox#1403)) ([d302499](googleapis/mcp-toolbox@d302499)) * **prebuilt/mysql:** Add a new tool to show query plan of a given query in MySQL ([#1474](googleapis/mcp-toolbox#1474)) ([1a42e05](googleapis/mcp-toolbox@1a42e05)) * **prebuilt/mysql:** Add `queryParams` field in MySQL prebuilt config ([#1318](googleapis/mcp-toolbox#1318)) ([4b32c2a](googleapis/mcp-toolbox@4b32c2a)) * **prebuilt/neo4j:** Add prebuiltconfig support for neo4j ([#1352](googleapis/mcp-toolbox#1352)) ([f819e26](googleapis/mcp-toolbox@f819e26)) * **prebuilt/observability:** Add cloud sql observability tools ([#1425](googleapis/mcp-toolbox#1425)) ([236be89](googleapis/mcp-toolbox@236be89)) * **prebuilt/postgres:** Add postgres prebuilt tools ([#1473](googleapis/mcp-toolbox#1473)) ([edca9dc](googleapis/mcp-toolbox@edca9dc)) * **prebuilt/sqlite:** Prebuilt tools for the sqlite. ([#1227](googleapis/mcp-toolbox#1227)) ([681c2b4](googleapis/mcp-toolbox@681c2b4)) * **source/alloydb-admin:** Add user agent and attach alloydb api in `alloydb-admin` source ([#1448](googleapis/mcp-toolbox#1448)) ([9710014](googleapis/mcp-toolbox@9710014)) * **source/bigquery:** Add support for datasets selection ([#1313](googleapis/mcp-toolbox#1313)) ([aa39724](googleapis/mcp-toolbox@aa39724)) * **source/cloud-monitoring:** Add support for user agent in cloud monitoring source ([#1472](googleapis/mcp-toolbox#1472)) ([92680b1](googleapis/mcp-toolbox@92680b1)) * **source/cloud-sql-admin:** Add User agent and attach sqldmin in `cloud-sql-admin` source. ([#1441](googleapis/mcp-toolbox#1441)) ([56b6574](googleapis/mcp-toolbox@56b6574)) * **source/cloudsqladmin:** Add cloud sql admin source ([#1408](googleapis/mcp-toolbox#1408)) ([4f46782](googleapis/mcp-toolbox@4f46782)) * **tool/cloudsql:** Add cloud sql wait for operation tool with exponential backoff ([#1306](googleapis/mcp-toolbox#1306)) ([3aef2bb](googleapis/mcp-toolbox@3aef2bb)) * **tools/alloydb-create-cluster:** Add custom tool kind for AlloyDB create cluster ([#1331](googleapis/mcp-toolbox#1331)) ([76bb876](googleapis/mcp-toolbox@76bb876)) * **tools/alloydb-create-instance:** Add new custom tool kind for AlloyDB ([#1379](googleapis/mcp-toolbox#1379)) ([091cd9a](googleapis/mcp-toolbox@091cd9a)) * **tools/alloydb-create-user:** Add new custom tool kind for AlloyDB create user ([#1380](googleapis/mcp-toolbox#1380)) ([ab3fd26](googleapis/mcp-toolbox@ab3fd26)) * **tools/alloydb-get-cluster:** Add new tool for AlloyDB ([#1420](googleapis/mcp-toolbox#1420)) ([c181dab](googleapis/mcp-toolbox@c181dab)) * **tools/alloydb-get-instance:** Add new for AlloyDB ([#1435](googleapis/mcp-toolbox#1435)) ([f2d9e3b](googleapis/mcp-toolbox@f2d9e3b)) * **tools/alloydb-get-user:** Add new tool for AlloyDB ([#1436](googleapis/mcp-toolbox#1436)) ([677254e](googleapis/mcp-toolbox@677254e)) * **tools/alloydb-list-cluster:** Add custom tool kind for AlloyDB ([#1319](googleapis/mcp-toolbox#1319)) ([d4a9eb0](googleapis/mcp-toolbox@d4a9eb0)) * **tools/alloydb-list-instances:** Add custom tool kind for AlloyDB ([#1357](googleapis/mcp-toolbox#1357)) ([93c1b30](googleapis/mcp-toolbox@93c1b30)) * **tools/alloydb-list-users:** Add new custom tool kind for AlloyDB ([#1377](googleapis/mcp-toolbox#1377)) ([3a8a65c](googleapis/mcp-toolbox@3a8a65c)) * **tools/bigquery-analyze-contribution:** Add analyze contribution tool ([#1223](googleapis/mcp-toolbox#1223)) ([81d239b](googleapis/mcp-toolbox@81d239b)) * **tools/bigquery-conversational-analytics:** Add allowed datasets support ([#1411](googleapis/mcp-toolbox#1411)) ([345bd6a](googleapis/mcp-toolbox@345bd6a)) * **tools/bigquery-search-catalog:** Add new tool to BigQuery ([#1382](googleapis/mcp-toolbox#1382)) ([bffb39d](googleapis/mcp-toolbox@bffb39d)) * **tools/bigquery:** Add `useClientOAuth` to BigQuery prebuilt source config ([#1431](googleapis/mcp-toolbox#1431)) ([fe2999a](googleapis/mcp-toolbox@fe2999a)) * **tools/clickhouse-list-databases:** Add `list-databases` tool to clickhouse source ([#1274](googleapis/mcp-toolbox#1274)) ([e515d92](googleapis/mcp-toolbox@e515d92)) * **tools/firestore-get-rules:** Add `databaseId` to the Firestore source and `firestore-get-rules` tool ([#1505](googleapis/mcp-toolbox#1505)) ([7450482](googleapis/mcp-toolbox@7450482)) * **tools/firestore:** Add `firestore-query` tool ([#1305](googleapis/mcp-toolbox#1305)) ([cce602f](googleapis/mcp-toolbox@cce602f)) * **tools/looker:** Query tracking for MCP Toolbox in Looker System Activity views ([#1410](googleapis/mcp-toolbox#1410)) ([2036c8e](googleapis/mcp-toolbox@2036c8e)) * **tools/mssql-list-tables:** Add new tool for sql server ([#1433](googleapis/mcp-toolbox#1433)) ([b036047](googleapis/mcp-toolbox@b036047)) * **tools/mysql-list-active-queries:** Add a new tool to list ongoing queries in a MySQL instance ([#1471](googleapis/mcp-toolbox#1471)) ([ed54cd6](googleapis/mcp-toolbox@ed54cd6)) * **tools/mysql-list-table-fragmentation:** Add a new tool to list table fragmentation in a MySQL instance ([#1479](googleapis/mcp-toolbox#1479)) ([fe651d8](googleapis/mcp-toolbox@fe651d8)) * **tools/mysql-list-tables-missing-index:** Add a new tool to list tables that do not have primary or unique keys in a MySQL instance ([#1493](googleapis/mcp-toolbox#1493)) ([9eb821a](googleapis/mcp-toolbox@9eb821a)) * **tools/mysql-list-tables:** Add new tool for MySQL ([#1287](googleapis/mcp-toolbox#1287)) ([6c8460b](googleapis/mcp-toolbox@6c8460b)) * **tools/postgres-list-active-queries:** Add new `postgres-list-active-queries` tool ([#1400](googleapis/mcp-toolbox#1400)) ([b2b06c7](googleapis/mcp-toolbox@b2b06c7)) * **tools/postgres-list-tables:** Add new tool to postgres source ([#1284](googleapis/mcp-toolbox#1284)) ([71f360d](googleapis/mcp-toolbox@71f360d)) * **tools/spanner-list-tables:** Add new tool `spanner-list-tables` ([#1404](googleapis/mcp-toolbox#1404)) ([7d384dc](googleapis/mcp-toolbox@7d384dc)) ### Bug Fixes * **bigquery:** Add `Bearer` parsing to auth token ([#1386](googleapis/mcp-toolbox#1386)) ([b5f9780](googleapis/mcp-toolbox@b5f9780)) * **source/alloydb-admin, source/cloudsql-admin:** Post append new user agent ([#1494](googleapis/mcp-toolbox#1494)) ([30f1d3a](googleapis/mcp-toolbox@30f1d3a)) * **tools/alloydb:** Update parameter names and set default description for AlloyDB control plane tools ([#1468](googleapis/mcp-toolbox#1468)) ([6c140d7](googleapis/mcp-toolbox@6c140d7)) * **tools/bigquery-conversational-analytics:** Fix authentication scope error in Cloud Run ([#1381](googleapis/mcp-toolbox#1381)) ([80b7488](googleapis/mcp-toolbox@80b7488)) * **tools/mysql-list-tables:** Update `mysql-list-tables` table_names parameter with default value ([#1439](googleapis/mcp-toolbox#1439)) ([da24661](googleapis/mcp-toolbox@da24661)) * **tools/neo4j:** Implement value conversion for Neo4j types to JSON-compatible ([#1428](googleapis/mcp-toolbox#1428)) ([4babc4e](googleapis/mcp-toolbox@4babc4e)) --- 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
A
mysql-list-tables-missing-indextool searches tables that do not have primary or unique indices in a MySQL database. It's compatible with:mysql-list-tables-missing-indexoutputs table names, includingtable_schemaandtable_namein JSON format. It takes 2 optional input parameters:table_schema(optional): Only check tables in this specific schema/database. Search all visible tables in all visible databases if not specified.limit(optional): max number of queries to return, default50.Example
The response is a json array with the following fields:
{ "table_schema": "the schema/database this table belongs to", "table_name": "name of the table", }Reference
PR Checklist
CONTRIBUTING.md
bug/issue
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
!if this involve a breaking change