pg_ai_query v0.1.1

pg_ai_query v0.1.1

PostgreSQL AI Query Extension - Generate SQL queries from natural language using AI.

Installation

Download the appropriate package for your platform below and follow the installation instructions.

What's New

[v0.1.1] - 2025-12-15

Fixed

Build System

• Fix LLVM bitcode build error on PostgreSQL 18+ (#30)
• Fix make install not installing shared library (#31, #37)
• Fix make clean not removing extension files from root directory (#35)

Configuration

• Fix config parser including inline comments with field values (#28)

Changed

CI/CD

• Pin GitHub Actions to commit SHAs for supply chain security (#32, #33)
• Add Makefile/PGXS build tests for PostgreSQL 16-18

Contributors

Thanks to the following people for their contributions to this release:

• @reneleonhardt - GitHub Actions security hardening
• @fvlnl - Reported PostgreSQL 18 build issues (#29)

---

Supported Platforms

Platform	PostgreSQL	File
Linux (x86_64)	14	pg_ai_query-v0.1.1-linux-x86_64-pg14.tar.gz
Linux (x86_64)	15	pg_ai_query-v0.1.1-linux-x86_64-pg15.tar.gz
Linux (x86_64)	16	pg_ai_query-v0.1.1-linux-x86_64-pg16.tar.gz
Linux (x86_64)	17	pg_ai_query-v0.1.1-linux-x86_64-pg17.tar.gz
Linux (x86_64)	18	pg_ai_query-v0.1.1-linux-x86_64-pg18.tar.gz
macOS (latest)	14	pg_ai_query-v0.1.1-macos-latest-pg14.tar.gz
macOS (latest)	15	pg_ai_query-v0.1.1-macos-latest-pg15.tar.gz
macOS (latest)	16	pg_ai_query-v0.1.1-macos-latest-pg16.tar.gz
macOS (latest)	17	pg_ai_query-v0.1.1-macos-latest-pg17.tar.gz
macOS (latest)	18	pg_ai_query-v0.1.1-macos-latest-pg18.tar.gz

Documentation

• Complete Guide: https://benodiwal.github.io/pg_ai_query
• Quick Start: Installation Guide
• Configuration: Configuration Guide

Requirements

• PostgreSQL 14+ with development headers
• OpenAI or Anthropic API key
• C++20 compatible compiler (for building from source)

Quick Start

1. Download and extract the appropriate package for your platform
2. Run ./install.sh to install the extension
3. Connect to PostgreSQL and run: CREATE EXTENSION pg_ai_query;
4. Configure your API key in ~/.pg_ai.config
5. Start generating queries: SELECT generate_query('show all users');

Issues & Support

• Report bugs: GitHub Issues
• Questions: GitHub Discussions
• Documentation: Official Docs

---

Full Changelog: v0.1.0...v0.1.1