dev10x-db-psql

What problem does it solve?

This Skill provides a secure and auditable way to run read-only SQL queries against databases, preventing accidental data modification and ensuring queries are safe for AI execution.

Core Features & Use Cases

• Read-Only Access: Enforces read-only transactions and uses read-only database users or replicas.
• SQL Validation: A pre-execution hook blocks non-SELECT queries (INSERT, UPDATE, DELETE, etc.).
• Configuration Flexibility: Supports database credentials via environment variables or system keyring.
• Use Case: Safely query production database schemas or retrieve specific records for analysis without risking data integrity.

Quick Start

Execute the SQL query 'SELECT * FROM users LIMIT 10;' against the 'my-prod' database.