Skip to content

CHANGELOG.md

Latest commit

 

History

History
131 lines (100 loc) · 5.06 KB

CHANGELOG.md

File metadata and controls

131 lines (100 loc) · 5.06 KB

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

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:

v0.1.0 - 2025-12-09

Added

Core Functions

  • generate_query(text, text, text) - Generate SQL queries from natural language descriptions
    • Automatic database schema discovery
    • Support for provider selection (openai, anthropic, gemini, auto)
    • Optional inline API key parameter
  • explain_query(text, text, text) - AI-powered query plan analysis
    • Runs EXPLAIN ANALYZE and provides human-readable explanations
    • Performance insights and optimization suggestions
  • get_database_tables() - Returns JSON array of all user tables with metadata
  • get_table_details(text, text) - Returns detailed table information including columns, constraints, and indexes

AI Provider Support

  • OpenAI - All current supported models
  • Anthropic - All current supported models
  • Google Gemini - All current supported models
  • OpenAI-compatible APIs - Support for OpenRouter and other compatible endpoints
  • Automatic provider selection with fallback logic
  • Configurable retry policies with exponential backoff

Configuration

  • File-based configuration via ~/.pg_ai.config
  • Support for multiple AI providers in single config
  • Configurable options:
    • Log level and logging toggle
    • Request timeout and retry settings
    • Query limit enforcement
    • Response formatting (explanations, warnings, visualizations)
    • Custom API endpoints for OpenAI-compatible services

Documentation

  • Comprehensive mdBook documentation
  • Installation and configuration guides
  • Provider comparison and model selection guide
  • Usage examples and troubleshooting

Technical Details

  • Built with C++20
  • Uses ai-sdk-cpp for AI provider integration
  • PostgreSQL extension API compliance

v0.1.0-beta - 2025-12-08

Added

Core Functions

  • generate_query(text, text, text) - Generate SQL queries from natural language descriptions
    • Automatic database schema discovery
    • Support for provider selection (openai, anthropic, auto)
    • Optional inline API key parameter
  • explain_query(text, text, text) - AI-powered query plan analysis
    • Runs EXPLAIN ANALYZE and provides human-readable explanations
    • Performance insights and optimization suggestions
  • get_database_tables() - Returns JSON array of all user tables with metadata
  • get_table_details(text, text) - Returns detailed table information including columns, constraints, and indexes

AI Provider Support

  • OpenAI - All current supported models
  • Anthropic - All current supported models
  • OpenAI-compatible APIs - Support for OpenRouter and other compatible endpoints
  • Automatic provider selection with fallback logic
  • Configurable retry policies with exponential backoff

Configuration

  • File-based configuration via ~/.pg_ai.config
  • Support for multiple AI providers in single config
  • Configurable options:
    • Log level and logging toggle
    • Request timeout and retry settings
    • Query limit enforcement
    • Response formatting (explanations, warnings, visualizations)
    • Custom API endpoints for OpenAI-compatible services

Documentation

  • Comprehensive mdBook documentation
  • Installation and configuration guides
  • Provider comparison and model selection guide
  • Usage examples and troubleshooting

Technical Details

  • Built with C++20
  • Uses ai-sdk-cpp for AI provider integration
  • SSL/TLS support via OpenSSL
  • PostgreSQL extension API compliance