OpenSkillIndex← back to search
claude-codeopenclaw

Awesome-openclaw-skills postgres

PostgreSQL database management. Run queries, manage schemas, and monitor performance.

install
source · Clone the upstream repo
git clone https://github.com/sundial-org/awesome-openclaw-skills
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/sundial-org/awesome-openclaw-skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/postgres" ~/.claude/skills/sundial-org-awesome-openclaw-skills-postgres && rm -rf "$T"
OpenClaw · Install into ~/.openclaw/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/sundial-org/awesome-openclaw-skills "$T" && mkdir -p ~/.openclaw/skills && cp -r "$T/skills/postgres" ~/.openclaw/skills/sundial-org-awesome-openclaw-skills-postgres && rm -rf "$T"
manifest: skills/postgres/SKILL.md
source content

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

  1. ALWAYS confirm before destructive operations
  2. BACKUP before schema changes