-
Notifications
You must be signed in to change notification settings - Fork 1.2k
feat(tools/mysql-list-table-fragmentation): Add a new tool to list table fragmentation in a MySQL instance #1479
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Merged
averikitsch
merged 13 commits into
googleapis:main
from
shuzhou-gc:mysql-list-frag-tables
Sep 18, 2025
Merged
feat(tools/mysql-list-table-fragmentation): Add a new tool to list table fragmentation in a MySQL instance #1479
averikitsch
merged 13 commits into
googleapis:main
from
shuzhou-gc:mysql-list-frag-tables
Sep 18, 2025
Conversation
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
averikitsch
approved these changes
Sep 17, 2025
Contributor
|
/gcbrun |
Yuan325
reviewed
Sep 17, 2025
Contributor
Yuan325
left a comment
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Thank you! :)
internal/tools/mysql/mysqllisttablefragmentation/mysqllisttablefragmentation.go
Show resolved
Hide resolved
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
aa81d7e to
3729169
Compare
Contributor
|
/gcbrun |
Contributor
|
/gcbrun |
Contributor
|
/gcbrun |
github-actions bot
pushed a commit
that referenced
this pull request
Sep 18, 2025
… list table fragmentation in a MySQL instance (#1479) ## Description A `mysql-list-table-fragmentation` tool checks table fragmentation of MySQL tables by calculating the size of the data and index files in bytes and comparing with free space allocated to each table. This tool calculates `fragmentation_percentage` which represents the proportion of free space relative to the total data and index size. It's compatible with - cloud-sql-mysql - mysql `mysql-list-table-fragmentation` outputs detailed information as JSON , ordered by the fragmentation percentage in descending order. This tool takes 4 optional input parameters: - `table_schema` (optional): The database where fragmentation check is to be executed. Check all tables visible to the current user if not specified. - `table_name` (optional): Name of the table to be checked. Check all tables visible to the current user if not specified. - `data_free_threshold_bytes` (optional): Only show tables with at least this much free space in bytes. Default 1. - `limit` (optional): Max rows to return, default 10. ## Example ```yaml tools: list_table_fragmentation: kind: mysql-list-table-fragmentation source: my-mysql-instance description: List table fragmentation in MySQL, by calculating the size of the data and index files and free space allocated to each table. The query calculates fragmentation percentage which represents the proportion of free space relative to the total data and index size. Storage can be reclaimed for tables with high fragmentation using OPTIMIZE TABLE. ``` The response is a json array with the following fields: ```json { "table_schema": "The schema/database this table belongs to", "table_name": "Name of this table", "data_size": "Size of the table data in bytes", "index_size": "Size of the table's indexes in bytes", "data_free": "Free space (bytes) available in the table's data file", "fragmentation_percentage": "How much fragementation this table has", } ``` ## 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: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> Co-authored-by: Averi Kitsch <akitsch@google.com> fe651d8
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/genai-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/genai-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/genai-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
…ble fragmentation in a MySQL instance (#1479) ## Description A `mysql-list-table-fragmentation` tool checks table fragmentation of MySQL tables by calculating the size of the data and index files in bytes and comparing with free space allocated to each table. This tool calculates `fragmentation_percentage` which represents the proportion of free space relative to the total data and index size. It's compatible with - cloud-sql-mysql - mysql `mysql-list-table-fragmentation` outputs detailed information as JSON , ordered by the fragmentation percentage in descending order. This tool takes 4 optional input parameters: - `table_schema` (optional): The database where fragmentation check is to be executed. Check all tables visible to the current user if not specified. - `table_name` (optional): Name of the table to be checked. Check all tables visible to the current user if not specified. - `data_free_threshold_bytes` (optional): Only show tables with at least this much free space in bytes. Default 1. - `limit` (optional): Max rows to return, default 10. ## Example ```yaml tools: list_table_fragmentation: kind: mysql-list-table-fragmentation source: my-mysql-instance description: List table fragmentation in MySQL, by calculating the size of the data and index files and free space allocated to each table. The query calculates fragmentation percentage which represents the proportion of free space relative to the total data and index size. Storage can be reclaimed for tables with high fragmentation using OPTIMIZE TABLE. ``` The response is a json array with the following fields: ```json { "table_schema": "The schema/database this table belongs to", "table_name": "Name of this table", "data_size": "Size of the table data in bytes", "index_size": "Size of the table's indexes in bytes", "data_free": "Free space (bytes) available in the table's data file", "fragmentation_percentage": "How much fragementation this table has", } ``` ## 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: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 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
…ble fragmentation in a MySQL instance (#1479) ## Description A `mysql-list-table-fragmentation` tool checks table fragmentation of MySQL tables by calculating the size of the data and index files in bytes and comparing with free space allocated to each table. This tool calculates `fragmentation_percentage` which represents the proportion of free space relative to the total data and index size. It's compatible with - cloud-sql-mysql - mysql `mysql-list-table-fragmentation` outputs detailed information as JSON , ordered by the fragmentation percentage in descending order. This tool takes 4 optional input parameters: - `table_schema` (optional): The database where fragmentation check is to be executed. Check all tables visible to the current user if not specified. - `table_name` (optional): Name of the table to be checked. Check all tables visible to the current user if not specified. - `data_free_threshold_bytes` (optional): Only show tables with at least this much free space in bytes. Default 1. - `limit` (optional): Max rows to return, default 10. ## Example ```yaml tools: list_table_fragmentation: kind: mysql-list-table-fragmentation source: my-mysql-instance description: List table fragmentation in MySQL, by calculating the size of the data and index files and free space allocated to each table. The query calculates fragmentation percentage which represents the proportion of free space relative to the total data and index size. Storage can be reclaimed for tables with high fragmentation using OPTIMIZE TABLE. ``` The response is a json array with the following fields: ```json { "table_schema": "The schema/database this table belongs to", "table_name": "Name of this table", "data_size": "Size of the table data in bytes", "index_size": "Size of the table's indexes in bytes", "data_free": "Free space (bytes) available in the table's data file", "fragmentation_percentage": "How much fragementation this table has", } ``` ## 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: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 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>
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-table-fragmentationtool checks table fragmentation of MySQL tables by calculating the size of the data and index files in bytes and comparing with free space allocated to each table. This tool calculatesfragmentation_percentagewhich represents the proportion of free space relative to the total data and index size. It's compatible withmysql-list-table-fragmentationoutputs detailed information as JSON , ordered by the fragmentation percentage in descending order.This tool takes 4 optional input parameters:
table_schema(optional): The database where fragmentation check is to be executed. Check all tables visible to the current user if not specified.table_name(optional): Name of the table to be checked. Check all tables visible to the current user if not specified.data_free_threshold_bytes(optional): Only show tables with at least this much free space in bytes. Default 1.limit(optional): Max rows to return, default 10.Example
The response is a json array with the following fields:
{ "table_schema": "The schema/database this table belongs to", "table_name": "Name of this table", "data_size": "Size of the table data in bytes", "index_size": "Size of the table's indexes in bytes", "data_free": "Free space (bytes) available in the table's data file", "fragmentation_percentage": "How much fragementation this table has", }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