📋 Requirements

🚀 Quick start

-- Create a user for Postgres AI monitoringcreateuserpostgres_ai_mon with password'<password>';grant connecton database<database_name> to postgres_ai_mon;grant pg_monitor to postgres_ai_mon;grantselecton pg_stat_statements to postgres_ai_mon;grantselecton pg_stat_database to postgres_ai_mon;grantselecton pg_stat_user_tables to postgres_ai_mon;-- Create a public view for pg_statistic access (required for bloat metrics on user schemas)CREATEVIEWpublic.pg_statisticASSELECTn.nspnameas schemaname,c.relnameas tablename,a.attname,s.stanullfracas null_frac,s.stawidthas avg_width,    falseas inheritedFROM pg_statistic sJOIN pg_class cONc.oid=s.starelidJOIN pg_namespace nONn.oid=c.relnamespaceJOIN pg_attribute aONa.attrelid=s.starelidANDa.attnum=s.staattnumWHEREa.attnum>0AND NOTa.attisdropped;GRANTSELECTONpublic.pg_statistic TO pg_monitor;ALTERUSER postgres_ai_monset search_path="$user", public, pg_catalog;

# Download the CLIcurl -o postgres_ai https://gitlab.com/postgres-ai/postgres_ai/-/raw/testing/postgres_ai \&& chmod +x postgres_ai

# Complete setup with demo database./postgres_ai quickstart --demo# Production setup with your API key./postgres_ai quickstart --api-key=your_api_key

📊 What you get

🎯 Use cases

./postgres_ai quickstart --demo

./postgres_ai quickstart --api-key=your_key# Then add your databases./postgres_ai add-instance"postgresql://user:pass@host:port/db"

./postgres_ai quickstart --demo --api-key=$API_KEY

🔧 Management commands

# Instance management./postgres_ai add-instance"postgresql://user:pass@host:port/db"./postgres_ai list-instances./postgres_ai test-instance my-db# Service management./postgres_ai status./postgres_ai logs./postgres_ai restart# Health check./postgres_ai health

🌐 Access points

📖 Help

./postgres_aihelp

🔑 Postgres AI access token