ProxySQL is a database proxy designed to route and balance traffic between applications and MySQL or PostgreSQL servers. It provides database high availability by monitoring backend server health and automatically rerouting traffic to healthy nodes during failover events to prevent downtime.
The system integrates with generative AI models by proxying requests through a protocol handler, creating a bridge that allows large language models to access structured data.
The project includes capabilities for traffic management through automatic failover routing and cluster topology discovery. It optimizes performance using multiplexing-based connection pooling and parsed-query result caching. Observability is provided through real-time query logging, anomaly detection, and a time-series metric subsystem.
Security is managed via transport layer security encryption, IP-based access control, and LDAP authentication. Operational settings are managed through a SQL-based runtime configuration interface and file-based bootstrapping.