1. Habit
  2. Skills
  3. PlanetScale Query Insights and Tags skill
planetscale · 2K installs

PlanetScale Query Insights and Tags skill
Runs by itself, weekly insights review.

Weekly risky queries and tag gaps.

Install the PlanetScale Query Insights and Tags skill and make it a habit: follow https://gethabit.dev/skills/planetscale/planetscale-query-insights-and-tags.md

  1. 1Copy
  2. 2Paste into Claude Code, Codex or Cursor
  3. 3It runs by itself

2K installs135 starsMIT licenceSource on GitHub ↗

PlanetScale Query Insights and Tags

by planetscale · 2K installs

The skill

Planetscale query insights and tags is a skill for database owners that reads PlanetScale Insights to find risky queries and recommends SQLCommenter tags, Traffic Control slices and schema or code fixes, applying nothing.

Only when you ask.

The habit

Weekly risky queries and tag gaps.

↻ Runs by itselfweekly insights review

How the habit works.
You don't have to.

Three questionsWhen does it start? How does it check its work? What does it remember?

01

It starts by itself

weekly insights review. Runs in Claude Code routine.

  • ↻ weekly insights review
  • 0 8 * * 1

02

It checks its work

tables complete, no changes. If a check fails, it tells you.

  • ✓the query risk table lists each top pattern
  • ✓no recommended tag is in the never-default list
  • ✓the report ends with the no-changes line

03

It remembers

weekly risk tables. The next run reads it first: last week's top patterns and tag gaps.

loops/query-insights-review-loop/run-log.md

One run, step by step.
Then it stops.

Stop ruleStops after one branch and the top 20 query patterns per run.

  1. 01

    Read Insights

    Call /insights sorted by totalTime, rowsRead, count and errorCount for the window.

  2. 02

    Read anomalies

    Read /insights/anomalies and /insights/errors for moving patterns.

  3. 03

    Check tags

    Use /insights/tags and /insights/tags/summaries to see attribution and cardinality.

  4. 04

    Check raw collection

    Report the effective raw query collection state as a capability.

  5. 05

    Classify fixes

    Mark each pattern as tag, Traffic Control, schema or code candidate.

  6. 06

    Report

    List proposed changes needing approval and end with the no-changes line.

What it may do.
Nothing more.

Safe by defaultIt writes only in its own folder and asks you before anything goes out.

Is it for you?
Use it when it fits.

Quick checkRead both lists. If the left one sounds like you, the PlanetScale Query Insights and Tags skill helps.

Use it when

  • ✓ You want to know what loads the database
  • ✓ Queries lack attribution tags
  • ✓ You plan Traffic Control budgets

Skip it when

  • – You do not use PlanetScale
  • – You want changes applied automatically

Questions

PlanetScale Query Insights and Tags skill, answered.

Will it add tags to my code?

No. It proposes tags; code changes need approval.

Which tags should I avoid?

Unbounded ones such as user_id, request_id, email or raw URLs.

How do I install the PlanetScale Query Insights and Tags skill?

Copy the prompt at the top into your agent. It installs the skill from planetscale/skills and sets up the habit. Or run npx skills add planetscale/skills --skill planetscale-query-insights-and-tags.

Is the PlanetScale Query Insights and Tags skill free?

Yes. It is published under MIT. Habit is free too.

PlanetScale Query Insights and Tags. Now as a habit.

Install the PlanetScale Query Insights and Tags skill and make it a habit: follow https://gethabit.dev/skills/planetscale/planetscale-query-insights-and-tags.md

  • Free
  • No account
  • Undo in one line

All planetscale skills →More ops skills →

Works in

  • Claude Code
  • Codex
  • Cursor
  • ChatGPT
  • Claude app

Made by planetscale, published under MIT. Habit links to the original and never changes it. Is this your skill?

Copying didn't work here. Select the line and copy it by hand.