Agent skill · data analytics · sickn33
postgres-readonly-queries
Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth write protection.
Why this skill is useful
Provides specific commands and configurations for safely executing read-only SQL queries against PostgreSQL databases, which the AI wouldn't reliably generate on its own.
What it needs
Requires psycopg2-binary, python installed locally. About 3k tokens when loaded. Last updated 2026-08-07. 44,571 stars on the source repository.
What this skill does
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. Security: Set file permissions to 600 since it contains credentials: Config Fields Field Required Description ------- ---------- ------------- name Yes Identifier for the database (case-insensitive) description Yes What data this database contains (used for auto-selection) host Yes Database hostname port No Port number (default: 5432) database Yes Database name user Yes Username password Yes Password sslmode No SSL mode: disable, allow, prefer (default), require, verify-ca, verify-full Usage List configured databases Query a database List tables Show schema Limit results Database Selection Match user intent to database description: User asks about Look for description containing ----------------- -------------------------------- users, accounts users, accounts, customers orders, sales orders, transactions, sales analytics, metrics analytics, metrics, reports logs, events logs, events, audit If unclear, run --list and ask user which database. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills sickn33/postgres-readonly-queries