API Reference
Complete reference for the dbtrail REST API
Base URL: https://api.dbtrail.com/api/v1/
dbtrail Cloud only
This REST API is part of dbtrail Cloud. If you self-host the open-source project, the web console exposes a local HTTP API on :8090 (including server management), and the bintrail CLI covers query, recover, status, and access rules.
Authentication
JWT tokens and API keys for accessing the dbtrail API
Servers
Register, list, update, and decommission MySQL servers
Query
Search indexed binlog changes by server, table, event type, and time range
Recover
Generate point-in-time recovery SQL from binlog history
Backups & PITR
Manage backup schedules and generate point-in-time recovery dumps
Access Rules
Manage role-based table and column access rules
Status
Check server health and binlog stream status
Forensics
Forensic investigation — capabilities, enrichment, queries, and row tracing
MCP
Model Context Protocol endpoint for AI tool integration
API Keys
Generate, use, and manage long-lived API keys for programmatic access