Heimdall Database Proxy vs TurbineProxy

Heimdall Database Proxy is a data access layer between an application and its database, routing, caching, and securing SQL queries. It can send reads to replicas and writes to primary databases, with replication-lag detection to support consistency. Frequently used queries can be cached with automatic expiry and invalidation rules to reduce database load and latency. Connection pooling can reduce front-side to back-side connections by up to a 1000:1 ratio. The proxy provides live SQL visibility, bottleneck identification, and auto-tuning recommendations, and can run as a transparent sidecar on-premise or in the cloud. Supported databases include MySQL, PostgreSQL, Amazon RDS, Oracle, SQL Server, MariaDB, DB2, Greenplum, and Redshift. Listed cloud integrations include AWS, Azure, Oracle, Google Cloud, and Redis. Active Directory integration supports authentication and authorization. Enterprise Plus includes data masking, GDPR auditing, and honey-tokens. A free Greenplum Community Edition is available for Greenplum use, with pooling, LDAP synchronization for one server, and SQL performance analytics. The AWS Marketplace listing offers a free 30-day trial; technical support for the Community Edition requires an Enterprise upgrade.

TurbineProxy is a self-hosted Rust proxy for MySQL and PostgreSQL that directs reads and writes according to query intent, without requiring application code changes. It can route across replicas or run as a standalone proxy in front of one database server. Replica routing supports round-robin or least-connections balancing and excludes replicas when lag exceeds a configured threshold. Per-backend connection pools use multiplexing and configurable sizes. Security controls include SQL injection detection, per-user read-only rules, query allowlists, and AES-256-GCM encryption at rest. For MySQL 8.0 and later, it specifies GTID-aware read-your-own-writes support. A web dashboard, Prometheus metrics, query analytics, a heatmap, and Grafana dashboard JSON cover observability. Its embedded MCP server offers seven tools over JSON-RPC 2.0 with Basic Auth, including slow-query analysis, N+1 detection, index advice, replica lag, and backend health. It is open source under Apache-2.0, with a free plan at free and no per-query fees. Install options include binary, Docker, Homebrew, AUR,.deb, and.rpm.