Postgres

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

thinkfleetai 8b809d5 728 B Updated

File contents

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

thinkfleetai/thinkfleet-engine/tree/main/skills/postgres commit 8b809d5381

Frequently asked questions

npx skillmds@latest add thinkfleetai/postgres