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](https://benodiwal.github.io/pg_ai_query)
Source code:
[https://github.com/benodiwal/pg_ai_query](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
