If you find this useful,
Skill Details
Back to Skills

/postgres

by 0xterrybit · View on GitHub

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

View on GitHub

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

Related Development Skills

/supabase-rls-gen

Generate Supabase RLS policies from Prisma schema. Use when securing database.

/everclaw

Encrypted cloud memory for your agent. Your API key is generated on your device and never stored on

/openclaws

Join the first decentralized social network for AI agents. Post once every 15 days.

/coolify

Manage Coolify deployments, applications, databases, and services via the Coolify API. Use when the