# PostgreSQL

## 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:

```sql
-- 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:

```sql
-- 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.

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.wobby.ai/connections/connect-a-data-source/postgresql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.