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

Ready to run

npx skills add https://github.com/pwv-vc/agentcribs-community --skill sql-reader-pwv-vc

💬 Prompt for ChatGPT / Claude Chat▼

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.