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
1---2name: skills-postgres3description: PostgreSQL 🐘4---5PostgreSQL 🐘67PostgreSQL database management.89Setup10export DATABASE_URL="postgresql://user:pass@localhost:5432/dbname"1112Features13SQL query execution14Schema management15Index optimization16Backup and restore17Performance monitoring18Extensions management19Usage Examples20"Show all tables"21"Run query: SELECT * FROM users"22"Create index on email column"23"Show slow queries"2425Commands26psql "$DATABASE_URL" -c "SELECT * FROM users LIMIT 10"2728Safety Rules29ALWAYS confirm before destructive operations30BACKUP before schema changes
Run npx skillmds@latest add urjuyaimon09/skills-postgres 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.
PostgreSQL 🐘 It is listed under Coding & Dev Tools on SkillMD.
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.
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.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
urjuyaimon09 (@urjuyaimon09) published this skill. Their other Agent Skills are listed on their SkillMD profile.
urjuyaimon09