database

Create and query PostgreSQL databases in Replit with safety checks.

Updated Feb 9, 2026
One-click install
npx skills add https://github.com/soq123/SE3354-Calo-fit --skill database-soq123
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/soq123/SE3354-Calo-fit/tree/main/.local/skills/database
Command: npx skills add https://github.com/soq123/SE3354-Calo-fit --skill database-soq123

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

  • Check database provisioning with checkDatabase() to confirm readiness.
  • Create or verify a PostgreSQL database with createDatabase(), returning environment variables like DATABASE_URL and PGHOST.
  • Execute SQL safely with executeSql(), supporting targets such as replit_database, bigquery, databricks, and snowflake, with development and production modes and built-in safety guards.
  • Run read-only queries against production replicas and perform data inspection while protecting sensitive operations; can also query data warehouses for analytics.

Quick Start

Ask the AI to check the database status and run a simple 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 query a production PostgreSQL database?

To safely query a production PostgreSQL database, you can run read-only queries against production replicas. This enforces environment isolation and validates parameterized queries to protect sensitive operations while returning structured results.

How do I provision a PostgreSQL database in Replit?

To provision a PostgreSQL database in Replit, you can create and verify the database to confirm readiness. This returns environment variables like DATABASE_URL and PGHOST for connecting your application.

Can I run SQL queries against data warehouses like BigQuery or Snowflake?

Yes, you can run SQL queries against BigQuery, Snowflake, and Databricks. The system supports these data warehouses for analytics while applying built-in safety guards across development and production modes.

Does this database tool enforce environment isolation for development and production?

Yes, the database tool enforces environment isolation for development and production. It supports read-only production access to debug live database issues while protecting sensitive operations through safety checks.

What's the best way to debug live database issues without risking production data?

The best way to debug live database issues without risking production data is to run read-only queries against production replicas. This approach validates parameterized queries and inspects data while enforcing strict environment isolation.