query-postgres
CommunityExplore PostgreSQL schemas with read-only queries
Authorclouseryan
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This skill helps DevOps and data engineers quickly understand database structures by listing schemas, tables, and keys, and by running safe read-only queries against PostgreSQL databases.
Core Features & Use Cases
- Inspect schemas and metadata: view databases, schemas, tables, columns, primary keys, indexes, and foreign keys.
- Execute read-only queries: run SQL statements and receive results in table or JSON formats for rapid analysis.
- Use cases span development, testing, and production readiness tasks such as schema discovery, data validation, and ad-hoc data exploration.
Quick Start
Connect to a PostgreSQL database and list its schema objects or run a sample read-only query.
Dependency Matrix
Required Modules
psycopg2psycopg2.extras
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: query-postgres Download link: https://github.com/clouseryan/agentic-skills/archive/main.zip#query-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 471,000+ vetted skills library on demand.