Documentation

dbtempo documentation

Ask about a query in chat, set up continuous monitoring with a project, or look up the exact command, engine, and rule behavior you need.

Start with a workflow

Analyze a query nowPaste SQL, EXPLAIN, or a slow log into chat. No setup required.Set up continuous monitoringOne wizard flow — host, database, schedule — then dbtempo finds slow queries for you.Open a draft PRTake an accepted recommendation into GitHub review.

Get started

Two ways to use dbtempo: ask about a query in chat, or have a project watch your database.

Run your first analysis

Analyze a slow SQL query in paste mode without connecting a database.

5 min

Set up continuous monitoring with a project

One wizard flow — host, database, source, schedule — then dbtempo finds slow queries for you.

5 min

Open your first pull request

Turn an accepted, executable recommendation into a reviewable GitHub draft PR.

7 min

How-to guides

Finish a specific setup or workflow.

Add a database connection

Add and manage individual connections — direct, SSH, or agent — and pass readiness.

10 min

Install the dbtempo CLI

Install the agent on macOS, Linux, or Windows and verify the binary.

4 min

Create and rotate a CLI API key

Generate a one-time CLI credential, install it, and revoke old keys safely.

4 min

Upload a slow-query log

Rank queries from a MySQL-format slow log and send one for deeper analysis.

5 min

Create a least-privilege database user

Grant the collector only the schema, query-statistics, and diagnostic access it needs.

8 min

Connect source code

Index a GitHub repository or a path reachable by a connected host.

5 min

Manage billing and subscription

Review the active plan, change the subscription, and manage payment records.

4 min

Manage notifications and account access

Set your timezone, choose email events, and review connected accounts and sessions.

5 min

Concepts

Understand how dbtempo analyzes evidence and proposes changes.

Where your data goes

Understand credential residency and the artifacts used for analysis.

6 min

How dbtempo analyzes a query

Follow a query from detection and evidence gathering to a proposed fix.

6 min

Read recommendation confidence and evidence

Interpret confidence, fix zones, provenance, and EXPLAIN comparisons together.

6 min

How auto-mode permissions work

Control which classes of changes are off, reviewed, or eligible for automation.

6 min

Understand credit usage

Read the percentage meter and identify which analysis paths consume credits.

4 min

Reference

Look up supported engines, commands, and rules.

Supported databases

Check live-collection and paste-analysis support by engine.

3 min

CLI command reference

Look up the commands used to configure, verify, run, and schedule dbtempo.

5 min

Rules library

8 deterministic query rules and 17 server-configuration rules registered by the current engine.

6 min

dbtempo glossary

Look up the product terms used across analysis, projects, and connections.

5 min

Troubleshooting

Recover from readiness, daemon, and collection failures.

Fix readiness and daemon problems

Recover when analysis is blocked, the daemon is offline, or no query source works.

7 min

Need help with a blocked setup?

Contact support

Loading…