Postgres
Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth security
Install
Quick install
npx skills add https://github.com/sanjay3290/ai-skills/tree/main/skills/postgresnpx skills add sanjay3290/ai-skills --skill postgres --agent claude-codenpx skills add sanjay3290/ai-skills --skill postgres --agent cursornpx skills add sanjay3290/ai-skills --skill postgres --agent codexnpx skills add sanjay3290/ai-skills --skill postgres --agent opencodenpx skills add sanjay3290/ai-skills --skill postgres --agent github-copilotnpx skills add sanjay3290/ai-skills --skill postgres --agent windsurfMore install options
Shorthand — useful for multi-skill repos:
npx skills add sanjay3290/ai-skills --skill postgresManual — clone the repo and drop the folder into your agent's skills directory:
git clone https://github.com/sanjay3290/ai-skills.gitcp -r ai-skills/skills/postgres ~/.claude/skills/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:- Run SQL queries against your PostgreSQL databases in read-only mode
- Explore schemas and table structures
- Analyze data with complex queries and aggregations
- 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 safetyView on GitHub
GitHub Stats
StarsForksLast UpdateAuthorsanjay3290LicenseApache-2.0Version1.0.0Categories
Developer ToolsData-analysisTags
aisecuritycodingdatabaseintegrationFeatures
Related Skills
More from Developer ToolsMySQL Integration
Execute safe read-only SQL queries against MySQL databases with multi-connection support, SSL encryption, and defense-in-depth security79sanjay3290Data-analysisDeveloper Tools00
Microsoft SQL Server Integration
Execute safe read-only queries against MS SQL Server databases with multi-connection support, TLS encryption, and comprehensive security features79sanjay3290Data-analysisDeveloper Tools00
D3.js Visualization
Teaches Claude to produce D3 charts and interactive data visualizations110chrisvoncsefalvayDeveloper ToolsData-analysis00
---
Source: https://github.com/sanjay3290/ai-skills/tree/main/skills/postgres
Author: sanjay3290
License: https://opensource.org/licenses/Apache-2.0
GitHub Stars: 79
Tags: ai, security, coding, database, integration
SKILL.md source
--- name: postgres description: Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth security --- # 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: * Run SQL queries against your PostgreSQL databases in read-only mode * Explore schemas and table structures * Analyze data with complex queries and aggregations * 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 safetyView on GitHub ### GitHub Stats StarsForksLast UpdateAuthorsanjay3290LicenseApache-2.0Version1.0.0 ### Categories Developer ToolsData-analysis ### Tags aisecuritycodingdatabaseintegration ### Features ## Related Skills More from Developer Tools ### MySQL Integration Execute safe read-only SQL queries against MySQL databases with multi-connection support, SSL encryption, and defense-in-depth security 79sanjay3290Data-analysisDeveloper Tools00 ### Microsoft SQL Server Integration Execute safe read-only queries against MS SQL Server databases with multi-connection support, TLS encryption, and comprehensive security features 79sanjay3290Data-analysisDeveloper Tools00 ### D3.js Visualization Teaches Claude to produce D3 charts and interactive data visualizations 110chrisvoncsefalvayDeveloper ToolsData-analysis00 --- **Source**: https://github.com/sanjay3290/ai-skills/tree/main/skills/postgres **Author**: sanjay3290 **License**: https://opensource.org/licenses/Apache-2.0 **GitHub Stars**: 79 **Tags**: ai, security, coding, database, integration
Related skills 6
azure-validate
Pre-deployment validation for Azure readiness. Run deep checks on configuration, infrastructure (Bicep or Terraform), RBAC role assignments, managed identity permissions, and prerequisites before deploying. WHEN: validate my app, check deployment readiness, run preflight checks, verify configuration, check if ready to deploy, validate azure.yaml, validate Bicep, test before deploying, troubleshoot deployment errors, validate Azure Functions, validate function app, validate serverless deployme...
entra-app-registration
Guides Microsoft Entra ID app registration, OAuth 2.0 authentication, and MSAL integration. USE FOR: create app registration, register Azure AD app, configure OAuth, set up authentication, add API permissions, generate service principal, MSAL example, console app auth, Entra ID setup, Azure AD authentication. DO NOT USE FOR: Azure RBAC or role assignments (use azure-rbac), Key Vault secrets (use azure-keyvault-expiration-audit), general Azure resource security guidance.
azure-rbac
Helps users find the right Azure RBAC role for an identity with least privilege access, then generate CLI commands and Bicep code to assign it. Also provides guidance on permissions required to grant roles. WHEN: bicep for role assignment, what role should I assign, least privilege role, RBAC role for, role to read blobs, role for managed identity, custom role definition, assign role to identity, what role do I need to grant access, permissions to assign roles.
azure-compliance
Run Azure compliance and security audits with azqr plus Key Vault expiration checks. Covers best-practice assessment, resource review, policy/compliance validation, and security posture checks. WHEN: compliance scan, security audit, BEFORE running azqr (compliance cli tool), Azure best practices, Key Vault expiration check, expired certificates, expiring secrets, orphaned resources, compliance assessment.
azure-enterprise-infra-planner
Architect and provision enterprise Azure infrastructure from workload descriptions. For cloud architects and platform engineers planning networking, identity, security, compliance, and multi-resource topologies with WAF alignment. Generates Bicep or Terraform directly (no azd). WHEN: 'plan Azure infrastructure', 'architect Azure landing zone', 'design hub-spoke network', 'plan multi-region DR topology', 'set up VNets firewalls and private endpoints', 'subscription-scope Bicep deployment', 'Az...
azure-kubernetes
Plan, create, and configure production-ready Azure Kubernetes Service (AKS) clusters. Covers Day-0 checklist, SKU selection (Automatic vs Standard), networking options (private API server, Azure CNI Overlay, egress configuration), security, and operations (autoscaling, upgrade strategy, cost analysis). WHEN: create AKS environment, provision AKS environment, enable AKS observability, design AKS networking, choose AKS SKU, secure AKS, optimize AKS, rightsize AKS pod, AKS spot nodes, AKS cluste...