connect
Connect to a PostgreSQL database or verify an existing connection. Discover available databases by setting the discover parameter.
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 |