A complete PostgreSQL monitoring solution with automated performance analysis and reporting.
One command setup:
# Download the CLI
curl -o postgres-ai-cli https://gitlab.com/postgres-ai/postgres_ai/-/raw/main/postgres-ai-cli && chmod +x postgres-ai-cli
# Complete setup with demo database
./postgres-ai-cli quickstart --demo
# Production setup with your API key
./postgres-ai-cli quickstart --api-key=your_api_keyThat's it! Everything is installed, configured, and running.
- Grafana Dashboards - Visual monitoring at http://localhost:3000
- PostgreSQL Monitoring - PGWatch with comprehensive metrics
- Automated Reports - Daily performance analysis
- API Integration - Automatic upload to PostgreSQL AI
- Demo Database - Ready-to-use test environment
For Developers:
./postgres-ai-cli quickstart --demoGet a complete monitoring setup with demo data in under 2 minutes.
For Production:
./postgres-ai-cli quickstart --api-key=your_key
# Then add your databases
./postgres-ai-cli add-instance "postgresql://user:pass@host:port/db"For CI/CD:
./postgres-ai-cli quickstart --demo --api-key=$API_KEYFully automated setup with no interactive prompts.
# Instance management
./postgres-ai-cli add-instance "postgresql://user:pass@host:port/db"
./postgres-ai-cli list-instances
./postgres-ai-cli test-instance my-db
# Service management
./postgres-ai-cli status
./postgres-ai-cli logs
./postgres-ai-cli restart
# Health check
./postgres-ai-cli healthAfter running quickstart:
- Grafana: http://localhost:3000 (admin/admin)
- Demo DB: postgresql://postgres:postgres@localhost:5432/target_database
- Monitoring: http://localhost:8080 (PGWatch)
- Metrics: http://localhost:9090 (Prometheus)
./postgres-ai-cli helpGet your key at PostgreSQL AI for automated report uploads and advanced analysis.