skills.rest
lidge-jun
lidge-junCOMMUNITY
Explore all skills by this author →
𝕏@claudeebumGitHub

postgres

Execute read-only SQL queries against configured PostgreSQL databases.

5|Updated Feb 26, 2026
Search Tags:#database#sql#query#data exploration#read-only#postgres
One-click install
npx skills add https://github.com/lidge-jun/cli-jaw-skills --skill postgres-lidge-jun
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres
Source: https://github.com/lidge-jun/cli-jaw-skills/tree/main/postgres
Command: npx skills add https://github.com/lidge-jun/cli-jaw-skills --skill postgres-lidge-jun

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2-binary, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill allows you to safely execute read-only SQL queries against multiple PostgreSQL databases, making data exploration and analysis straightforward and secure.

Core Features & Use Cases

  • Read-only Access: Ensures no data modification by enforcing read-only sessions.
  • Multi-database Support: Connect to and query various PostgreSQL instances using a configuration file.
  • Query Validation: Restricts queries to safe operations like SELECT, SHOW, and EXPLAIN.
  • Use Case: You need to retrieve user data from a production PostgreSQL database for a report. This Skill can connect to the database, list tables, show schemas, and execute your SELECT query without any risk of accidental data modification.

Quick Start

Use the postgres skill to list all available databases.

Frequently Asked Questions about postgres

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

FAQPage Schema
How do I run read-only SQL queries against a PostgreSQL database?▼

To run read-only SQL queries against a PostgreSQL database, you can use this Skill to enforce write protection and restrict operations to safe statements like SELECT, SHOW, and EXPLAIN for secure data retrieval.

Can I query multiple PostgreSQL connections without risking accidental data modification?▼

Yes, you can query multiple PostgreSQL connections safely because this Skill enforces read-only sessions and query validation across all configured databases to prevent any accidental data modification.

Does this tool support listing schemas and tables for PostgreSQL data exploration?▼

Yes, this tool supports PostgreSQL data exploration by allowing you to connect to configured databases, list available tables, show schemas, and execute safe SELECT queries without risking data modification.

What safe SQL operations are allowed when querying PostgreSQL with this approach?▼

The safe SQL operations allowed when querying PostgreSQL include SELECT, SHOW, and EXPLAIN, ensuring that query validation restricts any operations attempting to modify the database.

How does it handle long-running SQL queries during PostgreSQL data exploration?▼

It handles long-running SQL queries during PostgreSQL data exploration by enforcing configurable timeouts and memory caps, ensuring safe and controlled data retrieval without overwhelming resources.

Related Skills

Explore More Data & Analytics Skills→
jeremylongshorejeremylongshore
2.6k

managing-database-replication

Configure master-slave replication and automatic failover for PostgreSQL and MySQL deployments.

Community
Advanced
semantica-agisemantica-agi
3.0k

export

Export knowledge graph data and provenance to JSON, RDF, Parquet, CSV, and GraphML.

Official
Intermediate
Happy-Technologies-LLCHappy-Technologies-LLC
34

data-import

Automate ServiceNow data imports using Import Sets and Transform Maps.

Official
Advanced
Devvraj10Devvraj10

database

Manage PostgreSQL databases and execute SQL queries with safety checks.

Community
Intermediate