Dev10x:db-psql

To run read-only SQL queries safely, this Skill enforces connection-level read-only permissions and pre-execution validation, blocking non-SELECT statements before they reach psql. It ensures your PostgreSQL database operations remain safe and auditable.

Yes, you can execute PostgreSQL queries within Claude Code without risking data modification. The Skill acts as a secure wrapper, allowing only SELECT, WITH (CTEs), EXPLAIN, and SHOW queries while blocking any data modification statements.

To execute ad-hoc SQL queries with Claude Code, you need psql and Python installed in your environment. These dependencies are required to run the read-only validation and query execution scripts against your PostgreSQL database.

The best way to prevent runaway queries is to use a Skill that implements built-in timeouts and error handling. This approach automatically terminates long-running PostgreSQL queries and provides clear error messages to ensure database stability.

Yes, this PostgreSQL query wrapper supports schema discovery and query planning. It integrates directly with the Dev10x:db Skill to help you plan queries and discover database schemas securely within Claude Code.

The read-only validation blocks all non-SELECT statements, including INSERT, UPDATE, DELETE, and other data modification commands. It ensures only SELECT, WITH (CTEs), EXPLAIN, and SHOW queries reach your PostgreSQL database via psql.