​
Overview

The Postgres integration enables your agents to directly interact with PostgreSQL databases. This allows agents to query data, analyze results, and provide insights from your database while maintaining security and performance best practices.

​
Features

  • SQL Query Execution: Run any SQL query on your Postgres database
  • Row Limit Protection: Automatic limit of 100 rows per query to prevent performance issues
  • Result Formatting: Clean, structured table format for query results
  • Error Handling: Built-in error handling for common SQL issues
  • Type Safety: Automatic type conversion and validation

​
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
  • Port: Database port (default: 5432)
  • Database: Name of the database
  • Username: Database user credentials
  • Password: User’s password
  • SSL Mode: Your preferred SSL configuration
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 database users when possible
  • Enable SSL for secure data transmission
  • Implement column-level access controls
  • Consider using connection pooling for production deployments
  • Regularly rotate database credentials

​
Troubleshooting