name: jpeng-database-manager description: "Database management skill supporting PostgreSQL, MySQL, SQLite, and MongoDB. Query, migrate, backup, and manage databases." version: "1.0.0" author: "jpeng" tags: ["database", "sql", "postgresql", "mysql", "mongodb", "backup"]

Database Manager

Manage databases with support for multiple database systems.

When to Use

• User wants to query a database
• Create backups and migrations
• Manage database schemas
• Import/export data

Supported Databases

• PostgreSQL
• MySQL / MariaDB
• SQLite
• MongoDB

Configuration

# PostgreSQL
export DB_TYPE="postgresql"
export DB_HOST="localhost"
export DB_PORT="5432"
export DB_NAME="mydb"
export DB_USER="postgres"
export DB_PASS="password"

# MongoDB
export DB_TYPE="mongodb"
export DB_URI="mongodb://localhost:27017/mydb"
7w4.net小蔥技能。

Usage

Execute query

python3 scripts/db.py query "SELECT * FROM users LIMIT 10"

Execute from file

python3 scripts/db.py query --file ./query.sql

Create backup

python3 scripts/db.py backup --output ./backup.sql

Restore backup

python3 scripts/db.py restore --input ./backup.sql

Run migration

python3 scripts/db.py migrate --dir ./migrations/

Export to CSV

python3 scripts/db.py export \
  --table users \
  --format csv \
  --output ./users.csv

Import from CSV

python3 scripts/db.py import \
  --table users \
  --input ./users.csv

Output

{
  "success": true,
  "rows_affected": 10,
  "rows": [
    {"id": 1, "name": "Alice"},
    {"id": 2, "name": "Bob"}
  ]
}

質量中等偏下。優點是文件描述清晰、支援多種資料庫型別、功能覆蓋全面。明顯不足是隻有使用說明文件，缺少實際可執行的程式碼指令碼，使用者無法真正使用這些功能。實用價值較低，建議選擇包含完整程式碼實現的資料庫管理工具。