# dolphie

> Real-time terminal interface for monitoring MySQL/MariaDB and ProxySQL database performance and analytics

Stars: 1.2k · Language: Python · License: GPL-3.0 · Categories: Data

- Repository: https://github.com/charles-001/dolphie
- Website: https://pypi.org/project/dolphie/
- Page: https://www.trmn.sh/tools/dolphie

## Install

- Homebrew: `brew install dolphie`
- pip: `pip install dolphie`
- Docker: `docker pull ghcr.io/charles-001/dolphie:latest`

## Overview

Dolphie is a terminal-based monitoring tool that provides real-time analytics and performance insights for MySQL, MariaDB, and ProxySQL databases. It displays multiple panels including dashboard metrics, process lists, replication status, metadata locks, DDL operations, and performance schema data in a single interface.

The tool connects to databases using standard MySQL connection methods including URI strings, credential profiles, SSL connections, and mysql_config_editor login paths. It supports monitoring AWS RDS/Aurora, Azure MySQL instances, and various MySQL/MariaDB versions from 5.5 to 9.x. For ProxySQL monitoring, it requires admin user access to utilize all features.

Dolphin includes record and replay functionality for capturing database sessions to SQLite files with ZSTD compression for later analysis. A daemon mode enables continuous background monitoring without the TUI interface, designed for always-on data collection. The tool offers configurable refresh intervals, panel selection, graph markers, and integrates with pt-heartbeat for more accurate replication lag measurements.

Database administrators, DevOps engineers, and developers working with MySQL-family databases would use this tool for real-time performance monitoring, troubleshooting database issues, and analyzing historical database behavior through recorded sessions.

### Installation

```bash
# via Homebrew
brew install dolphie
```

```bash
# via pip
pip install dolphie
```

```bash
# via Docker
docker pull ghcr.io/charles-001/dolphie:latest
```

![Dolphie main interface](https://media.trmn.sh/cached/2041b18a5c85256a806cd71149982d801b9b4c7d9a74a8d9b53fc26a235ad1b2.png)

## Alternatives

- [litecli](https://www.trmn.sh/tools/litecli.md): Command-line client for SQLite databases with auto-completion and syntax highlighting. (Python, 3.3k stars)
- [jc](https://www.trmn.sh/tools/jc.md): Converts output of CLI tools, file types, and strings to JSON or Python dictionaries so it can be piped to jq and used in scripts. (Python, 8.7k stars)
- [visidata](https://www.trmn.sh/tools/visidata.md): Terminal interface for exploring and arranging tabular data with support for CSV, JSON, SQLite, Excel, and many other formats. (Python, 9.4k stars)
- [mycli](https://www.trmn.sh/tools/mycli.md): MySQL command line client with auto-completion, syntax highlighting, and smart context-aware SQL suggestions (Python, 12.0k stars)
- [pgcli](https://www.trmn.sh/tools/pgcli.md): Interactive PostgreSQL client with auto-completion, syntax highlighting, and smart context-sensitive suggestions. (Python, 13.4k stars)

---

Canonical: https://www.trmn.sh/tools/dolphie