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

•

Database Management

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

About

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.

Key Features

Multi-database support with intelligent auto-selection based on descriptions
Strict read-only enforcement using PostgreSQL session modes and query validation
Secure credential handling with SSL support and error message sanitization
Automated schema and table exploration for rapid data discovery
1 GitHub stars
Performance safeguards including a 30-second timeout and 10,000-row limit

Use Cases

Exploring database schemas to map out data models for application development
Verifying data integrity and checking database contents during troubleshooting
Analyzing production or staging data to generate reports and insights

About

Key Features

Multi-database support with intelligent auto-selection based on descriptions
Strict read-only enforcement using PostgreSQL session modes and query validation
Secure credential handling with SSL support and error message sanitization
Automated schema and table exploration for rapid data discovery
1 GitHub stars
Performance safeguards including a 30-second timeout and 10,000-row limit

Use Cases

Exploring database schemas to map out data models for application development
Verifying data integrity and checking database contents during troubleshooting
Analyzing production or staging data to generate reports and insights