Announcing the first stable release of pg_ai_query v0.1.0, a major milestone that expands AI-powered query development directly inside PostgreSQL.
With this release, pg_ai_query becomes more flexible, more portable, and easier to use across different environments.
pg_ai_query now supports:
Generating SQL from natural language, e.g. SELECT generate_query('list customers who have not placed an order in the last 90 days');
AI-interpreted EXPLAIN ANALYZE for understanding query performance
Automated index and rewrite recommendations
Schema-aware query intelligence through secure introspection
OpenAI, Anthropic, Google Gemini - all currently supported models
OpenAI-compatible APIs, including OpenRouter and similar endpoints
Local models, such as running through Ollama
Linux/Macos support for running the extension natively
This release is focused on giving developers more choice of cloud models, compatible APIs, or fully local inference while keeping the workflow entirely inside Postgres.
Documentation and installation instructions: https://benodiwal.github.io/pg_ai_query
Source code: https://github.com/benodiwal/pg_ai_query
pg_ai_query supports PostgreSQL 14+.
Feedback and contributions are very welcome as the project continues to grow.
Best regards,
Sachin Beniwal
benodiwal