database

Manage PostgreSQL databases and execute safe SQL queries across environments.

1|Updated Aug 24, 2025
One-click install
npx skills add https://github.com/Pixoraft/KirpalSecure-site --skill database-pixoraft
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/Pixoraft/KirpalSecure-site/tree/main/.local/skills/database
Command: npx skills add https://github.com/Pixoraft/KirpalSecure-site --skill database-pixoraft

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the creation, management, and querying of PostgreSQL databases, ensuring safe and efficient data operations across development and production environments.

Core Features & Use Cases

  • Database Provisioning: Create or verify PostgreSQL databases for your Replit projects.
  • SQL Query Execution: Safely run SQL queries against development databases and read-only queries against production replicas.
  • Data Warehousing Access: Query data from BigQuery, Databricks, and Snowflake.
  • Use Case: You need to create a new database for your web application, insert some initial user data, and then query that data to display it on a webpage.

Quick Start

Use the database skill to create a new PostgreSQL database for your project.

Frequently Asked Questions about database

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

FAQPage Schema
How do I manage PostgreSQL databases in Replit?

You can manage PostgreSQL databases by provisioning new instances, checking status, and executing SQL queries directly within your Replit development environment. It handles creation and safe query execution for both development and production setups.

Can I run SQL queries against a production database safely?

Yes, you can run SQL queries against production safely. The system enforces strict safety checks for production queries, routes them to read-only replicas, and blocks mutations on sensitive tables to prevent accidental data corruption.

Does this support querying data warehouses like BigQuery, Databricks, and Snowflake?

Yes, querying data warehouses like BigQuery, Databricks, and Snowflake is supported. You can extract data from these platforms using SQL with optional sampling to limit the returned rows for development and analysis.

How do I create a new PostgreSQL database for my web application?

To create a new PostgreSQL database, you use the database provisioning feature to instantly spin up an instance for your web application. This allows you to quickly insert initial data and query it for display.

What are the limitations when executing mutations on sensitive tables?

The primary limitation is that mutations on sensitive tables are strictly blocked. The system prevents destructive actions by enforcing safety checks on production environments, ensuring only safe, verified queries are executed.