skills.rest
Soufianouassif
SoufianouassifCOMMUNITY
Explore all skills by this author →
GitHub

database

Provision and manage PostgreSQL databases with environment isolation and read-only production queries.

Updated Apr 6, 2026
Search Tags:#development#database#production#postgresql#queries#safety#sql
One-click install
npx skills add https://github.com/Soufianouassif/Web3-Presale-Platform --skill database-soufianouassif
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/Soufianouassif/Web3-Presale-Platform/tree/main/.local/skills/database
Command: npx skills add https://github.com/Soufianouassif/Web3-Presale-Platform --skill database-soufianouassif

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Create and manage Replit's built-in PostgreSQL databases, check status, execute SQL queries with safety checks, and run read-only queries against the production database. Use when the user wants to check prod data, debug database issues in production, or asks to "check the prod db", "query production", "look at live data", or "see what's in the database on the deployed app".

Core Features & Use Cases

  • Create and verify PostgreSQL databases for a project.
  • Check database provisioning and accessibility.
  • Execute SQL queries with safety checks and environment isolation (development vs production), including read-only production queries and restricted data warehouse queries when using supported targets.

Quick Start

Create a new PostgreSQL database for the project and run a sample SELECT 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 execute SQL queries against a production PostgreSQL database?▼

Safely execute SQL queries against a production PostgreSQL database by running read-only queries against replicas with environment isolation and destructive operation protections. This ensures live data remains protected while allowing debugging and verification.

How do I provision a PostgreSQL database for development and production environments?▼

Provision a PostgreSQL database for development and production environments by creating the database instance and verifying provisioning status and accessibility. Environment isolation ensures operations remain separated between development and production contexts.

Can I run data-warehousing queries on a PostgreSQL replica without affecting production?▼

Run data-warehousing queries on supported PostgreSQL targets without affecting production by using restricted read-only access against replicas. Environment isolation and destructive operation protections maintain safety while executing analytical queries.

What safety checks are applied when executing queries on a PostgreSQL database?▼

Safety checks applied when executing PostgreSQL queries include environment isolation, destructive operation protections, and read-only production access against replicas. Clear feedback is provided through environment variables and operation results for auditable management.

Does this database management approach support checking provisioning status for a deployed app?▼

Checking database provisioning status for a deployed app is supported by verifying PostgreSQL database accessibility and provisioning state. This allows users to confirm the database is ready before executing queries or debugging live data issues.

What are the limitations when querying production PostgreSQL databases with safety checks?▼

Limitations when querying production PostgreSQL databases with safety checks include enforced read-only access against replicas and restricted data-warehousing queries to supported targets. Destructive operations are blocked to prevent accidental data loss in production environments.

Related Skills

Explore More Software Engineering Skills→
alyamenfactoryalyamenfactory

database

Create, check, and query PostgreSQL databases with SQL.

Community
Advanced
husniadilhusniadil
1

database

Explore database schemas before executing CRUD operations and migrations.

Community
Advanced
Interstellar-codeInterstellar-code
17

sql-cli

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

Community
Advanced
Mo7amed-MahmoudMo7amed-Mahmoud

database

Provision and query PostgreSQL databases with safety controls.

Community
Advanced