- Notifications
You must be signed in to change notification settings - Fork0
Expert-level Postgres monitoring tool designed for humans and AI systems
License
postgres-ai/postgres_ai
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
A complete PostgreSQL monitoring solution with automated performance analysis and reporting.
Create a new DB user in database to be monitored (skip this if you want just to check outpostgres_ai monitoring with a syntheticdemo database):
-- 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;grant usageon schema public to postgres_ai_mon;grantselecton all tablesin schema public to postgres_ai_mon;-- TEMPORARY; TODO: get rid of thisgrantselecton all sequencesin schema public 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;
One command setup:
# Download the CLIcurl -o postgres_ai https://gitlab.com/postgres-ai/postgres_ai/-/raw/main/postgres_ai \&& chmod +x postgres_ai
Now, start it and wait for a few minutes. Two optional adjustments:
- remove
--demounless you want to see it in action without monitoring an actual Postgres DB (this option creates a demo DB) - get an Postgres AI access token for your organization athttps://console.postgres.ai (
Your org name → Manage → Access tokens)
# Complete setup with demo database./postgres_ai quickstart --demo# Production setup with your API key./postgres_ai quickstart --api-key=your_api_key
That's it! Everything is installed, configured, and running.
- Grafana Dashboards - Visual monitoring athttp://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 quickstart --demo
Get a complete monitoring setup with demo data in under 2 minutes.
For production:
./postgres_ai quickstart --api-key=your_key# Then add your databases./postgres_ai add-instance"postgresql://user:pass@host:port/db"
For CI/CD:
./postgres_ai quickstart --demo --api-key=$API_KEYFully automated setup with no interactive prompts.
# 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
After 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_aihelpGet your key atPostgres AI for automated report uploads and advanced analysis.
About
Expert-level Postgres monitoring tool designed for humans and AI systems
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
Uh oh!
There was an error while loading.Please reload this page.
Contributors3
Uh oh!
There was an error while loading.Please reload this page.