dbtrail — Claude Code MCP server: MySQL history on tap
Wires your AI client to an analytical MySQL copy so it can read past row versions, trace changes and draft recovery SQL. Read-only.
claude mcp add --transport http dbtrail https://api.dbtrail.com/mcpWhat dbtrail does
dbtrail tails the MySQL binlog and lands the changes as Parquet on disk or in S3. The MCP server exposes that copy to an agent: inspect how a row or table looked at an earlier moment, trace who touched a record, produce SQL that reverses unwanted edits. Every tool is read-only, so nothing typed into the chat can write to production.
Setup is a single HTTP endpoint, https://api.dbtrail.com/mcp — no local process to run. The copy itself needs binlog_format=ROW and binlog_row_image=FULL on the server; bintrail doctor checks both and prints how to fix them. On RDS and Aurora those live in the parameter group.
This is neither high availability nor a backup. History begins the day you install it, and the Parquet files trail the source by minutes on whatever schedule you pick. A schema change — a new or dropped column, a TRUNCATE — pauses the scheduled refresh until dbtrail reads the database again.
What it helps with
- see a row as it stood before an edit
- trace which user changed a record
- draft SQL that reverses damaged rows
- walk through a table's change history
- confirm a recovery would reproduce the data
Example prompts for the agent
- Show me row 4821 in
shop.ordersas it was yesterday at 14:00 - Who edited order 9912 in the last week?
- Write the SQL to undo the deleted rows in
customers
How to install dbtrail
Platform CLI: remote server
claude mcp add --transport http dbtrail https://api.dbtrail.com/mcpPlatform CLI: remote server
codex mcp add dbtrail --url https://api.dbtrail.com/mcpConfig file
{
"mcpServers": {
"dbtrail": {
"url": "https://api.dbtrail.com/mcp"
}
}
}Config file
{
"servers": {
"dbtrail": {
"type": "http",
"url": "https://api.dbtrail.com/mcp"
}
}
}Platform CLI: remote server
gemini mcp add -t http dbtrail https://api.dbtrail.com/mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about dbtrail
How do I install dbtrail in Claude Code?
Run claude mcp add --transport http dbtrail https://api.dbtrail.com/mcp.
What does dbtrail do?
It keeps a Parquet copy of your MySQL tables and serves it over MCP: past row versions, change attribution and recovery SQL for the agent.
What MySQL settings does dbtrail require?
binlog_format=ROW and binlog_row_image=FULL. bintrail doctor verifies both.
