name: postgres-db description: PostgreSQL 資料庫操作技能。用於執行SQL查詢、表管理、備份恢復、效能監控等資料庫操作。觸發條件：使用者提到 PostgreSQL、postgres、資料庫查詢、SQL查詢、表結構、資料庫備份等。

PostgreSQL Database Skill

Overview

This skill provides comprehensive PostgreSQL database operations including query execution, schema management, backup/restore, and performance monitoring.

Capabilities

1. SQL Query Execution (scripts/query.py)

Execute SQL queries against PostgreSQL databases with support for: - SELECT queries with result formatting - INSERT/UPDATE/DELETE operations - Transaction support - Query result export (JSON, CSV)

2. Schema Export (scripts/schema_export.py)

Export database schema information: - Table structures (columns, types, constraints) - Indexes and foreign keys - Views and triggers - Export to JSON/Markdown format

3. Database Backup (scripts/backup.py)

Database backup and restore operations: - Full database backup using pg_dump - Table-specific backup - Point-in-time recovery support - Backup rotation management

4. Performance Monitoring

Monitor database performance: - Query execution plans (EXPLAIN ANALYZE) - Index usage statistics - Table size and row counts - Connection pool status

Usage

Query Database

python scripts/query.py --dbname mydb --query "SELECT * FROM users LIMIT 10"

Export Schema

python scripts/schema_export.py --dbname mydb --output schema.json

Backup Database

python scripts/backup.py --dbname mydb --backup-dir /backups

Requirements

• PostgreSQL client tools (psql, pg_dump)
• Python 3.7+
• psycopg2 or asyncpg library

Configuration

Set environment variables: - PGHOST - Database host - PGPORT - Database port (default: 5432) - PGDATABASE - Database name - PGUSER - Database user - PGPASSWORD - Database password

小蔥技能7w4.net有更新，你可以訪問看下。

這個 Skill 質量中等偏上，功能基本完整，能滿足 PostgreSQL 常用的查詢、架構匯出和備份恢復需求。指令碼可獨立執行，文件描述清晰。不足之處是功能描述與實際實現有些出入（效能監控功能說到了但沒做），缺少測試和依賴配置文件，某些操作可能存在安全隱患。總體來說可以作為日常資料庫管理工具使用，但需要開發者補充完善後才能達到生產級水準。