ProxySQL Admin API
MySQL-compatible proxy server providing connection pooling, query routing, and load balancing with a MySQL protocol admin interface and HTTP stats API.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
TLS configurable but not enforced by default; admin interface exposed on separate port; default credentials must be rotated; no role-based access control on admin interface
⚡ Reliability
Best When
You run high-concurrency MySQL workloads and need connection pooling, read/write splitting, or transparent failover without application changes
Avoid When
You use Postgres or other non-MySQL databases, or your connection count is low enough that pooling provides minimal benefit
Use Cases
- • Connection pooling for high-traffic MySQL deployments
- • Read/write splitting across MySQL primary and replicas
- • Query caching and query rules enforcement
- • Zero-downtime MySQL failover and topology changes
- • Programmatic ProxySQL configuration via admin interface
Not For
- • Non-MySQL databases (Postgres, MongoDB, etc.)
- • Environments where adding a proxy hop is unacceptable for latency
- • Teams without MySQL expertise to manage ProxySQL configuration
Interface
Authentication
Admin interface uses MySQL protocol with username/password (default admin:admin). HTTP stats endpoint has no auth by default. REST API requires Basic Auth.
Pricing
Open source version covers most use cases. Enterprise adds ProxySQL Cluster, enhanced stats, and commercial support.
Agent Metadata
Known Gotchas
- ⚠ Configuration changes require LOAD ... TO RUNTIME and SAVE ... TO DISK to persist across restarts
- ⚠ HTTP stats endpoint is read-only; all writes must go through MySQL admin protocol
- ⚠ Default admin credentials (admin:admin) must be changed immediately in production
- ⚠ HTTP API is minimal stats-only; full management requires MySQL client
- ⚠ No OpenAPI spec; API surface discovered from documentation only
Alternatives
Full Evaluation Report
Detailed scoring breakdown, competitive positioning, security analysis, and improvement recommendations for ProxySQL Admin API.
Scores are editorial opinions as of 2026-03-06.