DocsConnectors

Postgresql

Postgresql logo

Postgresql

Connect your Postgresql data to Airweave

Overview

The Postgresql connector allows you to sync data from Postgresql into Airweave, making it available for search and retrieval by your agents.

Configuration

PostgreSQLSource

PostgreSQL source implementation.

This source connects to a PostgreSQL database and generates entities for each table in the specified schemas. It uses database introspection to:

  1. Discover tables and their structures
  2. Create appropriate entity classes dynamically
  3. Generate entities for each table’s data
View Source Code

Explore the Postgresql connector implementation

Authentication

This connector uses a custom authentication configuration class: PostgreSQLAuthConfig.

Authentication Configuration

PostgreSQL authentication configuration.

host
strRequired

The host of the PostgreSQL database

port
intRequired

The port of the PostgreSQL database

database
strRequired

The name of the PostgreSQL database

user
strRequired

The username for the PostgreSQL database

password
strRequired

The password for the PostgreSQL database

schema
strDefaults to public

The schema of the PostgreSQL database

tables
strDefaults to *

Comma separated list of tables to sync. For example, ‘users,orders’. For all tables, use ’*’