v1.4 — auto mode in beta
The agent that keeps your database 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.
No credit card Self-hosted, your creds stay yours MySQL · MariaDB · Postgres
Today
Slow checkout query
users.email lookup
orders join plan
Yesterday
checkout_orders index
add LIMIT to admin export
EXPLAIN of report
EK
Elena K.10:42The 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 = '[email protected]' AND o.status IN ('paid','shipped') ORDER BY o.created_at DESC LIMIT 20;
plan · 2,400 creditsThe 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
dbtempo 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.
01
Paste a query
Or stream from your slow log via dbtempo. No commitment, no agent in your VPC.
02
Install dbtempo
One Homebrew/Cargo install. Reads your database with a least-privilege user you create.
03
Connect the repo
GitHub OAuth. We index the relevant code paths, never your secrets.
04
Review the PR
Or enable auto mode for whitelisted change types inside a maintenance window.
Pricing
Plans for solo DBAs and platform teams.
Free
$0/mo
Paste mode analysis. No database needed.
250k credits / month
Paste mode
File upload
Full quality analysis
7-day history
Starter
$29/mo
For solo engineers shipping fast.
4M credits / month
1 database
5 repos
dbtempo CLI
Email support
Most popularStart with Pro
Pro
$99/mo
For real teams — auto-PR enabled
15M credits / month
10 databases
Unlimited repos
Priority Slack
Auto mode (beta)
Agency
$299/mo
For consultancies and platform teams
45M credits / month
Unlimited workspaces
Audit trail export
Per-workspace credit pools
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 — dbtempo 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 and MariaDB are fully supported. PostgreSQL is in beta, with SQLite supported for local analysis.
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.