skills.rest
Celia-12
Celia-12COMMUNITY
Explore all skills by this author →
GitHub

database

Provision PostgreSQL databases and execute safe SQL queries on Replit.

Updated Feb 17, 2026
Search Tags:#database#postgresql#sql#query#provisioning#replit
One-click install
npx skills add https://github.com/Celia-12/Proyecto-Mern --skill database-celia-12
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/Celia-12/Proyecto-Mern/tree/main/frontend/.local/skills/database
Command: npx skills add https://github.com/Celia-12/Proyecto-Mern --skill database-celia-12

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the difficulty of setting up and interacting with PostgreSQL databases on Replit, eliminating manual provisioning, connection handling, and unsafe query execution.

Core Features & Use Cases

  • checkDatabase() verifies if a PostgreSQL instance is provisioned and reachable.
  • createDatabase() provisions a new database or confirms an existing one, exposing connection environment variables.
  • executeSql() runs safe SQL queries with environment isolation, supporting development and read‑only production modes, as well as data‑warehouse targets.

Use case example: A developer can quickly provision a database, create tables, insert seed data, and run SELECT queries without leaving the Replit environment.

Quick Start

Create the database and retrieve the first five rows from the users table.

Frequently Asked Questions about database

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

FAQPage Schema
How do I provision a PostgreSQL database on Replit?▼

The Skill provisions a PostgreSQL database on Replit using the built-in service, automatically exposing connection environment variables. It eliminates manual setup by handling provisioning, status checks, and safe SQL execution with environment isolation.

Can I run read-only SQL queries against a production PostgreSQL database?▼

Yes, you can run read-only SQL queries against production PostgreSQL databases. The executeSql() function supports environment isolation and read-only production modes, including data-warehouse targets, ensuring safe query execution.

How do I check if my PostgreSQL instance is reachable on Replit?▼

To check if your PostgreSQL instance on Replit is provisioned and reachable, use the checkDatabase() function. It verifies database availability and connection status before you attempt to execute SQL queries.

Does this PostgreSQL Skill support environment isolation for development and production?▼

Yes, the Skill supports environment isolation for PostgreSQL query execution. It separates development and read-only production modes, ensuring that development queries do not impact production data.

What is the best way to manage connection environment variables for PostgreSQL on Replit?▼

The best way to manage connection environment variables is to use the createDatabase() function, which automatically provisions the PostgreSQL database and securely exposes all necessary connection environment variables.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-env-check

Validate database environment variables, SSL mode, pooler config, and PostgreSQL connectivity.

Community
Intermediate
4tie4tie

database

Manage PostgreSQL databases and execute parameterized SQL queries safely.

Community
Advanced
1uc4sm4theus1uc4sm4theus
20

repl_setup

Configure web development servers for the Replit proxy environment.

Community
Intermediate
binan-makerbinan-maker

database

Manage PostgreSQL databases in Replit with safe SQL queries.

Community
Advanced