database

Create and manage PostgreSQL databases with safe SQL queries for development and production.

Updated Mar 28, 2026
One-click install
npx skills add https://github.com/lostitonce420-beep/novaura.life-official --skill database-lostitonce420-beep
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/lostitonce420-beep/novaura.life-official/tree/main/The-Gilded-Cage/.local/skills/database
Command: npx skills add https://github.com/lostitonce420-beep/novaura.life-official --skill database-lostitonce420-beep

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Create and manage PostgreSQL databases and run safe SQL queries for development and production environments.

Core Features & Use Cases

  • Provision and verify PostgreSQL databases for development and production environments
  • Safely execute SQL queries with environment isolation, parameterization guidance, and safety rules
  • Read-only production queries against a replica and debugging access to live data when appropriate
  • Query multiple data stores (e.g., BigQuery, Databricks, Snowflake) as optional use cases

Quick Start

Check the database provisioning with a health check, create it if necessary, then run a sample SQL query to verify the setup.

Frequently Asked Questions about database

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

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

To run safe SQL queries against a production PostgreSQL database, use built-in safety layers that enforce read-only access and block destructive operations. This allows you to debug live data safely without risking accidental modifications.

What's the best way to provision and verify a new PostgreSQL database for development?

The best way to provision and verify a PostgreSQL database for development is to run a health check, create the database if necessary, and execute a sample SQL query. This verifies setup and confirms accessibility for your environment.

Does this PostgreSQL database management approach support querying multiple data stores?

Yes, this PostgreSQL database management approach supports querying multiple data stores as optional use cases. You can extend safe SQL query execution to platforms including BigQuery, Databricks, and Snowflake.

How do I prevent destructive operations when debugging PostgreSQL databases?

To prevent destructive operations when debugging PostgreSQL databases, apply safety rules that automatically block dangerous commands. These safety layers ensure environment isolation and parameterization during live data access.

Do I need specific environment variables to manage PostgreSQL database credentials?

Yes, you need specific environment variables to manage PostgreSQL database credentials safely. The system provides clear guidance on configuring these variables to isolate development and production environments securely.