PostgreSQL Connector

Overview

01. Overview

Plugin Name: PostgreSQL Connector
Category: Database / Data Integration
Authentication: Managed by Mekari Platform

02. Key Features

Connect to external PostgreSQL databases
Secure authentication using database credentials
Support for configurable host and port
Compatible with self-hosted and managed PostgreSQL services
Simple configuration using connection headers
Designed for workflow-driven database operations

03. Supported Use Cases

Read data from PostgreSQL databases
Insert, update, or delete records via workflows
Synchronize data between systems
Power backend automation and integrations
Execute conditional logic based on query results

04. Important Notes

Only PostgreSQL-compatible SQL is supported
The database user must have sufficient permissions for the executed queries
Avoid long-running or heavy queries in time-sensitive workflows
Parameterized queries are recommended when supported to reduce security risks

05. Compatibility

Self-hosted PostgreSQL servers
Managed PostgreSQL services (e.g. cloud providers)
Standard PostgreSQL configurations