Can I perform write operations like UPDATE or DELETE?

No, this skill is designed exclusively for read-only access. It blocks all write operations (INSERT, UPDATE, DELETE, DROP) at both the query validation level and the database session level.

What happens if a query returns too much data?

To prevent memory issues (OOM) and maintain performance, the skill enforces a maximum limit of 10,000 rows per query and truncates long column values.

Are my database credentials secure?

Yes, credentials are stored locally in your configuration file. The skill recommends setting file permissions to 600 and automatically sanitizes error messages to prevent password leakage.

How does Claude know which database to query?

The skill uses the 'description' field in your connections.json to match your request to the most relevant database. If the intent is unclear, you can list all databases and select one manually.

PostgreSQL Read-Only Explorer

Name: PostgreSQL Read-Only Explorer
Author: prof-ramos

byprof-ramos

•

数据库管理

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases.

The PostgreSQL Read-Only Explorer skill provides a secure way for Claude to interact with your data environments without the risk of accidental modification. It allows for seamless exploration of database schemas, listing of tables, and execution of complex SELECT queries across multiple configured databases. By enforcing connection-level read-only modes, query timeouts, and row limits, this skill ensures that data analysis and schema discovery are performed safely, making it an essential tool for developers and analysts who need to verify database contents or understand data structures during the coding process.

主要功能

01Multi-database support with intelligent auto-selection based on descriptions

02Strict read-only enforcement using PostgreSQL session modes and query validation

03Secure credential handling with SSL support and error message sanitization

04Automated schema and table exploration for rapid data discovery

051 GitHub stars

06Performance safeguards including a 30-second timeout and 10,000-row limit

使用场景

01Exploring database schemas to map out data models for application development

02Verifying data integrity and checking database contents during troubleshooting

03Analyzing production or staging data to generate reports and insights

主要功能

01Multi-database support with intelligent auto-selection based on descriptions

02Strict read-only enforcement using PostgreSQL session modes and query validation

03Secure credential handling with SSL support and error message sanitization

04Automated schema and table exploration for rapid data discovery

051 GitHub stars

06Performance safeguards including a 30-second timeout and 10,000-row limit

使用场景

01Exploring database schemas to map out data models for application development

02Verifying data integrity and checking database contents during troubleshooting

03Analyzing production or staging data to generate reports and insights