database

Check PostgreSQL database connectivity by running the checkDatabase function, which verifies provisioning status and confirms the database is reachable across development and production environments. This ensures proper isolation and connectivity before executing queries.

You can execute SQL queries safely in production PostgreSQL using executeSql with read-only access and environment controls. Safety guards prevent destructive operations and Stripe-related mutations, ensuring secure query execution without risking data loss.

Provision a new PostgreSQL database by using the createDatabase function, which creates or verifies a database for your project across development and production environments. It applies environment controls to ensure proper isolation and safe setup.

Safety guards in the executeSql function prevent destructive SQL operations in production environments by enforcing read-only access and blocking Stripe-related mutations. These environment controls ensure unsafe operations are stopped before execution.

Yes, database management supports environment variable visibility, exposing necessary connection variables for apps to connect to the PostgreSQL database. This feature works across development and production environments with proper isolation.