# Skills Postgres

> PostgreSQL 🐘

- Skill: `urjuyaimon09/skills-postgres` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add urjuyaimon09/skills-postgres`
- Raw SKILL.md: https://api.skillmd.com/api/skills/urjuyaimon09/skills-postgres/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: urjuyaimon09 (https://skillmd.com/u/urjuyaimon09)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/urjuyaimon09/skills-postgres

---

PostgreSQL 🐘

PostgreSQL database management.

Setup
export DATABASE_URL="postgresql://user:pass@localhost:5432/dbname"

Features
SQL query execution
Schema management
Index optimization
Backup and restore
Performance monitoring
Extensions management
Usage Examples
"Show all tables"
"Run query: SELECT * FROM users"
"Create index on email column"
"Show slow queries"

Commands
psql "$DATABASE_URL" -c "SELECT * FROM users LIMIT 10"

Safety Rules
ALWAYS confirm before destructive operations
BACKUP before schema changes