🐘

PostgreSQL

Full support including schemas, views, and advanced data types

Connection Settings

Field	Description	Example
Host	Database server hostname or IP	db.example.com
Port	PostgreSQL port (default: 5432)	5432
Database	Database name to connect to	analytics
Schema	Default schema (optional)	public
Username	Database user	dbcraft_user
Password	User password (encrypted at rest)	••••••••

Features

Multiple Schemas

Access all schemas in your database with full navigation

SSL Connections

Secure TLS connections with certificate support

Read Replicas

Connect to read replicas for analytics queries

Connection Pooling

Built-in pooling for efficient resource usage

SSL Modes

Mode	Description
disable	No SSL (not recommended)
require	Require SSL but don't verify certificate
verify-ca	Verify certificate is signed by trusted CA
verify-full	Verify CA and hostname match (recommended)

Recommended Permissions

For read-only analytics, create a dedicated role:

CREATE ROLE dbcraft_reader WITH LOGIN PASSWORD 'secure_password';
GRANT CONNECT ON DATABASE mydb TO dbcraft_reader;
GRANT USAGE ON SCHEMA public TO dbcraft_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO dbcraft_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO dbcraft_reader;