How do I install the Database Postgresql skill?

Run npx skillmds@latest add incidentfox/database-postgresql in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Database Postgresql safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Database Postgresql?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Database Postgresql free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Database Postgresql?

incidentfox (@incidentfox) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Database Postgresql by incidentfox — Agent Skill

Name: Database Postgresql
Author: incidentfox

File contents

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]

get_table_sizes.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

get_replication_status.py - Replication Health

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

get_long_running_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 <table> (check index health)
3. describe_table.py --table <table>

---name: database-postgresqldescription: PostgreSQL database inspection and queries. Use when investigating table schemas, running queries, checking locks, replication status, or long-running queries.---# 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 ScriptsAll scripts are in `.claude/skills/database-postgresql/scripts/`### list_tables.py - List Tables (START HERE)```bashpython .claude/skills/database-postgresql/scripts/list_tables.py [--schema public]```### describe_table.py - Table Schema Details```bashpython .claude/skills/database-postgresql/scripts/describe_table.py --table TABLE_NAME [--schema public]```### execute_query.py - Run SQL Queries```bashpython .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```bashpython .claude/skills/database-postgresql/scripts/list_indexes.py [--table TABLE_NAME] [--schema public]```### get_table_sizes.py - Table Size Analysis```bashpython .claude/skills/database-postgresql/scripts/get_table_sizes.py [--table TABLE_NAME] [--schema public]```### get_locks.py - Current Locks & Blocking Queries```bashpython .claude/skills/database-postgresql/scripts/get_locks.py```### get_replication_status.py - Replication Health```bashpython .claude/skills/database-postgresql/scripts/get_replication_status.py```### get_long_running_queries.py - Long-Running Queries```bashpython .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 303. 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 <table> (check index health)3. describe_table.py --table <table>```

Frequently asked questions

Database Postgresql