Are there limits on how much data can be retrieved?

To protect system memory and ensure readability, the skill enforces a maximum limit of 10,000 rows per query and truncates wide columns at 100 characters.

Is this skill safe to use on production databases?

Yes, it is designed for safety. It enforces 'readonly=True' at the connection level, utilizes query validation to block write operations (INSERT, UPDATE, DELETE), and sets a 30-second timeout to prevent long-running queries.

Does it support SSL connections?

Yes, the skill supports various SSL modes including 'require', 'verify-ca', and 'verify-full', ensuring your data is encrypted during transit.

Can I connect to more than one database?

Absolutely. You can configure multiple databases in your connections.json file, each with its own nickname and description. Claude can then use these descriptions to pick the right database for your specific request.

How do I secure my database credentials?

Credentials are stored in a local JSON file. We recommend setting the file permissions to '600' (chmod 600 connections.json) so only your user can read the sensitive connection details.

PostgreSQL Read-Only Query Assistant

Name: PostgreSQL Read-Only Query Assistant
Author: sanjay3290

bysanjay3290

•

Database Management

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases with built-in security protections.

The PostgreSQL Read-Only Query skill empowers Claude to interact with databases securely by enforcing a strictly read-only environment. It allows developers and data analysts to list available databases, inspect table structures, and run complex SELECT queries for data exploration or debugging without the risk of accidental data modification. With features like intelligent database auto-selection based on descriptions, SSL support, and strict query result limits, it serves as a robust bridge between AI coding assistants and live data environments, streamlining the workflow for troubleshooting production issues or verifying application states.

Key Features

01Comprehensive schema exploration and table listing for rapid data structure discovery.

02Strict read-only execution using PostgreSQL's native readonly session mode.

0337 GitHub stars

04Support for multiple database connections with intelligent auto-selection via descriptions.

05Secure credential management with SSL support and localized configuration.

06Safety guardrails including query timeouts, row limits, and write-operation blocking.

Use Cases

01Running ad-hoc SQL queries for metrics, reporting, and data analysis within the development workflow.

02Exploring unfamiliar database schemas to understand table relationships and data types.

03Analyzing production data to troubleshoot application bugs or data inconsistencies.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sanjay3290/ai-skills postgres

For use in Claude.ai and ChatGPT

Download Skill