Afrexai Database Engineer
Skill by 1kalin
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/1kalin/afrexai-database-engineerWhat This Skill Does
The Afrexai Database Engineer skill is a comprehensive framework for managing the entire lifecycle of relational database systems. Developed by 1kalin, this skill serves as an expert technical consultant embedded within your OpenClaw agent. It provides a structured methodology for database design, optimization, migration, and ongoing maintenance.
Rather than offering generic advice, this skill enforces industry-standard best practices by utilizing a specialized Design Brief template. This ensures that every schema is built with awareness of the project's domain, scale, and compliance requirements (GDPR, HIPAA, etc.). It acts as a guide for selecting the correct normalization strategies, identifying when to denormalize for performance, and adhering to strict naming conventions that ensure long-term codebase maintainability. The skill includes a robust column-type decision tree to prevent common pitfalls, such as using floating-point numbers for currency or incorrect string types for large text fields.
Installation
To integrate this skill into your OpenClaw environment, execute the following command in your terminal or command-line interface:
clawhub install openclaw/skills/skills/1kalin/afrexai-database-engineer
Use Cases
- New Project Architecting: Use the skill to generate DDL schemas that are optimized for your specific concurrency and read-write ratios.
- Database Performance Tuning: Provide your slow-performing queries to the skill for analysis; it will evaluate index utilization and schema normalization to suggest improvements.
- Migration Strategy: Consult the skill when transitioning between databases (e.g., migrating from SQLite to PostgreSQL) to ensure data type compatibility and constraint handling.
- Compliance Auditing: Ensure your table structure and field types align with privacy requirements by verifying your schema against the built-in compliance check protocols.
Example Prompts
- "I am building a multi-tenant e-commerce platform with expected 10M rows in year 1. Can you help me fill out the Database Design Brief and propose a schema for my order_items table?"
- "My PostgreSQL reporting query is blocking my main application transactions. Based on the normalization framework, how should I denormalize this structure for better read performance?"
- "Review my current MySQL table schema for a payment processing system. Identify potential issues with my column types, especially regarding precision and naming conventions."
Tips & Limitations
- Strict Adherence: Always fill out the Design Brief completely before asking the agent to write DDL. This provides the context necessary for the AI to make intelligent decisions.
- Not a Database Client: This skill is an architectural assistant. It generates SQL scripts and structural recommendations, but it does not directly connect to your production database to perform destructive operations.
- Version Control: Treat the generated DDL as code. Always store the output of this skill in your version control system to track changes over time.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-1kalin-afrexai-database-engineer": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: code-execution