What problem does it solve?
PostgreSQL databases can be provisioned, monitored, and queried with built-in safeguards to prevent production disruptions, accidental data loss, and misconfigurations.
This skill centralizes database lifecycle tasks, enforces proper access controls, and ensures safe query execution across development and production environments.
Core Features & Use Cases
- Check database provisioning and connectivity with checkDatabase()
- Create or verify a PostgreSQL database with createDatabase()
- Execute SQL queries with safety checks via executeSql(), including environment-aware read-only production mode and warehouse query support
- Run read-only production queries against a replica and operate against development databases with proper safeguards
- Query data warehouses (BigQuery, Databricks, Snowflake) when needed, with explicit guidance on connectors
- Enforce best practices like parameterized queries and query order to avoid destructive changes
Quick Start
Check the database status, then create the database if needed, and run a safe query against the development database.