Postgres Backup Studio

v2.1

Explore, view table records, copy schema, and execute dynamic database-to-database migrations.

PostgreSQL Connection URL

URL Standard format

postgres://username:password@host:port/database?sslmode=require

Credentials are encrypted and processed in server RAM memory only.

Automated Backup Shell Script

#!/bin/bash
# ==============================================================================
# PostgreSQL Full Remote Backup Script
# ==============================================================================

# Your Postgres Connection URL
DB_URL="postgres://user:password@hostname:5432/dbname"

# Generate a timestamped backup filename
TIMESTAMP=$(date +"%Y%m%d_%H%M%S")
OUTPUT_FILE="postgres_backup_${TIMESTAMP}.sql"

echo "Starting database backup..."
echo "Target: ${OUTPUT_FILE}"

pg_dump "${DB_URL}" \
  --clean \
  --if-exists \
  --no-owner \
  --no-privileges \
  --format=plain \
  > "${OUTPUT_FILE}"

if [ $? -eq 0 ]; then
  echo "✅ Backup completed successfully!"
  echo "📁 File saved as: ${OUTPUT_FILE}"
else
  echo "❌ Backup failed."
  exit 1
fi

Connect to your Database

Provide the host details or connection URL on the left panel. You can inspect tables, search schema, and preview rows in real-time.