Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUPUn-00A0Nl-2q for pgsql-announce@arkaria.postgresql.org; Sat, 13 Dec 2025 13:17:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vUPUl-00AUmo-2c for pgsql-announce@arkaria.postgresql.org; Sat, 13 Dec 2025 13:17:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUPUl-00AUmc-01 for pgsql-announce@lists.postgresql.org; Sat, 13 Dec 2025 13:17:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUPUh-000X7k-37 for pgsql-announce@lists.postgresql.org; Sat, 13 Dec 2025 13:17:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=k/VFNzZfDacQJN4A39dvqNZkAq4IpE1hnvBBgp5fhgs=; b=hJvI0GVcQC2wk825hqYFzUmrEB 76drwg5kB3ZGktS5GTR86Uj5iV7bOqvhBeNIAgYW0r6KwPGWO8O0i8Sx+Tw4eawxebnMUR8TPBDXJ zaP+10R8Lzv9BiT80kBPma/Iroa5nV5133csyiDAzKbkP/Jj2pVuAXbbVyF6LsGspSoSeTLKwsygw hmqxxjFNYmq/STBFXonbwKZR/7ydrvtmIeYy6k8JYEl2hveEroi9l2NB7UrSxCWG8D9CtMQr0uYpw C+gaBQZUWLWOX9/0xEA7G0Fz1Xw/X58MzPuktYITsIY/4+w4b1VAlLLm6eXvYjQ8XI24vCJ8zEUiO G8Pm3ifg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUPUf-001Mb6-3C for pgsql-announce@lists.postgresql.org; Sat, 13 Dec 2025 13:17:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vUPUd-002dPC-03 for pgsql-announce@lists.postgresql.org; Sat, 13 Dec 2025 13:17:03 +0000 Content-Type: multipart/mixed; boundary="===============4652832822858584865==" MIME-Version: 1.0 Subject: =?utf-8?q?pg=5Fai=5Fquery_v0=2E1=2E0_=E2=80=94_First_stable_release_with_multi-model_AI_for_PostgreSQL?= To: PostgreSQL Announce From: benodiwal via PostgreSQL Announce Reply-To: sachinbeniwal0101@gmail.com Date: Sat, 13 Dec 2025 13:16:16 +0000 Message-ID: <176563177607.780.7174193376325887132@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 896ed5b2ca2b0d216268fd77b948c86a8157abbd479ac1882cbc2378b7ee5afb List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4652832822858584865== Content-Type: multipart/alternative; boundary="===============3902626300293363582==" MIME-Version: 1.0 --===============3902626300293363582== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Announcing the first stable release of **pg_ai_query v0.1.0**, a major mile= stone that expands AI-powered query development directly inside PostgreSQL. =20 With this release, **pg_ai_query** becomes more flexible, more portable, an= d easier to use across different environments. =20 **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 l= ast 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 mo= dels - **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 entir= ely inside Postgres.=20 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+. =20 Feedback and contributions are very welcome as the project continues to gro= w. Best regards, =20 Sachin Beniwal =20 benodiwal --===============3902626300293363582== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pg_ai_query v0.1.0 =E2=80=94 First stable release with multi-mod= el AI for PostgreSQL
 

pg_ai_query v0.1.0 =E2=80=94 First stable release with multi-model AI= for PostgreSQL

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 differe= nt environments.

pg_ai_query now supports:<= /p>

  • Generating SQL from natural language, e.g. SELECT generate_query('list customers who have not placed an order in the l= ast 90 days');

  • AI-interpreted EXPLAIN ANALYZE for understanding query performance

  • Automated index and rewrite recommendations=

  • Schema-aware query intelligence through sec= ure introspection

  • OpenAI, Anthropic<= /strong>, Google Gemini - all currently supported models

  • OpenAI-compatible APIs, in= cluding OpenRouter and similar endpoints

  • Local models, such as running through Ollama

  • Linux/Macos support for ru= nning the extension natively

  • This release is focused on giving developer= s more choice of cloud models, compatible APIs, or fully local inference wh= ile 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 gro= w.

Best regards,
Sachin Beniwal
benodiwal
This email was sent to you from benodiwal. It was delivered on their behalf= by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to benodiwal.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============3902626300293363582==-- --===============4652832822858584865==--