Pg_AI_query v0.1.0 – First stable release with multi-model AI for PostgreSQL (www.postgresql.org)

The pg_ai_query v0.1.0 has officially launched, marking a significant enhancement in AI-driven query development for PostgreSQL. This release enables users to generate SQL queries from natural language prompts, perform AI-assisted performance analysis through EXPLAIN ANALYZE, and receive automated recommendations for indexing and rewriting. Moreover, it introduces schema-aware query intelligence, allowing for a secure examination of database schemas. The compatibility with platforms such as OpenAI, Anthropic, and Google Gemini, along with support for local models, further broadens its usability across various environments. This stable release is particularly noteworthy for the AI/ML community as it integrates machine learning capabilities directly within a popular database management system, thus democratizing access to advanced query capabilities. Developers can now leverage a variety of cloud models and APIs like OpenRouter while maintaining an entirely PostgreSQL-centric workflow. With support for Linux and MacOS, and compatibility with PostgreSQL 14 and above, pg_ai_query v0.1.0 promises to streamline database interactions significantly. The project also invites community feedback and contributions, paving the way for future innovations.