skills.rest
Exocore-Organization
Exocore-OrganizationOFFICIAL
Explore all skills by this author →
GitHub

database

A tool for provisioning and managing PostgreSQL databases with configurable workflows and safeguards.

5|21|Updated Jun 12, 2025
Search Tags:#development#database#production#postgresql#safety#sql
One-click install
npx skills add https://github.com/Exocore-Organization/exocore-web --skill database-exocore-organization
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/Exocore-Organization/exocore-web/tree/main/.local/skills/database
Command: npx skills add https://github.com/Exocore-Organization/exocore-web --skill database-exocore-organization

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps developers provision and safely manage PostgreSQL databases for their projects, including status checks and controlled production access.

Core Features & Use Cases

  • Provision new PostgreSQL databases for projects and verify provisioning.
  • Run SQL queries against development databases and perform read-only queries against production replicas.
  • Enforce safety safeguards (no destructive operations in production, environment-variable exposure for secure connections).

Quick Start

Create a development database and run a simple read-only query to verify connectivity.

Frequently Asked Questions about database

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

FAQPage Schema
How do I safely manage PostgreSQL databases across development and production environments?▼

Safely manage PostgreSQL databases by provisioning development instances and running read-only queries against production replicas, enforcing safeguards to disallow destructive changes while exposing secure environment variables for connections.

Can I execute SQL queries against a production PostgreSQL database without risking destructive changes?▼

Yes, you can execute SQL against production by using read-only replicas to run queries, which enforces safety safeguards that disallow destructive operations and guide best practices for secure interactions.

How do I provision a new PostgreSQL database and verify its connectivity?▼

Provision a new PostgreSQL database by creating the instance for your project, validating the provisioning status, and running a simple read-only SQL query to verify database connectivity.

What safeguards are enforced when accessing production PostgreSQL databases?▼

Safeguards for production PostgreSQL databases disallow destructive changes entirely, restrict access to read-only replicas, and require secure environment variable exposure for managing database connections.

Does this approach coordinate PostgreSQL workflows for both development and production?▼

Yes, it coordinates PostgreSQL workflows by provisioning and executing SQL against development databases while applying strict safety checks and read-only validation for production replicas.

Why should I use read-only replicas for production PostgreSQL queries?▼

Use read-only replicas for production PostgreSQL queries to enforce safety safeguards that disallow destructive changes, ensuring database integrity while still allowing necessary data validation and status checks.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-env-check

Validate database environment variables, SSL mode, pooler config, and PostgreSQL connectivity.

Community
Intermediate
Interstellar-codeInterstellar-code
17

sql-cli

Execute SQL queries against MySQL and PostgreSQL databases from the command line.

Community
Advanced
andersnygaardandersnygaard
5

node-backend

Generate Express endpoints with validation and CosmosDB integration.

Community
Intermediate
gigagiovagigagiova

segment-anything-model

Segment objects in images using point, box, or mask prompts with SAM.

Community
Advanced