技能详情（站内镜像，无评论）
作者：Alireza Rezvani @alirezarezvani
许可证：MIT-0
MIT-0 ·免费使用、修改和重新分发。无需归因。
版本：v2.1.1
统计：⭐ 0 · 795 · 12 current installs · 12 all-time installs
⭐ 0
安装量（当前） 12
🛡 VirusTotal ：良性 · OpenClaw ：良性
Package：alirezarezvani/database-designer
安全扫描（ClawHub）
- VirusTotal ：良性
- OpenClaw ：良性
OpenClaw 评估
The skill's requested resources and runtime instructions match a database-design toolkit; nothing in the manifest or SKILL.md suggests unrelated privileges or secret access, but the bundled Python scripts were not fully visible so a code-level review is recommended before use in production.
目的
Name and description (schema analysis, index optimization, migration generation) align with the included files (README, references, sample schemas, expected outputs) and the three utility scripts. No environment variables, binaries, or external services are declared that would be unexpected for this purpose.
说明范围
SKILL.md and README instruct the agent/user to analyze local schema files, query-pattern files, and produce reports and SQL migration plans. The instructions do not request reading unrelated system paths, scanning shell history, or contacting external endpoints. They describe generating SQL and reports rather than executing changes directly.
安装机制
No install spec (instruction-only) and the README indicates simple local execution with Python 3.7+. No external downloads, package installs, or archive extraction are present in metadata. This is low-risk from an install perspective.
证书
The skill declares no required environment variables, no primary credential, and no config paths. That is proportionate to a local analysis/generation tool. Note: if you plan to have the scripts connect to a live database, additional credentials would be required—current manifest does not request them.
持久
The skill is not always-enabled, is user-invocable, and allows model invocation (the platform default). It does not request permission to modify other skills or global agent configuration in the manifest.
综合结论
This package appears coherent with its stated purpose and is likely safe to inspect and run locally. Before installing or running against production data: 1) Inspect the three Python scripts (index_optimizer.py, migration_generator.py, schema_analyzer.py) for any network calls (requests/urllib/sockets), subprocess.exec/ Popen usage, or code that reads arbitrary filesystem locations or environment variables. 2) Run the tools on sample files fir…
安装（复制给龙虾 AI）
将下方整段复制到龙虾中文库对话中，由龙虾按 SKILL.md 完成安装。
请把本段交给龙虾中文库（龙虾 AI）执行：为本机安装 OpenClaw 技能「Database Designer」。简介：Database Designer - POWERFUL Tier Skill。
请 fetch 以下地址读取 SKILL.md 并按文档完成安装：https://raw.githubusercontent.com/openclaw/skills/refs/heads/main/skills/alirezarezvani/database-designer/SKILL.md
（来源：yingzhi8.cn 技能库）SKILL.md
---
name: "database-designer"
description: "Database Designer - POWERFUL Tier Skill"
---
# Database Designer - POWERFUL Tier Skill
## Overview
A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. This skill combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas.
## Core Competencies
### Schema Design & Analysis
- **Normalization Analysis**: Automated detection of normalization levels (1NF through BCNF)
- **Denormalization Strategy**: Smart recommendations for performance optimization
- **Data Type Optimization**: Identification of inappropriate types and size issues
- **Constraint Analysis**: Missing foreign keys, unique constraints, and null checks
- **Naming Convention Validation**: Consistent table and column naming patterns
- **ERD Generation**: Automatic Mermaid diagram creation from DDL
### Index Optimization
- **Index Gap Analysis**: Identification of missing indexes on foreign keys and query patterns
- **Composite Index Strategy**: Optimal column ordering for multi-column indexes
- **Index Redundancy Detection**: Elimination of overlapping and unused indexes
- **Performance Impact Modeling**: Selectivity estimation and query cost analysis
- **Index Type Selection**: B-tree, hash, partial, covering, and specialized indexes
### Migration Management
- **Zero-Downtime Migrations**: Expand-contract pattern implementation
- **Schema Evolution**: Safe column additions, deletions, and type changes
- **Data Migration Scripts**: Automated data transformation and validation
- **Rollback Strategy**: Complete reversal capabilities with validation
- **Execution Planning**: Ordered migration steps with dependency resolution
## Database Design Principles
→ See references/database-design-reference.md for details
## Best Practices
### Schema Design
1. **Use meaningful names**: Clear, consistent naming conventions
2. **Choose appropriate data types**: Right-sized columns for storage efficiency
3. **Define proper constraints**: Foreign keys, check constraints, unique indexes
4. **Consider future growth**: Plan for scale from the beginning
5. **Document relationships**: Clear foreign key relationships and business rules
### Performance Optimization
1. **Index strategically**: Cover common query patterns without over-indexing
2. **Monitor query performance**: Regular analysis of slow queries
3. **Partition large tables**: Improve query performance and maintenance
4. **Use appropriate isolation levels**: Balance consistency with performance
5. **Implement connection pooling**: Efficient resource utilization
### Security Considerations
1. **Principle of least privilege**: Grant minimal necessary permissions
2. **Encrypt sensitive data**: At rest and in transit
3. **Audit access patterns**: Monitor and log database access
4. **Validate inputs**: Prevent SQL injection attacks
5. **Regular security updates**: Keep database software current
## Conclusion
Effective database design requires balancing multiple competing concerns: performance, scalability, maintainability, and business requirements. This skill provides the tools and knowledge to make informed decisions throughout the database lifecycle, from initial schema design through production optimization and evolution.
The included tools automate common analysis and optimization tasks, while the comprehensive guides provide the theoretical foundation for making sound architectural decisions. Whether building a new system or optimizing an existing one, these resources provide expert-level guidance for creating robust, scalable database solutions.