skills.rest
Buntyarora97
Buntyarora97COMMUNITY
Explore all skills by this author →
GitHub

database

Automate PostgreSQL database creation, status checks, and safe SQL execution.

Updated Apr 8, 2026
Search Tags:#database#sql#query#postgres#db management
One-click install
npx skills add https://github.com/Buntyarora97/bcshdbchjdb --skill database-buntyarora97
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/Buntyarora97/bcshdbchjdb/tree/main/.local/skills/database
Command: npx skills add https://github.com/Buntyarora97/bcshdbchjdb --skill database-buntyarora97

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This skill provides a comprehensive set of tools for creating, managing, and querying PostgreSQL databases directly from within your codebase, simplifying the database management process for development and production scenarios.

Core Features & Use Cases

  • Database Creation: Simplify the creation and verification of PostgreSQL databases for your projects.
  • Status Check: Easily check the provisioning status and accessibility of PostgreSQL databases.
  • SQL Execution: Safely execute SQL queries against both development and production databases with robust checks.
  • Read-only Production Queries: Execute SELECT queries against a read replica of the production database for read-only access.
  • Use Case: Suppose you are building an e-commerce application and need to verify user account information against the live database before making any updates. This skill would allow you to check the user status without the risk of affecting the database during high-traffic times.

Quick Start

Execute the 'createDatabase()' function to set up your PostgreSQL database environment.

Frequently Asked Questions about database

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

FAQPage Schema
How do I automate PostgreSQL database creation and status checks?▼

Automating PostgreSQL database creation involves calling a dedicated function to provision the database and verify its accessibility status. This skill streamlines the process by safely setting up environments and confirming provisioning through automated psql commands.

What is the safest way to execute SQL queries against a production PostgreSQL database?▼

Executing SQL queries safely against production PostgreSQL involves using read-only replicas for SELECT statements. This skill provides environment isolation and safety checks to prevent destructive actions while querying live data without impacting high-traffic operations.

Can I run read-only SQL queries on a PostgreSQL read replica for dev and production environments?▼

Yes, you can run read-only SQL queries on a PostgreSQL read replica. This skill isolates development and production environments, allowing you to safely execute SELECT statements against live data without risking accidental modifications to the primary database.

How do I prevent destructive SQL actions when managing PostgreSQL databases?▼

Preventing destructive SQL actions requires built-in safety checks before executing commands. This skill automatically validates queries and isolates dev and production environments, ensuring that harmful operations are blocked before interacting with your PostgreSQL databases.

Does this PostgreSQL database management approach work for both development and production isolation?▼

Yes, this approach works for both development and production isolation. The skill separates environments completely, enabling safe execution of dev queries and read-only prod queries using psql, ensuring development actions never impact the live production database.

Related Skills

Explore More Software Engineering Skills→
huydepzai121huydepzai121
3

postgresql-psql

Execute PostgreSQL psql commands for connections, queries, and administration.

Community
Intermediate
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
PaldomPaldom
11

databricks-lakebase-provisioned

Provision Lakebase Provisioned OLTP databases for Databricks Apps.

Community
Advanced
kubiyabotkubiyabot
16

postgres

Run PostgreSQL queries and admin tasks via the psql CLI.

Official
Advanced