pg_ai_query

pig build pkg pg_ai_query;		# build rpm/deb

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

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 EXTENSION pg_ai_query;

[general]
log_level = "INFO"
enable_logging = false

[query]
enforce_limit = true
default_limit = 1000

[response]
show_explanation = true
show_warnings = true

[openai]
api_key = "your-openai-api-key"
default_model = "gpt-4o"

[anthropic]
api_key = "your-anthropic-api-key"
default_model = "claude-3-5-sonnet-20241022"

[gemini]
api_key = "your-google-api-key"
default_model = "gemini-2.5-flash"

SELECT generate_query('show all customers');
SELECT generate_query('monthly sales trend for the last year by category');
SELECT generate_query('customers who have not placed orders in the last 6 months');

SELECT get_database_tables();
SELECT get_table_details('orders');

SELECT explain_query('SELECT * FROM users WHERE created_at > NOW() - INTERVAL ''7 days''');

SELECT explain_query('SELECT * FROM products WHERE price > 100', 'your-api-key', 'anthropic');