domains / families / data / postgres-readonly-queries

postgres-readonly-queries

separate

Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth write protection.

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

When not to use

• Read-only protections reduce accidental writes but cannot override database-server policy,
• Query results can contain personal, confidential, or regulated data. Confirm the intended
• The script is not a replacement for backups, auditing, access reviews, or production change

Skill page

Source