A comprehensive framework for database design, optimization, migration, and operations across PostgreSQL, MySQL, and SQLite.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install afrexai-database-engineer
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install afrexai-database-engineer using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Database Engineering Mastery?
This skill provides an end-to-end system for database engineering, covering everything from initial schema design and normalization to production monitoring and emergency recovery. It is designed to guide developers through creating robust, scalable, and secure data layers while adhering to industry best practices and avoiding common pitfalls like N+1 queries or locking migrations.
By leveraging Openclaw Skills, teams can ensure their databases are performant, well-indexed, and resilient against data loss. The content provides specific decision frameworks for denormalization, column type selection, and indexing strategies, making it an essential resource for developers building data-intensive applications.
Database Engineering Mastery Use Cases
- Designing normalized schemas for new applications using structured design briefs.
- Optimizing slow queries using EXPLAIN analysis and sophisticated indexing strategies.
- Executing zero-downtime migrations on high-traffic tables with multi-step safety protocols.
- Implementing multi-tenant isolation via Row-Level Security and tenant-specific policies.
- Troubleshooting production performance bottlenecks, disk-full scenarios, and lock contention.
How Database Engineering Mastery Works
- Analyze project requirements and expected scale through a detailed design brief to determine normalization levels.
- Define table structures using naming conventions and optimal data types for performance and storage efficiency.
- Implement a strategic indexing plan including B-tree, GIN, and BRIN indexes to ensure query performance.
- Develop safe, multi-step migration scripts that include rollback plans and batch backfills for large datasets.
- Monitor health metrics and tune database configurations like shared_buffers and work_mem for peak efficiency.
Database Engineering Mastery Setup
To utilize this skill effectively, ensure your environment is configured for the target database engine (PostgreSQL, MySQL, or SQLite). For PostgreSQL users, the pg_stat_statements extension is recommended for performance analysis. Use the following command to initialize a logical backup for testing:
pg_dump -Fc -Z 9 -d your_database -f initial_backup.dump
Database Engineering Mastery Data Schema & Taxonomy
The skill enforces a rigorous data organization and metadata taxonomy to ensure maintainability.
| Metadata Category | Convention |
|---|---|
| Table Naming | snake_case, plural (e.g., users, order_items) |
| Column Naming | snake_case, singular (e.g., first_name, created_at) |
| Primary Keys | BIGSERIAL (BIGINT) or UUID for distributed systems |
| Index Naming | idx_{table}_{columns} |
| Audit Fields | created_at, updated_at, and version for optimistic locking |
Database Engineering Mastery Advanced Features
- Automated unused index auditing to reduce unnecessary write overhead and storage consumption.
- Keyset pagination implementation to replace inefficient OFFSET-based traversal in large datasets.
- Advanced JSONB and Full-Text Search integration specifically optimized for PostgreSQL workloads.
- Recursive CTE patterns for complex hierarchical data structures and organization chart traversals.
- Emergency operational runbooks for rapid response to database overloads or disk-full events within the Openclaw Skills framework.
SKILL.md
Loading
Related Openclaw Skills
Data Room Builder
Automate the creation of structured virtual data room hierarchies and prioritized document checklists for due diligence.
Data Privacy & Protection Program
A comprehensive AI Data Privacy Officer agent designed to build, operate, and mature organizational privacy programs across global regulatory frameworks.
Data Migration Planner
A comprehensive AI skill for planning, executing, and validating data migrations between complex systems while ensuring integrity and minimizing downtime.
Data Governance Framework
A comprehensive assessment and remediation tool designed to score organizational data maturity across six mission-critical domains.
Davis-Bacon & Prevailing Wage Compliance Agent
A comprehensive federal construction compliance agent for managing Davis-Bacon Act requirements, DOL Wage Determinations, and certified payroll workflows.
Deal Desk AI Agent Skill
A structured framework for AI agents to automate non-standard deal reviews, discount approvals, and margin analysis.
Featured*
