v1.4 — auto mode in beta

The agent that keeps your MySQL fast.

DBTempo reads your schema, your slow log and your application code, then proposes — or applies — the indexes, rewrites and config changes that move latency.

Start 14-day trial See a live demo

No credit card Self-hosted CLI, your creds stay yours MySQL 5.7 / 8.0

dbtempo.com/threads/slow-checkout-query

Today

Slow checkout query

users.email lookup

orders join plan

Yesterday

checkout_orders index

add LIMIT to admin export

EXPLAIN of report

Elena K.10:42

The checkout query takes 1.8s on prod for repeat customers. Here's the EXPLAIN.

sql · pasted

SELECT o.id, o.total_cents, c.email, c.first_name
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE c.email = 'jordan@acme.co'
  AND o.status IN ('paid','shipped')
ORDER BY o.created_at DESC
LIMIT 20;

plan · 2,400 credits

The plan does a type=ALL scan of customers because there's no index on email. Recommendation:

Add indexauto-PR safeest. −83% latency

ALTER TABLE customers ADD INDEX idx_customers_email (email);

Trusted by teams atLatchetNorthwindRiverbedPikonSlatecoreMarqueePhloem

How it works

Detect, explain, fix — without leaking credentials to a cloud agent.

Detect

Surfaces what's actually slow

The CLI scrapes performance_schema, slow log, and statement digests on a cron. It learns which queries cost you wall-clock time, not which ones look ugly.

Explain

Reasons about your code, not just plans

Connect the repo and DBTempo locates the ORM call sites. Recommendations cite where the query is generated and what the framework expects.

Fix

Raises real PRs, with rollback

Index additions, LIMIT defaults, schema migrations — opened as PRs in your style, with EXPLAIN before/after and a one-command rollback.

Paste a query

Or stream from your slow log via the CLI. No commitment, no agent in your VPC.

Install the CLI

One Homebrew/Cargo install. Reads MySQL with a least-privilege user you create.

Connect the repo

GitHub OAuth. We index the relevant code paths, never your secrets.

Review the PR

Or enable auto mode for whitelisted change types inside a maintenance window.

Pricing

Plans for solo DBAs and platform teams.

Compare full features →

Starter

$29/mo

For a single app, ~10k credits/mo, paste mode + 1 CLI connection

1 database

5 repos

Email support

Start with Starter

Frequently asked.

Where does my SQL go?

The chat surface sends pasted queries to the LLM provider behind a gateway under our SOC2 controls. We never see your raw database — the CLI runs in your environment with a least-privilege user.

Can DBTempo run migrations on my prod database?

Only if you turn on auto mode after a 3-window dry run and only inside your defined maintenance window. The default is suggest-only.

Which databases?

MySQL 5.7 and 8.0 in v1. Postgres is the next target.

Does it work without a connected repo?

Yes — paste mode and EXPLAIN analysis work standalone. Repo connection adds call-site evidence and PRs.

What gets billed as a credit?

LLM tokens, primarily. A typical recommendation thread is 200–600 credits. Auto-applied changes are billed per action.

How do I cancel?

One click in billing. You keep your data for 30 days; CSV export is always free.

Slow queries, gone. Built in Tallinn, runs anywhere.

Product

Features

Pricing

Changelog

Roadmap

Resources

Docs

API

CLI ref

Status

Company

About

Customers

Blog

Hiring

Legal

Terms

Privacy

Subprocessors

DPA