القائمة
Use these skills when you need to troubleshoot slow queries and analyze system-level PromQL metrics.
يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.
اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
يتجاوز الأمر المباشر Prompt المخصّص للمراجعة. افحص المصدر قبل تشغيله.
npx skills add https://github.com/gemini-cli-extensions/cloud-sql-sqlserver --skill cloud-sql-sqlserver-monitorيبقى الأمر في سطر واحد. مرّر أفقيًا لمراجعته كاملًا قبل النسخ.
تفضّل نسخة محلية؟ نزّل الملفات المتاحة حاليًا لدى SkillsMP.
Use these skills when you need to provision new Cloud SQL for SQL Server instances, create databases and users, clone existing environments, and monitor the progress of long-running operations.
Use these skills when you need to explore the database schema, execute SQL queries to interact with your data, and monitor system-level performance metrics using PromQL queries.
Use these skills when you need to manage the lifecycle and durability of your data, including creating backups, restoring from existing backups, and cloning instances for testing or migration.
استنادا إلى تصنيف SOC المهني
عرض SKILL.md
| name | cloud-sql-sqlserver-monitor |
| description | Use these skills when you need to troubleshoot slow queries and analyze system-level PromQL metrics. |
All scripts can be executed using Node.js. Replace <param_name> and <param_value> with actual values.
Bash:
node <skill_dir>/scripts/<script_name>.js '{"<param_name>": "<param_value>"}'
PowerShell:
node <skill_dir>/scripts/<script_name>.js '{\"<param_name>\": \"<param_value>\"}'
Note: The scripts automatically load the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due to env var absence.
Fetches system level cloudmonitoring data (timeseries metrics) for a SqlServer instance using a PromQL query. Take projectId and instanceId from the user for which the metrics timeseries data needs to be fetched.
To use this tool, you must provide the Google Cloud projectId and a PromQL query.
Generate PromQL query for SqlServer system metrics. Use the provided metrics and rules to construct queries, Get the labels like instance_id from user intent.
Defaults:
5m for _over_time aggregation functions unless a different window is specified by the user.PromQL Query Examples:
avg_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m])topk(30, avg_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))avg(avg_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))min(min_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))max(max_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))sum(avg_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))count(avg_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))quantile by ("database_id")(0.99,avg_over_time({"__name__"="cloudsql.googleapis.com/database/cpu/utilization","monitored_resource"="cloudsql_database","project_id"="my-projectId","database_id"="my-projectId:my-instanceId"}[5m]))Available Metrics List: metricname. description. monitored resource. labels. database_id is actually the instance id and the format is project_id:instance_id.
cloudsql.googleapis.com/database/cpu/utilization: Current CPU utilization as a percentage of the reserved CPU. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/memory/usage: RAM usage in bytes, excluding buffer/cache. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/memory/total_usage: Total RAM usage in bytes, including buffer/cache. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/disk/bytes_used: Data utilization in bytes. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/disk/quota: Maximum data disk size in bytes. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/disk/read_ops_count: Delta count of data disk read IO operations. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/disk/write_ops_count: Delta count of data disk write IO operations. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/network/received_bytes_count: Delta count of bytes received through the network. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/network/sent_bytes_count: Delta count of bytes sent through the network. cloudsql_database. destination, database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/memory/buffer_cache_hit_ratio: Current percentage of pages found in the buffer cache without reading from disk. . , , .| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| projectId | string | The Id of the Google Cloud project. | Yes | |
| query | string | The promql query to execute. | Yes |
cloudsql_databasedatabaseproject_iddatabase_idcloudsql.googleapis.com/database/sqlserver/memory/memory_grants_pending: Current number of processes waiting for a workspace memory grant. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/memory/free_list_stall_count: Total number of requests that waited for a free page. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/swap/pages_swapped_in_count: Total count of pages swapped in from disk since the system was booted. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/swap/pages_swapped_out_count: Total count of pages swapped out to disk since the system was booted. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/memory/checkpoint_page_count: Total number of pages flushed to disk by a checkpoint. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/memory/lazy_write_count: Total number of buffers written by the buffer manager's lazy writer. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/memory/page_life_expectancy: Current number of seconds a page will stay in the buffer pool. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/memory/page_operation_count: Total number of physical database page reads or writes. cloudsql_database. operation, database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/page_split_count: Total number of page splits from overflowing index pages. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/deadlock_count: Total number of lock requests that resulted in a deadlock. cloudsql_database. locked_resource, database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/transaction_count: Total number of transactions started. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/batch_request_count: Total number of Transact-SQL command batches received. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/sql_compilation_count: Total number of SQL compilations. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/sql_recompilation_count: Total number of SQL recompilations. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/connections/processes_blocked: Current number of blocked processes. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/lock_wait_time: Total time lock requests were waiting for locks. cloudsql_database. locked_resource, database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/lock_wait_count: Total number of lock requests that required the caller to wait. cloudsql_database. locked_resource, database, project_id, database_id.cloudsql.googleapis.com/database/network/connections: Number of connections to databases on the instance. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/connections/login_attempt_count: Total number of login attempts since the last server restart. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/connections/logout_count: Total number of logout operations since the last server restart. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/connections/connection_reset_count: Total number of logins started from the connection pool since the last server restart. cloudsql_database. database, project_id, database_id.cloudsql.googleapis.com/database/sqlserver/transactions/full_scan_count: Total number of unrestricted full scans (base-table or full-index). cloudsql_database. database, project_id, database_id.