skills.rest
matheusz-nied
matheusz-niedCOMMUNITY
Explore all skills by this author →
Website𝕏@matheusz_niedGitHub

database

Create and manage PostgreSQL databases with safe SQL queries across environments.

Updated Mar 7, 2026
Search Tags:#development#database#production#postgresql#queries#safety#sql
One-click install
npx skills add https://github.com/matheusz-nied/stay-hard-motivation --skill database-matheusz-nied
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/matheusz-nied/stay-hard-motivation/tree/main/.local/skills/database
Command: npx skills add https://github.com/matheusz-nied/stay-hard-motivation --skill database-matheusz-nied

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL database management and safe SQL querying are essential for development and production workflows; this skill centralizes provisioning, status checks, and guarded query execution to reduce errors and risk.

Core Features & Use Cases

  • Provision and verify PostgreSQL databases across development and production environments with built-in safety rails.
  • Execute SQL queries with validation, including read-only production queries against replicas and cross-warehouse support (BigQuery, Databricks, Snowflake).
  • Manage database credentials and environment variables securely to prevent leaks and unauthorized access.

Quick Start

Check database status with checkDatabase(), create or verify a database with createDatabase() if needed, and run safe queries using executeSql().

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 across development and production environments?▼

Safely run PostgreSQL queries across development and production environments using built-in safety constraints that isolate environments, enforce read-only production queries against replicas, and block destructive operations.

Can I execute read-only SQL queries against production database replicas?▼

Yes, you can execute read-only SQL queries against production database replicas. The system enforces safety constraints that prevent unauthorized or destructive operations while allowing safe data retrieval.

Does this approach support cross-warehouse SQL execution for BigQuery, Databricks, and Snowflake?▼

Yes, cross-warehouse SQL execution supports BigQuery, Databricks, and Snowflake. You can target these multi-warehouse platforms while maintaining environment isolation and safety constraints.

How do I manage database credentials securely to prevent unauthorized access?▼

Manage database credentials securely by handling them via environment variables. This approach prevents credential leaks and unauthorized access during development and production workflows.

What is the best way to provision and verify a PostgreSQL database with safety rails?▼

The best way to provision and verify a PostgreSQL database is to use automated status checks and creation functions that apply safety rails, ensuring proper setup across isolated environments.

What are the limitations when executing SQL queries with validation in production?▼

Limitations when executing SQL queries in production include restrictions against destructive operations and constraints that limit queries to read-only access against replicas to ensure safety.

Related Skills

Explore More Data & Analytics Skills→
1uc4sm4theus1uc4sm4theus
20

database

Provision PostgreSQL databases and execute SQL queries with safety guardrails.

Community
Advanced
GACLoveGACLove
2

sql-queries

Generate SQL queries across PostgreSQL, Snowflake, BigQuery, Redshift, and Databricks dialects.

Community
Basic
jonnabiojonnabio
6

database-operations

Automate database migrations, schema changes, and query optimization.

Community
Advanced
ma-waisma-wais

database

Provision and manage Replit PostgreSQL databases with safe SQL execution.

Community
Advanced