database

Manage PostgreSQL databases and run safe SQL queries across environments.

18|4|Updated Apr 3, 2026
One-click install
npx skills add https://github.com/El3tar-cmd/DevHive-Cli --skill database-el3tar-cmd
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/El3tar-cmd/DevHive-Cli/tree/main/skills/database
Command: npx skills add https://github.com/El3tar-cmd/DevHive-Cli --skill database-el3tar-cmd

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

  • checkDatabase(): Check if the PostgreSQL database is provisioned and accessible.
  • createDatabase(): Create or verify a PostgreSQL database exists for the project.
  • executeSql(): Execute a SQL query with safety checks and multiple environments.
  • Safety Features: Environment Isolation, Stripe Protection, Discussion Mode, Destructive Query Protection.
  • Best Practices: Prefer built-in database; check before creating; test queries; backups.

Quick Start

Ask it to check the database status and then run a safe query against the development database using executeSql().

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, the system enforces read-only access and parameterized queries. This environment isolation allows you to check live data and debug issues without risking destructive modifications.

How do I check if my PostgreSQL database is provisioned and accessible?

You can check if your PostgreSQL database is provisioned and accessible by using a status check function. This verifies that the database exists for your project and confirms connectivity before you attempt to execute any SQL queries.

What protections are in place for running destructive SQL queries in development?

Protections for running SQL queries in development include destructive query protection, environment isolation, and discussion mode. These safety constraints ensure parameterized queries are used to prevent accidental data loss during active testing.

Can I execute SQL queries across both development and production environments?

Yes, you can execute SQL queries across development and production environments. The system maintains strict environment isolation, allowing safe query execution in development while enforcing read-only access constraints specifically for production data.

How do I create or verify a PostgreSQL database exists for my project?

You can create or verify a PostgreSQL database exists for your project by using a database creation function. It is recommended to prefer built-in database options and always check the current status before attempting to create a new instance.

What is the best way to debug database issues in a deployed application?

The best way to debug database issues in a deployed application is to run read-only queries against the production database. This allows you to look at live data safely using environment isolation and parameterized query constraints.