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"

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

小葱技能站7w4.net每天更新，海量AI技能等你发现。

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"}
  ]
}

质量中等偏下。优点是文档描述清晰、支持多种数据库类型、功能覆盖全面。明显不足是只有使用说明文档，缺少实际可运行的代码脚本，用户无法真正使用这些功能。实用价值较低，建议选择包含完整代码实现的数据库管理工具。