PostgreSQL

Connect a PostgreSQL Database

Connect PostgreSQL to Actian AI Analyst

To connect your PostgreSQL database to Actian AI Analyst, follow these steps:

1. Create a login role and user in your database.

2. Grant read-only permissions.

3. Allow Actian AI Analyst's IP address through your firewall or security rules.

4. Set up the connection in the Actian AI Analyst interface.

⚠️ Actian AI Analyst's agents only run read-only queries on your data. Write permissions are never used.

---

1. Create Role and User in PostgreSQL

In PostgreSQL, roles can act as both login accounts and permission holders. The following SQL sets up a login with read-only access for Actian AI Analyst:

-- Replace placeholder values with your actual schema and secure password

-- Create login role
CREATE ROLE analyst_login WITH LOGIN PASSWORD '<your_secure_password>';

-- Grant connection and usage privileges on the database
GRANT CONNECT ON DATABASE your_database_name TO analyst_login;

-- Grant usage on schema
GRANT USAGE ON SCHEMA your_schema_name TO analyst_login;

-- Grant read-only access to existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA your_schema_name TO analyst_login;

-- Grant read-only access to existing views
GRANT SELECT ON ALL SEQUENCES IN SCHEMA your_schema_name TO analyst_login;

✅ This setup gives Actian AI Analyst read access to the specified schema.

---

2. Optional: Auto-Grant Future Access

PostgreSQL supports default privileges, so you can configure it to automatically grant access to new tables and views:

-- Make sure this is run by a role that owns the schema
ALTER DEFAULT PRIVILEGES IN SCHEMA your_schema_name
GRANT SELECT ON TABLES TO analyst_login;

🔄 This ensures Actian AI Analyst gets access to future tables without needing manual grants.

---

3. Allow Actian AI Analyst's IP Address

If your PostgreSQL server is protected by firewall or network rules, allow inbound traffic from Actian AI Analyst's static IP:

34.77.172.158

This is required for Actian AI Analyst's agents to connect.

---

4. Set Up the Connection in Actian AI Analyst

1. Click Connections → Plus button → Select PostgreSQL.

2. Fill in the following details:

   • Host: your PostgreSQL server address

   • Port: typically 5432

   • Database name: the one where analyst_login has access

   • Username: analyst_login

   • Password: the password you defined earlier

3. Test the connection and save.

---