# Fleetdock

> Fleetdock is a free, open-source (Apache-2.0), self-hosted web dashboard and control plane for MariaDB, MySQL and PostgreSQL. It lets a team manage many database servers and databases from one place: connect servers, provision instances, browse and edit data, run SQL on many databases at once, schedule backups to their own S3 bucket, restore, and move databases between servers — without SSH and without handing credentials to a SaaS vendor.

- What it is: A self-hosted web dashboard and control plane for database fleets
- Databases: MariaDB, MySQL and PostgreSQL — self-hosted, in Docker, or hosted (e.g. Amazon RDS, Neon) when reachable over the network
- License: Open source, Apache-2.0. Free; no paid tier
- Runs on: Any Linux server with Docker; 2 vCPU and 4 GB RAM to start. macOS and Windows (WSL2) for local evaluation
- Install: One command: curl -sSL https://fleetdock.dev/install.sh | sudo sh (sets up automatic HTTPS)
- Architecture: A Manager (UI, API, worker, PostgreSQL metadata) plus an optional lightweight Agent on each database server
- Privacy: Runs entirely on your infrastructure, sends no telemetry; credentials encrypted at rest with your own key
- Written in: Go (backend and agent) with a React web UI
- Source code: https://github.com/Fleetdock/fleetdock

## What it does

- One overview of every server, database server and database
- Provision MariaDB, MySQL and PostgreSQL instances as isolated Docker containers
- Connect existing and hosted databases with just an address and a login
- Data browser: filter, edit rows with undo, follow foreign keys, saved views, CSV export
- SQL console with autocompletion, a preview of the rows a write will change, and query plans
- Fleet query: run one SQL script on up to 500 databases and compare the results
- Scheduled backups to S3, Cloudflare R2 or any S3-compatible storage, with retention and on-demand test restores
- Restore to the same or a new instance, with checksum verification
- Move or copy a database to another server: backup, restore and verify in one step
- Schema history, schema compare and generated migration scripts
- ER diagrams of a database's tables and foreign keys
- Server metrics (CPU, memory, disk, connections) and alerts by email, Slack or webhook
- Users, roles and per-database permissions, API tokens and an audit log
- Gateway for external access: one port per database with CIDR allowlists

## What it does not do

- No high availability, replication management or automatic failover — keep your existing replication for that
- Not a general container or Kubernetes platform; Docker is only used to run the databases it provisions
- Engines other than MariaDB, MySQL and PostgreSQL (e.g. Redis, MongoDB) are not supported yet

## Who it is for

- SaaS platforms with a database per customer
- ERP and CRM vendors with isolated tenant databases
- Hosting providers and agencies managing client databases
- Infrastructure teams replacing SSH sessions and home-grown scripts
- Developers who want one web GUI for all their MySQL and PostgreSQL databases

## Product

- [Overview](https://fleetdock.dev/): The product in one page, with screenshots and FAQ
- [Features](https://fleetdock.dev/features): Everything Fleetdock does
- [Pricing](https://fleetdock.dev/pricing): Free and open source; what it costs to run
- [Use cases](https://fleetdock.dev/use-cases): SaaS, ERP/CRM, hosting providers, agencies
- [Architecture](https://fleetdock.dev/architecture): Manager, Agent, Gateway and how operations run
- [Security](https://fleetdock.dev/security): Trust boundaries, privileges and compromise scenarios
- [About](https://fleetdock.dev/about): Fact sheet

## Docs

- [Agent installation](https://fleetdock.dev/docs/agents.md): Install, configure, and operate the Fleetdock Agent on a database node — one command to enroll, plus service management, logs, and uninstall.
- [Audit log](https://fleetdock.dev/docs/audit-log.md): Who did what and when in Fleetdock, with IP address, client and outcome; filters, CSV export and retention.
- [Backups](https://fleetdock.dev/docs/backups.md): Manual and scheduled backups to S3, Cloudflare R2, or S3-compatible storage — or a one-off download without storage — with retention, status, encryption, and integrity.
- [Core concepts](https://fleetdock.dev/docs/concepts.md): The vocabulary behind Fleetdock — Manager, Agent, Node, Instance, Database, Backup, Restore, Migration, Operation, and more.
- [Data browser](https://fleetdock.dev/docs/data-browser.md): Browse, filter and edit rows in full screen, follow foreign keys, find any table across the fleet, undo edits, and put rows back from a backup.
- [Database instances](https://fleetdock.dev/docs/database-instances.md): Provision, register, and manage MariaDB, MySQL, and PostgreSQL instances — configuration, lifecycle, credentials, logs, and connecting external applications.
- [ER diagram](https://fleetdock.dev/docs/er-diagram.md): See a database's tables, columns, keys and the foreign keys between them as an entity-relationship diagram.
- [External database access](https://fleetdock.dev/docs/external-access.md): Expose managed databases to applications outside your private network with the Fleetdock Gateway — HAProxy TCP proxy, CIDR allowlists, and app credentials.
- [Fleet query](https://fleetdock.dev/docs/fleet-query.md): Run one SQL script on many databases at once and read the results side by side.
- [Getting started](https://fleetdock.dev/docs/getting-started.md): Go from zero to your first managed database instance — install the Manager, connect a server, and provision MariaDB, MySQL, or PostgreSQL.
- [Introduction](https://fleetdock.dev/docs.md): Fleetdock is an open-source control plane for managing self-hosted database infrastructure across multiple servers.
- [Install on your computer](https://fleetdock.dev/docs/local.md): Run Fleetdock only on your own machine — macOS, Linux, or Windows through WSL2 — private to that computer, with no root and nothing exposed to the network.
- [Manager installation](https://fleetdock.dev/docs/manager.md): Install and operate the Fleetdock Manager control plane with Docker Compose, TLS, persistent storage, and production configuration.
- [Migration](https://fleetdock.dev/docs/migrations.md): Move or copy a database to another instance or server with a backup, restore, and verify saga — prerequisites, downtime, and failure recovery.
- [Networking](https://fleetdock.dev/docs/networking.md): How the Agent and Manager communicate, which ports and directions matter, and how to reach the Manager from VMs like Multipass during local development.
- [Nodes](https://fleetdock.dev/docs/nodes.md): Add, monitor, and remove database nodes — status, CPU, memory, disk, connectivity, and offline behavior.
- [Performance](https://fleetdock.dev/docs/performance.md): Unused and redundant indexes, the most expensive statements on a server, and query plans.
- [Restore](https://fleetdock.dev/docs/restores.md): Restore a database from a backup — same or new instance, checksum verification, downtime expectations, and failure handling.
- [Schema history](https://fleetdock.dev/docs/schema-history.md): Record every structural change to a database, get notified, compare two databases and generate the migration script.
- [Security](https://fleetdock.dev/docs/security.md): Fleetdock's trust model — Manager and Agent privileges, tokens and sessions, encryption, SSRF protection, compromise scenarios, and current limitations.
- [SQL console](https://fleetdock.dev/docs/sql-console.md): Run scripts with autocompletion, preview writes before they happen, and read query plans as a tree.
- [Troubleshooting](https://fleetdock.dev/docs/troubleshooting.md): Diagnose common Fleetdock problems — agent connectivity, tokens, TLS and DNS, Docker permissions, port conflicts, disk space, and stuck operations.
- [API reference](https://fleetdock.dev/docs/api.md): Fleetdock Manager HTTP API — authentication, endpoints, schemas, and an interactive playground.
- [OpenAPI specification](https://github.com/Fleetdock/fleetdock/blob/main/backend/internal/openapi/openapi.yaml): Every Manager API endpoint

## Guides

- [Scheduled PostgreSQL and MySQL backups to S3 or Cloudflare R2](https://fleetdock.dev/guides/database-backups-to-s3.md): Set up automated PostgreSQL and MySQL backups to S3 or Cloudflare R2 with a self-hosted tool: cron schedules, retention, checksums, alerts and test restores.
- [Database-per-tenant: operating hundreds of customer databases](https://fleetdock.dev/guides/database-per-tenant.md): Database per tenant for SaaS: trade-offs against a shared schema, and how to run hundreds of customer databases with fleet queries, backups and drift checks.
- [How to manage many MySQL and MariaDB servers from one dashboard](https://fleetdock.dev/guides/manage-multiple-mysql-servers.md): Manage multiple MySQL and MariaDB servers from one self-hosted dashboard: connect each server, see every database, schedule backups and query them all at once.
- [Move a MySQL or PostgreSQL database to another server, verified](https://fleetdock.dev/guides/move-database-to-another-server.md): How to migrate a MySQL or PostgreSQL database to another server: dump and restore commands, then a tracked copy or move with checksum and table-count checks.

## Comparisons

- [Fleetdock vs Adminer](https://fleetdock.dev/alternatives/adminer.md): Looking for an Adminer alternative? Compare Fleetdock and Adminer on setup, supported engines, scheduled backups, undo for edits and multi-server management.
- [Fleetdock vs ClusterControl](https://fleetdock.dev/alternatives/clustercontrol.md): Considering a ClusterControl alternative? Compare Fleetdock and Severalnines ClusterControl on HA and failover, engines, backups, data tools and pricing.
- [Fleetdock vs Percona Monitoring and Management](https://fleetdock.dev/alternatives/percona-pmm.md): Comparing Percona PMM alternatives? See how Fleetdock and PMM differ: monitoring depth, query analytics, backups, data tools, engines and licensing.
- [Fleetdock vs pgAdmin](https://fleetdock.dev/alternatives/pgadmin.md): Comparing pgAdmin alternatives? See how Fleetdock and pgAdmin differ on engines, scheduled backups, multi-database queries, sign-in options and licensing.
- [Fleetdock vs phpMyAdmin](https://fleetdock.dev/alternatives/phpmyadmin.md): Looking for a phpMyAdmin alternative? Compare Fleetdock and phpMyAdmin: engines, backups, undo for edits, multi-server use, licensing and when each one fits.

## Blog

- [Self-hosted vs managed databases: what you give up and keep](https://fleetdock.dev/blog/self-hosted-vs-managed-databases.md): A balanced look at self-hosting MariaDB, MySQL or PostgreSQL versus a managed service like RDS or Cloud SQL: cost, control, residency and operations.
- [Run one SQL script across hundreds of databases](https://fleetdock.dev/blog/run-sql-across-hundreds-of-databases.md): Fleet query in Fleetdock 0.9.0 runs a SQL script on up to 500 MariaDB, MySQL or PostgreSQL databases and merges the results. How it works and when to use it.
- [Introducing Fleetdock: one dashboard for all your databases](https://fleetdock.dev/blog/introducing-fleetdock.md): Fleetdock is an open-source, self-hosted control plane for MariaDB, MySQL and PostgreSQL. Why we built it, what 0.9.0 adds, what it doesn't do, how to install.

## Optional

- [Full text of the docs, guides and comparisons](https://fleetdock.dev/llms-full.txt)
- [Source code](https://github.com/Fleetdock/fleetdock)
- [Changelog](https://github.com/Fleetdock/fleetdock/blob/main/CHANGELOG.md)
- [Roadmap](https://github.com/Fleetdock/fleetdock/blob/main/ROADMAP.md)