database

To check if your PostgreSQL database is provisioned, use the checkDatabase function to verify connectivity and accessibility. It returns status details confirming whether the database is reachable and ready for query execution.

Safely execute SQL queries against production PostgreSQL using the executeSql function. It enforces strict query controls and safety protections that prevent destructive operations and data leakage during read-only production queries.

Create a PostgreSQL database and retrieve its environment variables using the createDatabase function. It safely creates or verifies the database instance and returns configuration details for immediate application integration.

Yes, you can run SQL queries on development and production contexts separately using executeSql. It supports deterministic query execution across development and production read replicas, including dedicated targets for data warehouses.

Protections against destructive SQL operations in production include strict query controls enforced during executeSql execution. These safety protections prevent unsafe changes and data leakage when validating prod data accessibility or debugging live database issues.