ProxySQL 4.0.6 Release Notes

Release date: 2026-03-10

ProxySQL 4.0.6 is the first release of the AI/MCP Tier, introducing experimental generative AI and agentic features directly into the database proxy. It incorporates all improvements from ProxySQL 3.1.6 while adding a native Generative AI Module, a Model Context Protocol (MCP) stack, and an Anomaly Detection subsystem. This version is built using PROXYSQLGENAI=1 and requires the Rust toolchain.

Release commit: 3803f11077f21510b2b43ea7168abf91b54b739e

Highlights (AI/MCP Tier)

• Generative AI Integration: Native bridge to large language models (LLMs) with support for query analysis, routing, and translation.
• Model Context Protocol (MCP): A full MCP server implementation, allowing ProxySQL to act as a data source and tool provider for AI agents.
• RAG (Retrieval-Augmented Generation): High-performance vector ingestion and similarity search subsystem using sqlite-vec.
• Intelligent Anomaly Detection: AI-driven threat detection that identifies abnormal query patterns and potential security risks using semantic analysis.
• AI-Assisted Database Discovery: Automated schema exploration and question learning to help AI agents understand complex database structures.

New Features (4.0.x)

Generative AI & LLM Bridge

Native LLM Connectivity (ae4200d, #5339, #5423)
ProxySQL 4.0.6 introduces a native bridge to interact with external LLMs (e.g., OpenAI, Anthropic, or local models). This includes a generic provider interface, allowing administrators to configure API keys and model parameters via genai_variables. The bridge supports asynchronous LLM calls, ensuring that proxy performance is not blocked during AI processing.

Semantic Query Translation (NL2SQL) (a7dac5e, #5339)
An experimental "Natural Language to SQL" (NL2SQL) converter has been implemented, enabling ProxySQL to translate human-readable descriptions into valid database queries. This is integrated directly into the MySQL_Session handler, allowing for transparent query interception and translation.

Model Context Protocol (MCP) Stack

Native MCP Server (c8a6048d, #5312, #5339)
Implemented a comprehensive MCP server stack that supports both HTTP/HTTPS and stdio transports. This allows ProxySQL to seamlessly integrate with AI agent environments like Claude Code or Cursor. ProxySQL can now expose database schemas, query tools, and diagnostic information as standardized MCP tools.

Multi-Agent Database Discovery (aed042b, #5339)
A sophisticated multi-agent discovery system that uses specialized AI agents (e.g., Security, Metadata) to explore and document database structures. The system generates a comprehensive "Question Catalog" and "Discovery Report," providing AI agents with the necessary context to interact with the database effectively.

Retrieval-Augmented Generation (RAG)

Vector Embedding & Similarity Search (bcefd09, #5423, #5318)
The RAG subsystem provides high-performance storage and retrieval for vector embeddings. Integrated with sqlite-vec, it allows ProxySQL to perform fast semantic similarity searches across database artifacts. This is used to provide context-rich data to LLMs during agentic workflows.

Advanced RAG Ingestion Pipeline (79ee743, #5334, #5330)
The rag_ingest tool has been rewritten to use the MySQL protocol, allowing for high-performance ingestion of documents and data directly into ProxySQL's internal storage. It supports incremental syncing with watermark tracking and detailed logging for auditing.

Intelligent Anomaly Detection

Semantic Threat Identification (52a70b0, #5339)
The new Anomaly Detection subsystem uses AI-driven analysis to identify suspicious query patterns that traditional rule-based systems might miss. It can detect abnormal query structures, potential SQL injection attempts, and unauthorized access patterns by comparing query fingerprints against a database of known threat vectors using semantic similarity.

Features Inherited from v3.1.6 (Innovative Tier)

ProxySQL 4.0.6 includes all features from the v3.1.6 (Innovative) and v3.0.6 (Stable) releases, including:

• Innovative Tier Features: TSDB for historical metrics and FFTO for fast-forward traffic visibility (#5383, #5410).
• Core Stability: All security fixes and protocol hardening from the Stable Tier (#5348, #5429).
• Cross-Platform Support: Full macOS and Fedora 43 compatibility (#5308, #5329).

For a detailed list of these core improvements, please refer to the ProxySQL 3.0.6 Release Notes.

Contributors

ProxySQL is a community-driven project, and we are grateful to all the contributors who helped make this release possible. A special thank you to:

• @rahim-kanji for the extensive work on PostgreSQL protocol hardening and meta-command support.
• @wazir-ahmed for implementing the TSDB subsystem and MCP stack.
• @JavierJF for adding PostgreSQL replication lag monitoring and improving diagnostics.
• @Gonlo2 for critical fixes in connection pool management and SSL handling.
• @mirostauder for build system improvements and Fedora 43 support.
• @evkuzin for enhancing Prometheus metric observability.
• @orbisai0security for identifying and fixing security vulnerabilities.
• @mevishalr for performance optimizations in query logging.

We also thank everyone who reported bugs, tested experimental features, and provided feedback during this release cycle.

Hashes

The release commit is: 3803f11077f21510b2b43ea7168abf91b54b739e

SHA256s:

172d9f3ad5765e93077188c33fa5137d50fbadee178d529aa405854998fd819e  proxysql-4.0.6-1-almalinux10-clang.x86_64.rpm
130ef99a81ae9dd46b158637fff4d9528b28f1539083be2e60f6959e14798440  proxysql-4.0.6-1-almalinux10.aarch64.rpm
4c8d820de55a4343b7bb25eca6bbb3e9c446b4f793a8741a084f7267618597e6  proxysql-4.0.6-1-almalinux10.x86_64.rpm
aa1d7a4c0b3d43eb0627ecc096821e9feebabafa28658b348ef2f3d0956f5944  proxysql-4.0.6-1-almalinux8-clang.x86_64.rpm
438e7c1278aa72658582b0266987825828da6cd8ea4069e685966ef781735e2d  proxysql-4.0.6-1-almalinux9-clang.x86_64.rpm
67a809a8681eb6b7391ed77260e033e7a8be6612111b6d26df9314c171b9f6b1  proxysql-4.0.6-1-almalinux9.aarch64.rpm
1a0595b210cef9a22f6bebf15cd7b7f7c05b96072904354049a5a77c596c2ba1  proxysql-4.0.6-1-almalinux9.x86_64.rpm
920441cc72f740ed1888281105c9b6a22da2a8d9a731945d7045cd8a0e60b490  proxysql-4.0.6-1-centos10-clang.x86_64.rpm
a98f262ae118c06d2dadefad662f6d69d34de15c698c1ec1ed1db6cd759e0dcf  proxysql-4.0.6-1-centos10.aarch64.rpm
47e6fce1ef3d3947c1237f229037c4c23fc7a2a5148847c2915e16c9090c8980  proxysql-4.0.6-1-centos10.x86_64.rpm
e919163f416c658ebd56138ee71518c3806a769377d631801eeb301c7ae745f4  proxysql-4.0.6-1-centos9-clang.x86_64.rpm
786b28bc3ef36e5661596a6f49c48edeba7d5eeffce8bf2724e1a07847911722  proxysql-4.0.6-1-centos9.aarch64.rpm
4fc167fd044c829286522a3d064c440b59c817c441ee56492c09e85dd3db4955  proxysql-4.0.6-1-centos9.x86_64.rpm
2a9f8bc11f203df64a03d812142da3dbcbde73d6e24a58473e9ea207bca9c1b9  proxysql-4.0.6-1-dbg-almalinux10.x86_64.rpm
698f12a01894fbe2fe4c69fa3c431f58833f4c63c22601de514e2a3d52c495db  proxysql-4.0.6-1-dbg-almalinux9.x86_64.rpm
7fd1957540c9e76cb388da9a95f7c64965b6815447303ba8cc794b3ff7485c2a  proxysql-4.0.6-1-dbg-centos10.x86_64.rpm
ca8765f43904cbd649240659543424a77fd3f9c62934b457e2527361b54c363e  proxysql-4.0.6-1-dbg-centos9.x86_64.rpm
886da3556952f482ba3dbe961a655512756e13d2cce24f8b6d5291845126a5a5  proxysql-4.0.6-1-dbg-fedora42.x86_64.rpm
9a0a148e187a2fcbb096ddb5ddbb143ff7dfd2cfb078955fc6b62fa2947c4f5a  proxysql-4.0.6-1-dbg-fedora43.x86_64.rpm
d72da5bffdd7b578c4a10b233e03fe027095dac5cecdcc54c00f0fe5114d6d1a  proxysql-4.0.6-1-dbg-opensuse16.x86_64.rpm
35c9140968f7522c77ee9c232f94edf4b6b2bf0fcdb0fabf479bf085debb6060  proxysql-4.0.6-1-fedora42-clang.x86_64.rpm
0779ba5161032caf0d325c8b95a502806fcb42289aa32e3e99e2ff7904c5a05a  proxysql-4.0.6-1-fedora42.aarch64.rpm
6fe23a756e255aa624b81f0a37b52197c3ad274da6fc402b93745b476bdda7c3  proxysql-4.0.6-1-fedora42.x86_64.rpm
acd7d0862f70989424b6fc52dc18c0c70162bd2c3a06701da1ee0c6056f40032  proxysql-4.0.6-1-fedora43-clang.x86_64.rpm
988e17bf218ed905161756dc78759f61ddc232c84a52aafb4222b077f8353b28  proxysql-4.0.6-1-fedora43.aarch64.rpm
03a43055edf37a8eb60fa74a4f9b8961696406e226fe2cfdd6ae854d69283d7f  proxysql-4.0.6-1-fedora43.x86_64.rpm
b8e3e29163b8afcd7922bb9ee080abe995394915e0806a575d38fa2de4f758d1  proxysql-4.0.6-1-opensuse16-clang.x86_64.rpm
2ef8d8354cf339403a65ffcdf513af99fd9f91b8bceebce2bebaa76f43d4f77d  proxysql-4.0.6-1-opensuse16.aarch64.rpm
f4526e8b60942ba834af6055fd9881d321afe32fcaa08412dae8bf3b42648bc6  proxysql-4.0.6-1-opensuse16.x86_64.rpm
13ccbe0d012b8f2daf699a41fbb1ead8ec52912599046ae30bee5a34a53732e8  proxysql_4.0.6-dbg-debian12_amd64.deb
0b87a40c661c36df3bb0fdacfe6ee0b221793021927f9dcf6ad12702aa3e6721  proxysql_4.0.6-dbg-debian13_amd64.deb
9affd0b80cb0f814e3bfdd1f1a6f66562fccb2f9e5fd6f3dadd289cee4a3f50c  proxysql_4.0.6-dbg-ubuntu22_amd64.deb
2566e66d1cb2274a8c8c50969b3de0b46fd7f40590f0138b4d36681ff57eceda  proxysql_4.0.6-dbg-ubuntu22_arm64.deb
532318088ad1918fe61c82e1fa049430ed5a301e5d49d22556990ea5d58253da  proxysql_4.0.6-dbg-ubuntu24_amd64.deb
e0f5d541d6fc267e1c1f3fc294deb7102b2af9d10e54cb363177e1a22b5d8bc1  proxysql_4.0.6-dbg-ubuntu24_arm64.deb
dd9a38eb50385603077edf2281894de6ffdf6a740fc5f111da87dc9a95553a40  proxysql_4.0.6-debian12-clang_amd64.deb
79b949dc784bfed8e885570ed87370782a9df232b13fa9075a4d9cdff71e2490  proxysql_4.0.6-debian12_amd64.deb
4cde82e480cdca20e6929573c7ab6377ac1d06307524ae1fffea71e5fcaca603  proxysql_4.0.6-debian12_arm64.deb
b48c23287aeb8841a13224054336d1c5df03543a570ebe25b0f72c04f8b2d2be  proxysql_4.0.6-debian13-clang_amd64.deb
08b5e7994180acd8fffc05649845d8d51c1ba42e72938cafd7afb32a6588251b  proxysql_4.0.6-debian13_amd64.deb
1583ddd6083232a4a0ade67203af291ae680f0c41ed824a8a05b2573e7af4086  proxysql_4.0.6-debian13_arm64.deb
6fe6c18a4ab4f8ef3a8b83243e9f0cf9755fae49b3e72a8938b3d34c340c0577  proxysql_4.0.6-ubuntu22-clang_amd64.deb
738aeebc42fff0922680f95a867bad4e2f2b7e10c65a7cae50cb99e30e649028  proxysql_4.0.6-ubuntu22-clang_arm64.deb
4e8413a5d7554f503cc96661c1b0e390472e28f508166b76936a8bb2b2f89fd6  proxysql_4.0.6-ubuntu22_amd64.deb
bea615a2197c0f890590a46096e865b2095d2fc48f143edadb8adc98b15e7e79  proxysql_4.0.6-ubuntu22_arm64.deb
bacfb6454bb51e616aa4398c1f7da31897b4e91a5d721f062895eaed5334271b  proxysql_4.0.6-ubuntu24-clang_amd64.deb
2a35647ee4b9483aaa6a8f20075f3930a643a5fc6bac80976a249a52f3ddb23c  proxysql_4.0.6-ubuntu24-clang_arm64.deb
43f088afcf0180ce1d38d3e454409d2a719b62fc5ea047d99fe95928329d23b9  proxysql_4.0.6-ubuntu24_amd64.deb
bf391b73b2711ab5bb2115a85d737a6d550968fe38b0595a273189aa5ea8a704  proxysql_4.0.6-ubuntu24_arm64.deb