What you can do

DBTrail is a server that speaks the MySQL protocol. Point a mysql client, a BI tool or your application at it, and heavy queries come back faster, without slowing down your MySQL. Same SQL, nothing to install on your MySQL, nothing to migrate.

Heavy queries, in seconds

• A report that took almost 4 minutes, in 8 seconds. The heaviest of 14 real reports took 225 seconds on a MySQL replica and 7.9 with DBTrail. The 14 ran 6.5 times faster on average. The numbers
• Questions over months or years of data. A total over every order line, a trend over the last two years: the queries that read most of a table.
• Deep pages. Page 5,000 of a listing, LIMIT 20 OFFSET 100000, where MySQL reads and throws away every row before the page.
• Dashboards that never slow down your MySQL, in Metabase or any BI tool. Dashboards
• One connection for your application. Its writes and its quick lookups stay on your MySQL; its heavy queries come back from DBTrail. Set it up, or with ProxySQL in front.

DBTrail answers from a copy of your tables that runs minutes behind your MySQL, like a replica. A query that must see a write made a second ago belongs on your MySQL, and so does a lookup of a few rows, which MySQL answers fastest: that is why routing keeps those on your MySQL.

And it keeps every change

• Undo a wrong DELETE or UPDATE. DBTrail writes the SQL that puts the rows back; you review it and run it. Undo a wrong change
• Your tables as they were yesterday at 14:30. Restore tables to a moment
• Any row as it was, and every change it went through, from your MySQL client. Past rows
• Know your backups restore, table by table, before the day you need them. Prove your backups restore
• Ask in plain English what changed in your data, with Claude. Connect Claude

Start

Quick Start: install, connect your MySQL and run your first query. Already running DBTrail? Upgrade.