PostgreSQL
Category: SQL
Status: good
Connects to a PostgreSQL relational database. Supports full SQL querying, schema browsing, migrations, and data transfer.
Connection Settings
| Field |
Default |
Description |
| host |
localhost |
Server hostname or IP |
| port |
5432 |
TCP port |
| user |
(empty) |
Database username |
| password |
(empty) |
Database password |
| dbname |
(empty) |
Database name |
| url |
(empty) |
Full connection URL (overrides above fields) |
Authentication
Supports three modes (set via authentication field):
- user_password — standard username + password (default)
- secretsmanager — AWS Secrets Manager (requires secret_name + region)
- aws_iam — AWS IAM token authentication
Supported Actions
- execute — run arbitrary SQL queries
- download — export table or query result
- upload — import data from file
- delete — drop tables
- backup — create/restore database backups
- liquibase — Liquibase migration support
- transfer_table — copy table to another connector
- drawing_nodes / dbdiagram — visualize table relationships
- stream_table — stream table data in real time
- python_description / django_description / sqlalchemy_description — generate ORM model code
- generate_ddl / generate_cascade_ddl — generate CREATE TABLE DDL
External Links
- https://www.postgresql.org/docs/
- https://jdbc.postgresql.org/