The PostgreSQL AI Query Extension (pg_ai_query) enables users to generate, validate, and optimize SQL queries in PostgreSQL directly from natural language using AI models from OpenAI and Anthropic.

Key features include automatic schema analysis, support for multiple AI providers, performance optimization, and built-in security measures to prevent unsafe queries. The extension operates natively within PostgreSQL, offering both query generation and analysis functionalities for rapid data exploration and optimization.