Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.bondata.ai/llms.txt

Use this file to discover all available pages before exploring further.

PostgreSQL is a powerful, open-source relational database known for reliability, extensibility, and standards compliance. With BonData, you can connect directly to your PostgreSQL database to read, enrich, and act on your data within Agent workflows.

​
Database Connection

BonData connects directly to your PostgreSQL database using standard connection credentials.

​
Step 1: Prepare Your Database

Ensure your PostgreSQL server is accessible from BonData’s IP addresses. You may need to:
  1. Configure your firewall to allow connections on port 5432 (or your custom port)
  2. Update pg_hba.conf to allow remote connections
  3. Set listen_addresses in postgresql.conf if needed
For security, create a dedicated read-only user for BonData: 
-- Create a user for BonData
CREATE USER bondata_user WITH PASSWORD 'your_secure_password';

-- Grant connect access to the database
GRANT CONNECT ON DATABASE your_database TO bondata_user;

-- Grant usage on schema
GRANT USAGE ON SCHEMA public TO bondata_user;

-- Grant select on all tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO bondata_user;

-- Grant select on future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT ON TABLES TO bondata_user;

​
Step 3: Gather Connection Details

Collect the following information:
  • Host: Your database server hostname or IP address
  • Port: Usually 5432
  • Database: The name of the database to connect to
  • User: The username created above
  • Password: The password for the user

​
Step 4: Connect in BonData

Enter your connection details in BonData to establish the connection.

​
Required Fields

FieldDescription
HostDatabase server hostname or IP address
PortDatabase server port (default: 5432)
DatabaseName of the database to connect to
UserDatabase username
PasswordDatabase password
BonData supports SSL connections for enhanced security. Contact support if you need to configure SSL certificates.

​
Available Data

Once connected, BonData can sync:
  • Tables - All tables the user has SELECT access to
  • Views - Database views accessible to the user
  • Custom Queries - Run custom SQL queries to extract specific data

RDS in a private VPC?

Learn how to securely connect RDS databases that aren’t publicly accessible.