Individual skill
database-postgresql
PostgreSQL database inspection and queries. Use when investigating table schemas, running queries, checking locks, replication status, or long-running queries.
sre-agent/.claude/skills/database-postgresql/SKILL.md
Source commit 2323af0551856ff4669b73dc36329d16aa19ed24
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 7, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 178
- Repository last updated
- Nov 7, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- ai-sre Repository topic
- site-reliability-engineering Repository topic
- ai-agent Repository topic
- devops Repository topic
- episodic-memory Repository topic
- incident-investigation Repository topic
- incident-response Repository topic
- knowledge-graph Repository topic
- sre-agent Repository topic
- self-hosted Repository topic
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesSKILL.mdcore · 2,857 bytesscripts/describe_table.pyruns · 3,270 bytesscripts/execute_query.pyruns · 3,109 bytesscripts/get_locks.pyruns · 4,318 bytesscripts/get_long_running_queries.pyruns · 2,212 bytesscripts/get_replication_status.pyruns · 3,711 bytesscripts/get_table_sizes.pyruns · 2,623 bytesscripts/list_indexes.pyruns · 2,671 bytesscripts/list_tables.pyruns · 1,626 bytesscripts/pg_client.pyruns · 1,537 bytes
Read excerpt
# 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)
---
