connect
Connect to any PostgreSQL database to check connection status or discover available databases. Supports SSL, AWS Secrets Manager, and automatic instance discovery.
Instructions
Connect to PostgreSQL or check connection status.
LEVEL: Server (connection management)
USE FOR: connecting, checking status, discovering databases. DO NOT USE FOR: health metrics (database_health), queries (execute_query).
ERROR RECOVERY:
"connection refused": Check host/port, ensure PostgreSQL is running
"authentication failed": Verify user/password credentials
"database does not exist": List available databases with discover=True
"SSL required": Add use_ssl=True or check server SSL config
"certificate verify failed": Set ssl_verify=False for SSH tunnels
Examples: connect() - Check status connect(discover=True) - Find databases connect(url='postgresql://user:pass@localhost:5432/mydb')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | PostgreSQL URL | |
| host | No | Database host | |
| port | No | Port (1-65535) | |
| user | No | Username | |
| password | No | Password | |
| database | No | Database name | |
| use_ssl | No | Use SSL | |
| ssl_verify | No | Verify SSL certificates (set False for SSH tunnels) | |
| aws_secret_name | No | AWS Secrets Manager secret | |
| aws_region | No | AWS region | us-west-1 |
| discover | No | Auto-discover PostgreSQL instances | |
| format | No | Output format | json |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |