PostgreSQL Read-Only Query Skill

When to Use

• Use when querying PostgreSQL databases and access must stay strictly read-only
• Use when exploring schemas, tables, and data across multiple configured connections
• Use when you want defense-in-depth protection against accidental INSERT/UPDATE/DELETE or DDL

Execute safe, read-only queries against configured PostgreSQL databases.

Requirements

• Python 3.8+
• psycopg2-binary: pip install -r requirements.txt

Setup

Create connections.json in the skill directory or ~/.config/claude/postgres-connections.json.