AgentStack
Browse Sign in
Browse Why AgentStack Sell Docs
Sign in
SKILL verified Apache-2.0 Self-run

Database Postgresql

skill-swapnildahiphale-opensre-database-postgresql · by swapnildahiphale

PostgreSQL database inspection and queries. Use when investigating table schemas, running queries, checking locks, replication status, or long-running queries.

↗ Website ↗ Repository
— No reviews yet
0 installs
45 views
0.0% view→install

Install

$ agentstack add skill-swapnildahiphale-opensre-database-postgresql

✓ scanned · ✓ verified, works with Claude Code, Cursor, and more.

Security review

✓ Passed

No issues found. Passed automated security review. · v0.1.0 How review works →

  • ✓ Prompt-injection patterns
  • ✓ Secret / credential exfiltration
  • ✓ Dangerous shell & filesystem operations
  • ✓ Untrusted network calls
  • ✓ Known-malicious package signatures

What it can access

  • ✓ Network access No
  • ✓ Filesystem access No
  • ✓ Shell / process execution No
  • ✓ Environment & secrets No
  • ✓ Dynamic code execution No

From automated source analysis of v0.1.0. “Used” means the capability is present in the source — more access means more to trust, not that it’s unsafe.

View the full security report →

Verified badge

Passed review? Show it. Paste this badge into your README, it links to the public security report.

AgentStack Verified badge Links to your public security report.
[![AgentStack Verified](https://agentstack.voostack.com/badges/verified.svg)](https://agentstack.voostack.com/security/report/skill-swapnildahiphale-opensre-database-postgresql)

Reliability & compatibility

✓ Security review passed
0 installs to date
— no reviews yet
● 3mo ago

Declared compatibility

Claude CodeClaude Desktop

Compatibility is declared by the source manifest. End-to-end runtime verification is coming, see below.

Preview Execution monitoring

We're building live execution health for every listing: tool-call success rate, median latency, uptime, and last-checked timestamps, measured, not self-reported. It isn't live yet, so we don't show numbers we can't stand behind.

How agent discovery & health will work →
Are you the author of Database Postgresql? Claim this listing to set pricing, connect Stripe payouts, and keep 70% of every sale.
Sign up to claim

About

PostgreSQL Database

Authentication

IMPORTANT: Credentials are injected automatically by a proxy layer. Do NOT check for POSTGRES_PASSWORD in environment variables - it won't be visible to you. Just run the scripts directly; authentication is handled transparently.

Configuration environment variables you CAN check (non-secret):

  • POSTGRES_HOST - Database host
  • POSTGRES_PORT - Database port (default: 5432)
  • POSTGRES_DATABASE - Database name
  • POSTGRES_SCHEMA - Default schema (default: public)

MANDATORY: Schema-First Investigation

Understand the schema before running queries.

LIST TABLES → DESCRIBE TABLE → EXECUTE QUERY → CHECK HEALTH

Available Scripts

All scripts are in .claude/skills/database-postgresql/scripts/

list_tables.py - List Tables (START HERE)

python .claude/skills/database-postgresql/scripts/list_tables.py [--schema public]

describe_table.py - Table Schema Details

python .claude/skills/database-postgresql/scripts/describe_table.py --table TABLE_NAME [--schema public]

execute_query.py - Run SQL Queries

python .claude/skills/database-postgresql/scripts/execute_query.py --query "SELECT * FROM users WHERE created_at > now() - interval '1 hour'" [--limit 100]

list_indexes.py - Index Information

python .claude/skills/database-postgresql/scripts/list_indexes.py [--table TABLE_NAME] [--schema public]

gettablesizes.py - Table Size Analysis

python .claude/skills/database-postgresql/scripts/get_table_sizes.py [--table TABLE_NAME] [--schema public]

get_locks.py - Current Locks & Blocking Queries

python .claude/skills/database-postgresql/scripts/get_locks.py

getreplicationstatus.py - Replication Health

python .claude/skills/database-postgresql/scripts/get_replication_status.py

getlongrunning_queries.py - Long-Running Queries

python .claude/skills/database-postgresql/scripts/get_long_running_queries.py [--min-duration 60]

Investigation Workflow

Lock Contention

1. get_locks.py (find blocking relationships)
2. get_long_running_queries.py --min-duration 30
3. execute_query.py --query "SELECT * FROM pg_stat_activity WHERE state = 'active'"

Replication Lag

1. get_replication_status.py (check lag_bytes/lag_seconds)
2. get_long_running_queries.py (queries blocking replication)

Table Growth Investigation

1. get_table_sizes.py (find largest tables)
2. list_indexes.py --table  (check index health)
3. describe_table.py --table

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

Install and usage instructions live in the source repository linked above.

Reviews

No reviews yet, be the first.

Write a review

Versions

  • v0.1.0 Imported from the upstream source.

More in Databases