public inbox for [email protected]  
help / color / mirror / Atom feed
From: benodiwal via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pg_ai_query — AI-powered SQL generation & query analysis for PostgreSQL
Date: Sun, 23 Nov 2025 11:28:20 +0000
Message-ID: <[email protected]> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pg_ai_query — AI-powered SQL generation & query analysis for PostgreSQL
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox