All templates

Automated PlanetScale Weekly Database Scorecard

Every Monday morning, WebRun opens PlanetScale, checks every database for its branch count, open deploy requests, schema changes awaiting review, and storage and row growth over the past week, emails the team a scorecard through Gmail, and logs the same numbers as a new row in Airtable.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 PlanetScale check branches, deploy requests, and storage growth
2 Gmail email the team a weekly scorecard
3 Airtable log the numbers for trend tracking
In short

How do I track PlanetScale database health and growth every week?

Every Monday, WebRun opens PlanetScale and checks each database's branch count, open deploy requests, and storage growth over the past week. It emails the engineering team a scorecard through Gmail and logs the same numbers to Airtable, so database health and growth are visible at a glance without anyone building the report by hand.

  • The whole team sees database health in one email, every Monday
  • Storage and row growth are tracked week over week without a manual export
  • Stale deploy requests get called out before they block a release

Built for backend engineering teams · database administrators · engineering managers · startups on PlanetScale

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.planetscale.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    PlanetScale - check branches, deploy requests, and storage growth
    planetscale.com
    WebRun in PlanetScale: check branches, deploy requests, and storage growth
    WebRun opens PlanetScale to check branches, deploy requests, and storage growth.
    • Open PlanetScale and go through each database in the organization
    • Count open branches, pending deploy requests, and schema changes awaiting review
    • Capture storage size and row count growth since the prior week

    Done when Every database has a captured branch, deploy request, and storage figure for the week.

  3. 2
    Gmail - email the team a weekly scorecard
    gmail.com
    WebRun in Gmail: email the team a weekly scorecard
    WebRun opens Gmail to email the team a weekly scorecard.
    • Draft and send a weekly scorecard email to the engineering team through Gmail
    • List each database with its branch count, open deploy requests, and storage growth
    • Call out any database whose deploy requests have sat open longest

    Done when The team has this week's PlanetScale scorecard in their inbox.

  4. 3
    Airtable - log the numbers for trend tracking
    airtable.com
    WebRun in Airtable: log the numbers for trend tracking
    WebRun opens Airtable to log the numbers for trend tracking.
    • Open the database scorecard base in Airtable
    • Add a new row per database with this week's figures
    • Leave prior weeks in place so the trend is visible over time

    Done when This week's figures are logged in Airtable alongside prior weeks.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.planetscale.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Weekly scorecard · Gmail
OutputWhat each run produces - A weekly scorecard email covering every database's branches, deploy requests, and storage growth, plus a running Airtable trend log.
Email + spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it merge or approve any deploy request?

No. WebRun only counts and reports open deploy requests. Reviewing schema changes and approving a deploy request always stays with your engineers.

Who receives the weekly scorecard email?

Whoever you add to the distribution list during setup. You control exactly who on the team sees it.

Can I see how storage has grown over time?

Yes. Every Monday adds a new row to the same Airtable base, so past weeks stay visible and the growth trend is easy to spot.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.