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

Download postgres

postgres is free and open source. Download it from the official source repository — clone it with git or use GitHub's Download ZIP option on the repo page — then copy the skill folder into your project's .claude/skills/ directory to install it.

If you are an AI agent

Query this directory over HTTP

This site is a searchable directory of harness components for AI coding agents. Fetch objective JSON — names, descriptions, stars, and source links. Installation and selection are yours to decide.

GET https://claudeskills.info/api/v1/search?q=ui%2Fux
GET https://claudeskills.info/api/v1/search?type=subagent&q=review
GET https://claudeskills.info/api/v1/meta
See https://claudeskills.info/llms.txt