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

•

データベース管理

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.

主な機能

Comprehensive schema exploration and table listing for rapid data structure discovery.
Strict read-only execution using PostgreSQL's native readonly session mode.
37 GitHub stars
Support for multiple database connections with intelligent auto-selection via descriptions.
Secure credential management with SSL support and localized configuration.
Safety guardrails including query timeouts, row limits, and write-operation blocking.

ユースケース

Running ad-hoc SQL queries for metrics, reporting, and data analysis within the development workflow.
Exploring unfamiliar database schemas to understand table relationships and data types.
Analyzing production data to troubleshoot application bugs or data inconsistencies.

概要

主な機能

Comprehensive schema exploration and table listing for rapid data structure discovery.
Strict read-only execution using PostgreSQL's native readonly session mode.
37 GitHub stars
Support for multiple database connections with intelligent auto-selection via descriptions.
Secure credential management with SSL support and localized configuration.
Safety guardrails including query timeouts, row limits, and write-operation blocking.

ユースケース

Running ad-hoc SQL queries for metrics, reporting, and data analysis within the development workflow.
Exploring unfamiliar database schemas to understand table relationships and data types.
Analyzing production data to troubleshoot application bugs or data inconsistencies.