skills.rest
pwv-vc
pwv-vcOFFICIAL
Explore all skills by this author →
Website𝕏@pwventuresGitHub

sql-reader

Query production PostgreSQL databases with read-only credentials.

6|1|Updated Mar 5, 2026
Search Tags:#debugging#production#postgresql#sql#read-only#schema-exploration#data-investigation
One-click install
npx skills add https://github.com/pwv-vc/agentcribs-community --skill sql-reader-pwv-vc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-reader
Source: https://github.com/pwv-vc/agentcribs-community/tree/main/resources/tearsheets/arsenal/dot-claude/skills/sql-reader
Command: npx skills add https://github.com/pwv-vc/agentcribs-community --skill sql-reader-pwv-vc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Query production PostgreSQL databases safely using read-only credentials to enable data exploration, debugging, and analysis without risking data integrity.

Core Features & Use Cases

  • Read-only access to production data for ad-hoc queries and diagnostics
  • Quick schema exploration and data integrity checks
  • Debugging application state and investigating user data or conversations
  • Guided, script-assisted querying with clear safety guardrails

Quick Start

Open an interactive session with the helper script and begin querying production data using the read-only credentials.

Frequently Asked Questions about sql-reader

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

FAQPage Schema
How do I run read-only PostgreSQL queries on production data for debugging?▼

Yes, you can perform schema exploration and data integrity checks on production PostgreSQL databases. The read-only interface restricts access to SELECT queries and diagnostics, ensuring safe ad-hoc data investigation without risking data integrity or modifying records.

How do I investigate user data and application state in a production PostgreSQL database?▼

To query production PostgreSQL databases safely, you need a PostgreSQL client and the arsenal/.env configuration for credentials. The script connect.sh provides a safe, read-only interface to execute targeted SELECT queries and diagnostics.

What are the limitations of using read-only credentials for production data investigation?▼

Read-only credentials limit production data investigation to SELECT queries and diagnostics, preventing any data modification. This constraint ensures data integrity but means you cannot perform updates, inserts, or schema alterations during debugging sessions.

Can I use this script for schema exploration and ad-hoc queries on production systems?▼

Yes, the script supports quick schema exploration and ad-hoc queries on production systems. It provides read-only access to production data, allowing you to safely check data integrity and debug application state using targeted SELECT queries.

Related Skills

Explore More Data & Analytics Skills→
gertrude-appgertrude-app
4

database

Query and analyze the Gertrude PostgreSQL database with read-only access.

Official
Basic
PaparusiPaparusi

log-analyzer

Parse system, web server, and application logs to detect anomalies and security incidents.

Community
Advanced
hongmaple0820hongmaple0820
9

postgres

Run read-only SELECT, EXPLAIN, and SHOW queries across configured PostgreSQL databases.

Community
Intermediate
bouwerpbouwerp

postgres

Execute read-only SQL queries against configured PostgreSQL databases.

Community
Intermediate