PlanetScale connector

Use your PlanetScale data for reporting, automation and AI.

Data Panda brings the PlanetScale database behind your application together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
PlanetScale logo
About PlanetScale

Managed MySQL on Vitess, with git-style branches and deploy requests.

PlanetScale is a cloud database platform built on Vitess, the same MySQL sharding layer that Slack, GitHub and HubSpot run their primary databases on. The platform gives a SaaS team a fully managed MySQL with horizontal sharding, branching that copies the schema (not the data) into an isolated branch, and deploy requests that gate every schema change behind a review and a queued, non-blocking migration.

For a typical Data Panda customer, the interesting tables sit on the production branch behind a Vitess router that may already shard a few of the larger ones by tenant or customer id. Pulling that database into a warehouse means reporting reads against a copy that joins to Stripe, HubSpot and the accounting ledger without putting load on the shards your application traffic is hitting. It also gives you a place to look at what changed across deploy requests, instead of finding out on Monday morning that the dashboard column quietly disappeared on Friday.

What your PlanetScale data is for

What you get once PlanetScale is connected.

Reporting off the shards

Application data joined to the rest of the stack, without touching the production cluster.

  • User, account and order tables next to CRM and accounting
  • Per-shard volume and growth on the same chart as the business KPI
  • Custom metrics from your app schema that no SaaS tool sees

Schema-aware automation

Let changes in PlanetScale fire actions in the tools around it.

  • New signup creates a HubSpot contact with the right plan
  • Order-state change pushes a Shopify fulfilment action
  • Plan change syncs to Stripe and the CRM on one id

AI workflows on app data

Score and classify on the same tables your application writes.

  • Churn prediction on real product-usage tables
  • Anomaly detection on orders, logins and Vitess shard load
  • Text classification on free-form fields in the schema

Internal apps on your data

Tools for support, finance and ops without raw branch credentials.

  • CS lookup with full account, plan and order history
  • Finance views tying app revenue to Stripe and the ledger
  • Release-impact analysis tied to deploy requests
Use cases

Use cases we deliver with PlanetScale data.

A list of concrete reports, automations and AI features we have built on PlanetScale data. Pick the one that matches your situation.

Signup-to-active funnelFrom new user row to first meaningful action in the app, by source.
Feature adoptionUsage of each key feature per plan and per cohort.
Custom KPI reportingBusiness metrics that only exist in the app schema.
Order-lifecycle analyticsCreate, ship, invoice and pay across the application.
Per-shard volumeRow counts and growth per Vitess shard, against business segments.
Multi-tenant reportingPer-tenant activity and revenue on a single record.
Deploy-request impactWhich dashboards each deploy request is about to change.
Schema drift trackingAdded, renamed and removed columns linked to downstream usage.
Query-cache hit reportingHit rates and slow-query patterns alongside the dashboards built on them.
Cost per active accountPlanetScale plan cost lined up against tenant activity.
Real business questions

Answers you will finally get.

Are our dashboards running directly against the PlanetScale production branch?

A survey of which dashboards query the production branch, with cluster load, query cost and shard hotspots flagged. Highlights the reports that should move to the warehouse first and the queries that are pinning a single shard at peak hour.

Which dashboards is the next deploy request going to break?

Schema diff from each open deploy request mapped to the dashboards, automations and AI workflows that read the affected columns. The review conversation stops being theoretical because the impact is visible before the migration runs.

Which tenants are loss-making at our current PlanetScale plan?

Tenant-level activity, row counts and shard load lined up against the Stripe revenue and PlanetScale plan cost. Finance and product see who is loss-making before the next price review, not after.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

PlanetScale plan cost lined up per tenant against the Stripe revenue and the activity each tenant generates. The cost of serving each customer becomes visible on the same record as their MRR.

For sales leaders

Product usage and account engagement on every CRM record, sourced from the PlanetScale production branch. Reps see who is about to expand and who is going quiet before the renewal call.

For operations

Shard load, schema drift and deploy-request impact tracked in one place. Reporting becomes part of the review on every deploy request, instead of a Tuesday morning surprise.

Ideas

What you can automate with PlanetScale.

Pair with BigQuery

Land PlanetScale tables into BigQuery

Tables from the PlanetScale production branch replicate into BigQuery on a schedule that fits the tenant. The application keeps owning the Vitess cluster while reporting, finance and AI workflows run on a warehouse copy that stays off the live shards.

Pair with GitHub

Tie deploy requests to the GitHub PR that opened them

Each PlanetScale deploy request is matched to the GitHub pull request that introduced the schema change, and the warehouse layers the dashboards, automations and AI workflows that read the affected columns on top. Engineering reviews the technical diff in GitHub and the business impact in one place.

Pair with PostHog

Join PostHog events to your PlanetScale users

Product events captured by PostHog are joined to the PlanetScale user and tenant tables in the warehouse, so behaviour analytics and back-end truth share the same identifier. Funnels, retention curves and feature-adoption charts read from one number, not two.

Pair with Slack

Push PlanetScale signals into Slack

Open deploy requests with high downstream impact, shard-hotspot alerts, plan-cost spikes and big new accounts from the warehouse land in the right Slack channel for the team that owns them. The on-call channel sees infra signal, the CS channel sees account signal, and nobody has to log into PlanetScale to find out.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your PlanetScale data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From PlanetScale to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • PlanetScale connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

How do you handle a PlanetScale database that is sharded by Vitess?

The connector reads through the Vitess router, so a sharded keyspace lands as a single logical table per source table in the warehouse. Per-shard row counts and load are kept as a side table for ops reporting, but the analytical join in the warehouse looks like one table, not n shards.

What happens to reporting when a deploy request changes the schema?

The diff inside each PlanetScale deploy request is mapped to the dashboards, automations and AI workflows that read those columns, before the migration runs. Added columns appear in the warehouse on the next sync, renamed ones link to their history, and removed ones stay read-only so older reports still run instead of silently returning null.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your PlanetScale setup and the systems around it. Together we pick the first thing worth building.