planetscale-query-insights-and-tags
Use PlanetScale Insights and SQLCommenter-style query tags to attribute database load, identify risky queries, and prepare safe Traffic Control or schema recommendations.
Install
With your agent
Install OMGSkills skill "planetscale/skills:planetscale-query-insights-and-tags" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/planetscale/skills /tmp/skills && ln -s /tmp/skills/planetscale-query-insights-and-tags ~/.claude/skills/planetscale-query-insights-and-tagsFrom README
Query Insights and tags Purpose Use PlanetScale Insights to understand query behavior, then recommend SQLCommenter-compatible tags that make future diagnosis and Traffic Control possible. Do not change database settings or repository code without approval. What to inspect Query behavior For the selected database and branch, inspect: Top queries by total time. Top queries by time per execution. Top queries by rows read. Top queries by execution count. For Postgres, top queries by CPU (sort=cpuTime or sort=percentCpuTime on the Insights API). Queries with errors. Notable queries and active anomalies. Query patterns affected by recent deploys. Query patterns attached to schema recommendations. For sharded Vitess databases, vindex for each query pattern: the percentage of traffic using relevant vindexes and the vindex- trend over time. The API exposes per-pattern indexusages and routingindexusages; get the trend from the dashboard Vindexes tab or by comparing API windows.
More from this repo
planetscale-autonomous-execution-mode
Execute approved PlanetScale changes end-to-end without per-step approval when the operator has explicitly acknowledged...
planetscale-best-practices-matrix
A concise feature matrix for deciding which PlanetScale safety, observability, and automation recommendations apply by...
planetscale-change-gates-and-approval-contract
Enforce explicit approval gates for any PlanetScale, database, repository, credential, network, or automation mutation.