Stats
Actions
Tags
'%20stop-opacity%3D'0.16'%2F%3E%3Cstop%20offset%3D'1'%20stop-color%3D'rgb(200%2C90%2C60)'%20stop-opacity%3D'0.03'%2F%3E%3C%2FlinearGradient%3E%3C%2Fdefs%3E%3Crect%20width%3D'320'%20height%3D'200'%20fill%3D'url(%23g)'%2F%3E%3Ccircle%20cx%3D'250'%20cy%3D'56'%20r%3D'92'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.06'%2F%3E%3Ccircle%20cx%3D'64'%20cy%3D'172'%20r%3D'58'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.05'%2F%3E%3C%2Fsvg%3E)
From sundial-org-awesome-openclaw-skills-4
Manages PostgreSQL databases: run SQL queries, manage schemas, optimize indexes, perform backup/restore, monitor performance, and handle extensions.
How this skill is triggered — by the user, by Claude, or both
Slash command
/sundial-org-awesome-openclaw-skills-4:postgresThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
PostgreSQL database management.
PostgreSQL database management.
export DATABASE_URL="postgresql://user:pass@localhost:5432/dbname"
"Show all tables"
"Run query: SELECT * FROM users"
"Create index on email column"
"Show slow queries"
psql "$DATABASE_URL" -c "SELECT * FROM users LIMIT 10"
npx claudepluginhub sundial-org/awesome-openclaw-skillsGuides PostgreSQL operations: schema design, index selection (B-tree/GIN/GiST/BRIN), query tuning (EXPLAIN ANALYZE), backups (pg_dump/pg_basebackup), replication, vacuum tuning, monitoring (pg_stat_statements), RLS, extensions (PostGIS/timescaledb).
Reference guide for psql (PostgreSQL interactive terminal) covering connection methods, backslash commands, database inspection, and data import/export.
PostgreSQL 16+ reference for writing SQL queries (SELECT, CTEs, windows), designing schemas, creating indexes (B-tree, GIN), managing transactions, using JSONB, analyzing with EXPLAIN ANALYZE, and psql CLI.