p

postgres

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

Home/Dev/postgres

WhatIsIt

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.

HowToUse

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.

KeyFeatures

  • 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
ViewOnGitHub

GithubStats

Stars
Forks
LastUpdate
License
Apache-2.0
Version
1.0.0

Categories

Dev
Data-analysis

Tags

ai
security
coding
database
integration

Features

RelatedSkills

MoreFrom