PostgreSQL

Connect a PostgreSQL Database

Connect your Wobby agent directly to a PostgreSQL database to power real-time insights using structured, live data—no file uploads needed.

This guide will walk you through setting up a connection and importing your tables.

Quick Start

1. Go to Data Sources

2. Click Add Data Source → Select PostgreSQL

3. Fill in your database connection details

4. Click Test Connection

5. On success, click Save Connection

6. Choose the tables you want to import

7. Click Import Tables

That’s it—your agent is now connected and ready to query your data.

---

What You’ll Need

Before starting, make sure you have:

• Hostname or IP address

• Port (default: 5432)

• Database name

• Username and password

• SSL mode (optional)

You’ll be connecting to a single PostgreSQL database. If you're unsure about these details, check your database deployment settings.

---

Table Selection

After connecting, you’ll be prompted to choose which tables to import:

• Use the search bar or scroll through the list

• Select one or more tables

• Click Import Tables

You can import tables from the default schema. Once imported, you’ll be able to view their structure and edit metadata.

---

Metadata and Column Descriptions

Good metadata helps Wobby’s agents give better answers.

For each imported table, you can:

• View column names, types, and sample values

• Add descriptions per column

• Define constraints or classification tags (optional)

👉 Read more in Metadata

---

Managing Your Connection

Once connected, you’ll see:

• Connection status and details (host, user, database)

• List of imported tables

• Option to delete individual tables

✏️ Coming soon: the ability to edit your connection or add more tables later.