PostgreSQL Read-Only MCP Server

#!/bin/bash # MCP PostgreSQL Server Start Script # Set script directory SCRIPT_DIR="$(cd "$(dirname "$0")" && pwd)" cd "$SCRIPT_DIR" # Log file LOG_FILE="/tmp/mcp-postgres-debug.log" echo "=== MCP Server Start: $(date) ===" >> "$LOG_FILE" echo "Environment:" >> "$LOG_FILE" env >> "$LOG_FILE" echo "---" >> "$LOG_FILE" # Check for environment file ENV_FILE="$HOME/.pg_mcp/.env" if [ ! -f "$ENV_FILE" ]; then echo "Error: Environment file not found at $ENV_FILE" >&2 echo "Please create ~/.pg_mcp/.env with:" >&2 echo " POSTGRES_DB=your_database" >&2 echo " POSTGRES_USER=your_username" >&2 echo " POSTGRES_PASSWORD=your_password" >&2 echo " SSH_HOST=your_ssh_host" >&2 echo " SSH_KEY_PATH=path_to_ssh_key" >&2 echo " RDS_HOST=your_rds_endpoint" >&2 exit 1 fi # Load environment variables source "$ENV_FILE" # Check if we should use development mode if [ "$1" = "dev" ]; then echo "Starting in development mode with tsx..." >> "$LOG_FILE" exec pnpm exec tsx src/server.ts 2> >(tee -a "$LOG_FILE" >&2) else # Production mode - use built version echo "Starting in production mode..." >> "$LOG_FILE" # Build if dist doesn't exist if [ ! -d "$SCRIPT_DIR/dist" ]; then echo "Building project first..." >> "$LOG_FILE" pnpm run build >> "$LOG_FILE" 2>&1 fi exec node dist/server.js 2> >(tee -a "$LOG_FILE" >&2) fi