db-env-check

To validate database environment variables for secure PostgreSQL connections, check for required variables like `SUPABASE_DB_URL`, verify SSL mode, confirm pooler configuration, and test connectivity to ensure credentials and network accessibility are correct.

Yes, checking database connectivity requires PostgreSQL client tools installed. You need `psql` and `pg_dump` accessible in your environment to verify tooling and establish a secure database connection successfully.

Required environment variables to establish a secure database connection include `SUPABASE_DB_URL`. Additionally, SSL mode and pooler configuration variables are validated to ensure secure and properly configured database operations.

Database migration scripts fail due to configuration errors when environment variables are missing, SSL mode is incorrect, or PostgreSQL client tools are inaccessible. Validating your database environment preemptively catches these connectivity and credential issues.

Yes, you can test database network accessibility before running data import scripts by establishing a test connection. This verifies credentials, checks SSL mode, and confirms pooler configuration to ensure a stable database environment.

The best way to verify SSL mode and pooler configuration for database security is to run a validation check that inspects these settings alongside required environment variables and PostgreSQL client tool availability before connecting.