| From: | benodiwal via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
|---|---|
| To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
| Subject: | pg_ai_query — AI-powered SQL generation & query analysis for PostgreSQL |
| Date: | 2025-11-23 11:28:20 |
| Message-ID: | 176389730045.793.13162229784614051321@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
I am excited to announce the release of **pg_ai_query** — a PostgreSQL extension that brings AI-powered query development directly into Postgres.
pg_ai_query allows you to:
- Generate SQL from natural language, e.g.
`SELECT generate_query('list customers who have not placed an order in the last 90 days');`
- Analyze query performance using AI-interpreted `EXPLAIN ANALYZE`
- Receive index and rewrite recommendations
- Leverage schema-aware query intelligence with secure introspection
Designed to help developers write and tune SQL faster without switching tools and to accelerate iteration across complex workloads.
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. The project is actively maintained and evolving with community guidance.
Best regards,
Sachin Beniwal
benodiwal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vitabaks via PostgreSQL Announce | 2025-11-24 08:47:05 | Autobase 2.5.0 released |
| Previous Message | PostgreSQL Code of Conduct Committee via PostgreSQL Announce | 2025-11-17 15:26:45 | Call for new members PostgreSQL Community Code of Conduct Committee |