p

postgres

Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth security

What is it?

A skill for executing safe, read-only SQL queries against PostgreSQL databases. It supports multiple database connections, implements defense-in-depth security measures, and provides query result formatting. Designed for data analysis, reporting, and database exploration without risk of accidental data modification.

How to use it?

Configure your PostgreSQL connection string(s), then use the skill to:

  1. Run SQL queries against your PostgreSQL databases in read-only mode
  2. Explore schemas and table structures
  3. Analyze data with complex queries and aggregations
  4. Format results for reports and presentations

All queries are executed in read-only transactions with multiple layers of security to prevent any data modifications.

Key Features

  • Read-only SQL query execution with defense-in-depth security
  • Multi-connection support for querying multiple databases
  • Schema exploration and table structure analysis
  • Query result formatting for reports and presentations
  • Transaction-level read-only enforcement for data safety
View on GitHub

GitHub Stats

Stars
Forks
Last Update
License
Apache-2.0
Version
1.0.0

Features