MySQL change tracking with instant row-level recovery and forensic attribution for compliance.
{
"mcpServers": {
"com-dbtrail-dbtrail": {
"command": "<see-readme>",
"args": []
}
}
}No install config available. Check the server's README for setup instructions.
Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
MySQL change tracking with instant row-level recovery and forensic attribution for compliance.
Is it safe?
No package registry to scan.
No authentication — any process on your machine can connect.
License not specified.
Is it maintained?
Commit history unknown.
Will it work with my client?
Transport: . Compatibility not confirmed.
A CLI tool that parses MySQL ROW-format binary logs, indexes every row event into MySQL with full before/after images, and generates reversal SQL for point-in-time recovery — without needing the original binlog files.
binlog_format = ROW and binlog_row_image = FULLgo install github.com/dbtrail/bintrail/cmd/bintrail@latest
Or build from source:
git clone https://github.com/dbtrail/bintrail
cd bintrail
go build ./cmd/bintrail
# 1. Create index tables (run once)
bintrail init --index-dsn "user:pass@tcp(127.0.0.1:3306)/binlog_index"
# 2. Snapshot schema metadata from the source server
bintrail snapshot \
--source-dsn "user:pass@tcp(source:3306)/" \
--index-dsn "user:pass@tcp(127.0.0.1:3306)/binlog_index"
# 3. Index binlog files (requires access to /var/lib/mysql on the source host)
bintrail index \
--index-dsn "user:pass@tcp(127.0.0.1:3306)/binlog_index" \
--source-dsn "user:pass@tcp(source:3306)/" \
--binlog-dir /var/lib/mysql \
--all
# 4. Query the index
bintrail query \
--index-dsn "user:pass@tcp(127.0.0.1:3306)/binlog_index" \
--schema mydb --table orders --pk 12345
# 5. Generate recovery SQL
bintrail recover \
--index-dsn "user:pass@tcp(127.0.0.1:3306)/binlog_index" \
--schema mydb --table orders --event-type DELETE \
--since "2026-02-19 14:00:00" --until "2026-02-19 14:05:00" \
--output recovery.sql
Managed MySQL (RDS, Aurora, Cloud SQL)? Use
bintrail streaminstead ofbintrail index— it connects over the replication protocol and requires no access to binlog files on disk. See Streaming.
New to bintrail? See the Practical Guide for DBAs for scenario-based walkthroughs and troubleshooting.
| Command | Description |
|---|---|
init | Create index tables in the target MySQL database |
snapshot | Capture table and column metadata from the source server |
index | Parse binlog files from disk and write row events to the index |
stream | Connect as a replica and index row events in real-time |
query | Search the index with flexible filters (schema, table, PK, time range, GTID) |
recover | Generate reversal SQL for matching events |
reconstruct | Rebuild row state at a point in time from baselines + binlog events |
rotate | Drop old partitions, add new ones, optionally archive to Parquet |
status | Show indexed files, partition sizes, and event counts |
dump | Invoke mydumper to create a logical dump of the source server |
baseline | Convert mydumper output to Parquet snapshots |
upload | Upload local Parquet files to S3 |
config init | Generate a .bintrail.env configuration file |
profile | Manage RBAC access profiles for query and recover |
flag | Label tables and columns (e.g. pii, sensitive) for access rules |
access | Link flags to profiles with allow/deny permissions |
generate-key | Generate an AES-256 encryption key for dump encryption |
All commands accept --log-level (default info) and --log-format (default text). See each command's --help for flags and usage.
Bintrail ships an MCP server that exposes query, recover, and status as read-only tools — letting Claude (or any MCP client) explore your binlog index conversationally.
The easiest way to connect — works from claude.ai, Claude Desktop, and Claude mobile:
https://mcp.dbtrail.com/mcp)The project ships .mcp.json which pre-registers the server using go run:
{
"mcpServers": {
"bintrail
... [View full README on GitHub](https://github.com/dbtrail/bintrail#readme)
No automated test available for this server. Check the GitHub README for setup instructions.
This server is missing a description. Tools and install config are also missing.If you've used it, help the community.
Add informationNo known vulnerabilities.
Have you used this server?
Share your experience — it helps other developers decide.
Sign in to write a review.
Query and manage PostgreSQL databases directly from AI assistants
Manage Supabase projects — databases, auth, storage, and edge functions
Asynchronous coordination layer for AI coding agents: identities, inboxes, searchable threads, and advisory file leases over FastMCP + Git + SQLite
Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors
MCP Security Weekly
Get CVE alerts and security updates for com.dbtrail/dbtrail and similar servers.
Start a conversation
Ask a question, share a tip, or report an issue.
Sign in to join the discussion.