pg_ai_query

pg_ai_query : AI-powered SQL query generation for PostgreSQL

Overview

ID	Extension	Package	Version	Category	License	Language
2760	pg_ai_query	pg_ai_query	`0.1.1`	FEAT	Apache-2.0	C++

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d--	No	Yes	No	Yes	no	no

Relationships
See Also	pgml pg4ml vectorize pg_summarize pg_tiktoken

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`0.1.1`	18 17 16 15 14 13	`pg_ai_query`	-
RPM	PIGSTY	`0.1.1`	18 17 16 15 14 13	`pg_ai_query_$v*`	-
DEB	PIGSTY	`0.1.1`	18 17 16 15 14 13	`postgresql-$v-ai-query`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	MISS	MISS	MISS	MISS	MISS	MISS
el8.aarch64	MISS	MISS	MISS	MISS	MISS	MISS
el9.x86_64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
el9.aarch64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
el10.x86_64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
el10.aarch64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
d12.x86_64	MISS	MISS	MISS	MISS	MISS	MISS
d12.aarch64	MISS	MISS	MISS	MISS	MISS	MISS
d13.x86_64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
d13.aarch64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
u22.x86_64	MISS	MISS	MISS	MISS	MISS	MISS
u22.aarch64	MISS	MISS	MISS	MISS	MISS	MISS
u24.x86_64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS
u24.aarch64	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	PIGSTY 0.1.1	MISS

Package	Version	OS	ORG	SIZE	File URL
`pg_ai_query_18`	`0.1.1`	el9.x86_64	pigsty	967.9 KiB	pg_ai_query_18-0.1.1-1PIGSTY.el9.x86_64.rpm
`pg_ai_query_18`	`0.1.1`	el9.aarch64	pigsty	880.6 KiB	pg_ai_query_18-0.1.1-1PIGSTY.el9.aarch64.rpm
`pg_ai_query_18`	`0.1.1`	el10.x86_64	pigsty	899.5 KiB	pg_ai_query_18-0.1.1-1PIGSTY.el10.x86_64.rpm
`pg_ai_query_18`	`0.1.1`	el10.aarch64	pigsty	846.4 KiB	pg_ai_query_18-0.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-18-ai-query`	`0.1.1`	d13.x86_64	pigsty	842.3 KiB	postgresql-18-ai-query_0.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-18-ai-query`	`0.1.1`	d13.aarch64	pigsty	760.5 KiB	postgresql-18-ai-query_0.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-18-ai-query`	`0.1.1`	u24.x86_64	pigsty	795.0 KiB	postgresql-18-ai-query_0.1.1-1PIGSTY~noble_amd64.deb
`postgresql-18-ai-query`	`0.1.1`	u24.aarch64	pigsty	771.8 KiB	postgresql-18-ai-query_0.1.1-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_ai_query_17`	`0.1.1`	el9.x86_64	pigsty	967.8 KiB	pg_ai_query_17-0.1.1-1PIGSTY.el9.x86_64.rpm
`pg_ai_query_17`	`0.1.1`	el9.aarch64	pigsty	881.9 KiB	pg_ai_query_17-0.1.1-1PIGSTY.el9.aarch64.rpm
`pg_ai_query_17`	`0.1.1`	el10.x86_64	pigsty	899.4 KiB	pg_ai_query_17-0.1.1-1PIGSTY.el10.x86_64.rpm
`pg_ai_query_17`	`0.1.1`	el10.aarch64	pigsty	846.4 KiB	pg_ai_query_17-0.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-17-ai-query`	`0.1.1`	d13.x86_64	pigsty	845.8 KiB	postgresql-17-ai-query_0.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-17-ai-query`	`0.1.1`	d13.aarch64	pigsty	760.1 KiB	postgresql-17-ai-query_0.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-17-ai-query`	`0.1.1`	u24.x86_64	pigsty	795.0 KiB	postgresql-17-ai-query_0.1.1-1PIGSTY~noble_amd64.deb
`postgresql-17-ai-query`	`0.1.1`	u24.aarch64	pigsty	771.8 KiB	postgresql-17-ai-query_0.1.1-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_ai_query_16`	`0.1.1`	el9.x86_64	pigsty	967.8 KiB	pg_ai_query_16-0.1.1-1PIGSTY.el9.x86_64.rpm
`pg_ai_query_16`	`0.1.1`	el9.aarch64	pigsty	881.0 KiB	pg_ai_query_16-0.1.1-1PIGSTY.el9.aarch64.rpm
`pg_ai_query_16`	`0.1.1`	el10.x86_64	pigsty	899.5 KiB	pg_ai_query_16-0.1.1-1PIGSTY.el10.x86_64.rpm
`pg_ai_query_16`	`0.1.1`	el10.aarch64	pigsty	846.4 KiB	pg_ai_query_16-0.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-16-ai-query`	`0.1.1`	d13.x86_64	pigsty	841.1 KiB	postgresql-16-ai-query_0.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-16-ai-query`	`0.1.1`	d13.aarch64	pigsty	759.0 KiB	postgresql-16-ai-query_0.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-16-ai-query`	`0.1.1`	u24.x86_64	pigsty	795.6 KiB	postgresql-16-ai-query_0.1.1-1PIGSTY~noble_amd64.deb
`postgresql-16-ai-query`	`0.1.1`	u24.aarch64	pigsty	771.8 KiB	postgresql-16-ai-query_0.1.1-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_ai_query_15`	`0.1.1`	el9.x86_64	pigsty	967.4 KiB	pg_ai_query_15-0.1.1-1PIGSTY.el9.x86_64.rpm
`pg_ai_query_15`	`0.1.1`	el9.aarch64	pigsty	881.0 KiB	pg_ai_query_15-0.1.1-1PIGSTY.el9.aarch64.rpm
`pg_ai_query_15`	`0.1.1`	el10.x86_64	pigsty	899.3 KiB	pg_ai_query_15-0.1.1-1PIGSTY.el10.x86_64.rpm
`pg_ai_query_15`	`0.1.1`	el10.aarch64	pigsty	846.4 KiB	pg_ai_query_15-0.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-15-ai-query`	`0.1.1`	d13.x86_64	pigsty	841.4 KiB	postgresql-15-ai-query_0.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-15-ai-query`	`0.1.1`	d13.aarch64	pigsty	758.6 KiB	postgresql-15-ai-query_0.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-15-ai-query`	`0.1.1`	u24.x86_64	pigsty	795.2 KiB	postgresql-15-ai-query_0.1.1-1PIGSTY~noble_amd64.deb
`postgresql-15-ai-query`	`0.1.1`	u24.aarch64	pigsty	771.6 KiB	postgresql-15-ai-query_0.1.1-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_ai_query_14`	`0.1.1`	el9.x86_64	pigsty	967.8 KiB	pg_ai_query_14-0.1.1-1PIGSTY.el9.x86_64.rpm
`pg_ai_query_14`	`0.1.1`	el9.aarch64	pigsty	881.0 KiB	pg_ai_query_14-0.1.1-1PIGSTY.el9.aarch64.rpm
`pg_ai_query_14`	`0.1.1`	el10.x86_64	pigsty	899.3 KiB	pg_ai_query_14-0.1.1-1PIGSTY.el10.x86_64.rpm
`pg_ai_query_14`	`0.1.1`	el10.aarch64	pigsty	846.4 KiB	pg_ai_query_14-0.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-14-ai-query`	`0.1.1`	d13.x86_64	pigsty	841.6 KiB	postgresql-14-ai-query_0.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-14-ai-query`	`0.1.1`	d13.aarch64	pigsty	760.7 KiB	postgresql-14-ai-query_0.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-14-ai-query`	`0.1.1`	u24.x86_64	pigsty	795.2 KiB	postgresql-14-ai-query_0.1.1-1PIGSTY~noble_amd64.deb
`postgresql-14-ai-query`	`0.1.1`	u24.aarch64	pigsty	771.7 KiB	postgresql-14-ai-query_0.1.1-1PIGSTY~noble_arm64.deb

Source

Repository

github.com/benodiwal/pg_ai_query

Source Tarball

pg_ai_query-0.1.1.tar.gz

pig build pkg pg_ai_query;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_ai_query;		# install via package name, for the active PG version

pig install pg_ai_query -v 18;   # install for PG 18
pig install pg_ai_query -v 17;   # install for PG 17
pig install pg_ai_query -v 16;   # install for PG 16
pig install pg_ai_query -v 15;   # install for PG 15
pig install pg_ai_query -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION pg_ai_query;

Last updated on 2025-12-16

rum pg_graphql