supabase-connect

Connect to Supabase PostgreSQL using the Node.js pg client with environment-based connection credentials (host, port, user, password, database). Load connection info from .env, disable SSL rejectUnauthorized, and execute raw SQL queries directly through the pg Client connection pool.

You need host, port, user, password, and database name from your Supabase project. Store these in .env and load them at runtime. Supabase also provides pooler URLs for connection pooling and requires IPv4-first DNS handling for WSL environments.

Yes. Write Node.js scripts using the pg client to execute CREATE TABLE, ALTER, DROP, and other DDL statements directly. This allows you to automate table creation, modify schemas, and manage migrations programmatically from environment-based connection strings.

Yes. Supabase requires SSL connections. Configure the pg client with SSL enabled and set rejectUnauthorized to false for development, or use proper certificate handling for production environments.

Write SQL migration scripts executed through the pg client. Load connection info from environment variables, execute raw SQL to create or modify tables, and manage schema changes programmatically as part of your deployment workflow.