← 返回 Skills 市场
51
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install schema-manager
功能描述
Validates migration SQL, analyzes index health, and applies pending schema migrations to the target database
使用说明 (SKILL.md)
Schema Manager
Overview
A unified database schema management tool that validates pending migration SQL, analyzes current indexes for optimization opportunities, and applies pending migrations.
Features
- Migration Validation: Scans
/migrations/for SQL files, validates syntax against the target database. - Index Analysis: Identifies potentially redundant indexes using naming pattern recognition and generates cleanup migrations.
- Migration Execution: Applies all pending migrations (including auto-generated cleanup) in order.
Output Format
{
"migrations_validated": [],
"indexes_analyzed": {"total": 2, "redundant": ["idx_users_email_unique"]},
"migrations_executed": ["003_drop_redundant_indexes.sql"],
"status": "completed"
}
安全使用建议
Install only if you are prepared to audit and modify the script first. Do not run it against production or shared databases as-is; require an explicit dry-run, review generated SQL, confirm the target database, and remove automatic DROP INDEX execution unless a human has approved the exact migration.
能力评估
Purpose & Capability
The stated purpose is schema management, so database access and migration handling are expected, but the implementation automatically treats indexes as redundant by name pattern and drops them, which is high-impact and under-scoped.
Instruction Scope
The skill describes validation, index analysis, and applying migrations, but the script validates pending migrations with rollback behavior while only executing the generated cleanup migration; this can mislead users about what actually ran.
Install Mechanism
The artifact contains only SKILL.md and scripts/manage.py, with no separate install manifest or permission declaration observed.
Credentials
Defaulting to /var/db/app.db and /migrations plus automatic schema mutation is not proportionate without explicit target-environment selection, dry-run mode, or confirmation.
Persistence & Privilege
The script writes a migration file into /migrations and inserts into _migrations after executing generated cleanup SQL, creating persistent schema and migration-state changes.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install schema-manager - 安装完成后，直接呼叫该 Skill 的名称或使用
/schema-manager触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
- Initial release of schema-manager.
- Validates migration SQL files for syntax correctness.
- Analyzes database indexes to identify redundancies and optimization opportunities.
- Generates and applies cleanup migrations for redundant indexes.
- Applies all pending schema migrations in the correct order.
元数据
常见问题
Schema Manager 是什么？
Validates migration SQL, analyzes index health, and applies pending schema migrations to the target database. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 51 次。
如何安装 Schema Manager？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install schema-manager」即可一键安装，无需额外配置。
Schema Manager 是免费的吗？
是的，Schema Manager 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Schema Manager 支持哪些平台？
Schema Manager 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Schema Manager？
由 InkLin（@ink5725）开发并维护，当前版本 v1.0.0。
推荐 Skills