What problem does it solve? Querying PostgreSQL databases from an AI assistant normally risks accidental writes, credential leaks, and runaway queries. This Skill provides a controlled, read-only query executor that connects to multiple pre-configured databases and blocks all write operations at both the session and validation level. ## Core Features & Use Cases - Read-only enforcement: Uses PostgreSQL readonly session mode plus client-side validation that only allows SELECT, SHOW, EXPLAIN, and WITH statements, and rejects multi-statement queries. - Multi-database support: Configure several databases in connections.json with descriptions, then list them, inspect tables and schemas, and pick the right one for each question. - Built-in safeguards: 30-second query timeout, 10-second connection timeout, 10,000-row cap, column width limits, and credential sanitization in error messages. - Use Case: Ask which database contains order data, list its tables, inspect the schema, and run "SELECT * FROM orders LIMIT 100" to analyze sales data without any risk of modifying production records. ## Quick Start Configure your database credentials in connections.json, then ask the assistant to list the available databases and run a SELECT query against the production database.
