postgres
OfficialRun safe read-only PostgreSQL queries across DBs.
AuthorDedalus-ERP-PAS
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill enables safe, read-only querying across multiple PostgreSQL databases, helping teams explore data without the risk of writes.
Core Features & Use Cases
- Multi-database reach: Connects to several PostgreSQL databases and enables safe, read-only exploration without risking data integrity.
- Schema & table discovery: Lists databases, schemas, and tables to understand data layout for analysis.
- Safe query execution: Runs SELECT queries with strict safety checks, including single-statement enforcement and per-query timeouts.
- Use Case: Audit user tables across production and staging environments to compare row counts without data modification.
Quick Start
List configured databases:
- python3 scripts/query.py --list Query a database:
- python3 scripts/query.py --db production --query "SELECT * FROM information_schema.tables LIMIT 5" --limit 5
Dependency Matrix
Required Modules
psycopg2
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgres Download link: https://github.com/Dedalus-ERP-PAS/foundation-skills/archive/main.zip#postgres Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.