​
Overview

The Postgres integration enables your agents to query and analyze data in your PostgreSQL database. Perfect for data analysis, reporting, and extracting insights from your relational data while maintaining security and performance best practices.

​
Features

  • SQL Query Execution: Run any SQL query on your PostgreSQL database
  • Performance Protection: Automatic 100-row limit to prevent performance issues
  • Clean Results: Structured, easy-to-read query results
  • Error Handling: Built-in handling for common SQL errors and issues
  • Type Safety: Automatic data type conversion and validation
  • Secure Connections: SSL support for encrypted data transmission

​
Prerequisites

  • PostgreSQL database (version 9.4 or higher)
  • Database user credentials with appropriate permissions
  • Network access to your database server
  • SSL configuration (if required by your security policies)

​
Setup Guide

1

Enable Postgres Integration

Navigate to Control Hub > Integrations and locate the Postgres card. Click “Connect” to begin setup.

2

Configure Connection

Provide your database connection details:

  • Host: Your database server hostname or IP address
  • Port: Database port number (default: 5432)
  • Database: Name of the database to connect to
  • Username: Database user for authentication
  • Password: Password for the database user
  • SSL Mode: SSL configuration (disable, allow, prefer, require, verify-ca, verify-full)
3

Test Connection

Click “Test Connection” to verify your configuration. The system will attempt to connect and run a simple test query.

​
Security Considerations

  • Use read-only users when possible to prevent data modification
  • Enable SSL encryption for secure data transmission
  • Implement access controls to limit which tables agents can access
  • Use connection pooling for production deployments
  • Rotate credentials regularly and use strong passwords
  • Monitor query activity for unusual or unauthorized access
  • Limit network access using firewalls and IP restrictions

​
Troubleshooting

  • Postgres SQL - Execute SQL queries on your PostgreSQL database