database

Validate PostgreSQL database provisioning and execute environment-aware SQL queries.

Updated Mar 30, 2026
One-click install
npx skills add https://github.com/rezosnd/MINI-PROJECT- --skill database-rezosnd
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/rezosnd/MINI-PROJECT-/tree/main/ML%20BACKEND%20DASHBOARD/.local/skills/database
Command: npx skills add https://github.com/rezosnd/MINI-PROJECT- --skill database-rezosnd

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill streamlines creating, provisioning, and querying PostgreSQL databases, while enforcing safety checks to prevent destructive actions and unsafe production access.

Core Features & Use Cases

  • Check database provisioning and accessibility
  • Create or verify a PostgreSQL database for the project
  • Execute SQL queries with environment-aware safety (development vs production)
  • Run read-only production queries against replica of production and support data warehouses (BigQuery, Databricks, Snowflake)

Quick Start

Check if the database exists, create it if needed, then execute a safe SQL query to get results.

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I safely run PostgreSQL queries against a production database?

To safely run PostgreSQL queries against a production database, the skill enforces environment-aware safety by restricting access to read-only queries. It blocks mutations and protects critical tables like Stripe data to ensure secure, auditable operations without risking destructive changes.

Can I execute SQL queries on BigQuery, Snowflake, or Databricks data warehouses?

Yes, you can execute SQL queries on BigQuery, Snowflake, or Databricks data warehouses. The skill supports running read-only production queries against replicas of production data and these integrated data warehouses.

How do I verify if a PostgreSQL database is provisioned and accessible?

To verify if a PostgreSQL database is provisioned and accessible, the skill checks the database provisioning status. It identifies existing gaps and can create or verify a PostgreSQL database for your project if one is not found.

What guardrails prevent destructive SQL execution in development environments?

Guardrails preventing destructive SQL execution include mutation blocking, Stripe table protections, and mandatory parameterized queries. These environment-aware checks ensure secure, auditable operations by blocking unsafe mutations before query execution.

How to execute parameterized SQL queries to prevent injection vulnerabilities?

To execute parameterized SQL queries and prevent injection vulnerabilities, the skill enforces parameterized query structures as a built-in guardrail. This ensures all SQL execution remains secure and auditable across both development and production environments.

Why are database mutations blocked during production query execution?

Database mutations are blocked during production query execution to enforce read-only access and prevent destructive actions. This environment-aware safety guardrail ensures that querying replicas or data warehouses remains completely secure and auditable.