Quick Start Guide

Prerequisites

• -A PostgreSQL 12+ database (local, cloud, or on-prem)
• -Network access from dbaBrain to your database (port 5432 or custom)
• -A database user with pg_monitor privileges (we will create one below)

Step 1: Create a monitoring user

Connect to your PostgreSQL instance as a superuser and run:

sql
CREATE USER dbabrain_monitor WITH PASSWORD 'your-secure-password-here';
GRANT pg_monitor TO dbabrain_monitor;

-- Allow access to all schemas you want monitored
GRANT USAGE ON SCHEMA public TO dbabrain_monitor;

-- For pg_stat_statements (recommended)
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
GRANT EXECUTE ON FUNCTION pg_stat_statements_reset() TO dbabrain_monitor;

Step 2: Sign up and add your database

• -Go to dbabrain.ai/register and create your account
• -After login, you will be taken to the onboarding wizard
• -Enter your database connection details: host, port, database name, username, password
• -Click "Test Connection" to verify connectivity

Step 3: First scan

Once connected, Sage automatically scans your environment. Within 60 seconds you will see:

• -Health score (A through F grading)
• -Active issues ranked by severity
• -Connection stats, cache hit ratio, replication status
• -Top queries by total execution time
• -Vacuum activity and dead tuple counts

Step 4: Ask Sage

Click the Sage chat panel on the dashboard and ask anything. Examples:

• -"What is the most critical issue right now?"
• -"Why is cache hit ratio low?"
• -"Show me the slowest queries"
• -"What should I change in postgresql.conf?"
• -"Explain the current replication topology"

Sage uses your live database context to provide specific, actionable answers - not generic advice.