DEV.co
Open-Source Observability · charles-001

dolphie

Dolphie is a Python-based terminal UI for real-time monitoring and analytics of MySQL, MariaDB, and ProxySQL instances. It provides a dashboard for viewing processlist, replication status, metadata locks, and performance metrics in a single pane of glass.

Source: GitHub — github.com/charles-001/dolphie
1.2k
GitHub stars
79
Forks
Python
Primary language
GPL-3.0
License (OSI-approved)

Key facts

Objective fields from the source. Values we can't verify are shown as “Unknown” rather than guessed.

FieldValue
Repositorycharles-001/dolphie
Ownercharles-001
Primary languagePython
LicenseGPL-3.0 — OSI-approved
Stars1.2k
Forks79
Open issues1
Latest release6.15.0 (2026-06-04)
Last updated2026-06-04
Sourcehttps://github.com/charles-001/dolphie

What dolphie is

GPL-3.0 licensed Python 3.9+ application offering terminal-based SQL server monitoring via direct connections (TCP/socket/SSL). Supports MySQL 5.6–9.x, MariaDB 5.5–11.x+, ProxySQL 2.6+, with replay/daemon modes for data recording and asynchronous collection.

Quickstart

Get the dolphie source

Clone the repository and explore it locally.

terminalbash
git clone https://github.com/charles-001/dolphie.gitcd dolphie# follow the project's README for install & configuration

Need it deployed, integrated, or customized instead? DEV.co ships production installs.

Best use cases

Real-time MySQL/MariaDB troubleshooting

Quickly inspect active queries, locks, and replication lag without jumping between multiple tools. Suitable for on-call response and performance diagnostics.

Multi-host monitoring via tabbed interface

Monitor multiple database instances across environments (dev, staging, prod) from a single TUI with credential profiles and hostgroup configuration.

ProxySQL query rule and traffic analysis

Track hostgroup distribution, query rule matching, and command stats for proxied workloads in real-time.

Implementation considerations

  • Requires Python 3.9+ and network/socket connectivity to each monitored instance; SSH tunnel recommended for remote access.
  • Credential storage (config files, environment variables, mysql_config_editor) must be handled securely; plaintext passwords in config are a risk.
  • Replay/daemon modes can consume significant disk space; monitor log and data directory growth in production.
  • SSL/TLS support available (REQUIRED/VERIFY_CA/VERIFY_IDENTITY); configure certificates for encrypted connections to RDS/Azure instances.
  • Refresh intervals (default 1s) impact CPU and database load; tune based on your monitoring needs and instance capacity.

When to avoid it — and what to weigh

  • Need web UI or remote agent-based architecture — Dolphie is terminal-only and requires direct SSH or network access to database hosts; no web interface or pull-based agent model.
  • Require long-term metric retention and alerting — Designed for real-time inspection, not time-series storage or triggered notifications. Replay mode stores local files; not intended as a primary monitoring database.
  • GPL-3.0 license incompatible with your codebase — Strong copyleft: any modifications or derivative works must remain GPL-3.0. Embedding in proprietary applications requires legal review.
  • Minimal Python 3.9+ environment or restricted package access — Requires PyPI or Homebrew/Docker availability. Not suitable for air-gapped or highly constrained deployments without pre-staging.

License & commercial use

GPL-3.0 (GNU General Public License v3.0): strong copyleft, requires source disclosure and GPL compliance for modifications or distributions.

Commercial use of Dolphie as-is (unmodified, standalone tool) is permitted under GPL-3.0. Any modifications, bundling with proprietary systems, or resale require: (1) source code availability, (2) GPL-3.0 licensing of derivatives, and (3) legal review. Requires counsel before incorporating into SaaS or commercial offerings.

DEV.co evaluation signals

Editorial assessment — not user reviews. Directional, with an explicit confidence level.

SignalAssessment
MaintenanceActive
DocumentationAdequate
License clarityClear
Deployment complexityLow
DEV.co fitGood
Assessment confidenceHigh
Security considerations

Direct database credentials required; use ssl-mode REQUIRED/VERIFY_CA/VERIFY_IDENTITY for encrypted connections. Credentials can be stored in config files, environment variables, or mysql_config_editor; plaintext password files pose risk. TUI input is not logged; debug mode exposes sensitive data. No built-in authentication or audit trail. Ensure network access to database is restricted and config file permissions are locked (600).

Alternatives to consider

Percona Monitoring and Management (PMM)

Web-based, agent/pull architecture, multi-host dashboards, alerting, and native Prometheus integration. More heavyweight; AGPL-2.0 licensed.

MySQL Workbench (Performance Schema tools)

GUI-based, includes schema design, SQL editor, and basic monitoring. Proprietary dual-license (GPL + commercial). Heavier footprint, not terminal-native.

innotop / mytop

Lightweight, terminal-based MySQL monitoring alternatives. Less feature-rich than Dolphie; older and less actively maintained.

Software development agency

Build on dolphie with DEV.co software developers

Evaluate Dolphie for real-time database troubleshooting. Confirm GPL-3.0 compliance with your legal team before production deployment. Contact us for architecture and integration guidance.

Talk to DEV.co

Related open-source tools

Surfaced by semantic similarity across the DEV.co open-source index.

Related on DEV.co

Explore the category and the services that help you build with it.

dolphie FAQ

Can I use Dolphie in a production SaaS platform?
Not without legal review. Standalone use is permitted, but bundling or modifying for resale requires source disclosure and GPL-3.0 compliance. Consult counsel.
Does Dolphie work with AWS RDS Aurora?
Yes. RDS/Aurora MySQL and MariaDB are explicitly supported. Use SSL modes REQUIRED or VERIFY_CA for encrypted RDS connections.
Can I export or integrate Dolphie data with Prometheus or Grafana?
Not natively. Replay data is local file-based. Custom export logic or middleware needed to feed metrics into external monitoring systems.
What happens if I modify Dolphie and distribute it?
GPL-3.0 requires you to release modified source under the same license and provide copying rights. Failure is a license violation. Obtain legal advice if unsure.

Software developers & web developers for hire

DEV.co is a software development agency delivering custom software development services to companies building on open source. Our software developers and web developers design, integrate, and ship production systems — spanning web development, APIs, AI, data, and cloud. If dolphie is part of your open-source observability roadmap, our team can implement, customize, migrate, and maintain it.

Integrate Dolphie into Your Monitoring Stack

Evaluate Dolphie for real-time database troubleshooting. Confirm GPL-3.0 compliance with your legal team before production deployment. Contact us for architecture and integration guidance.