EngineeringPROPRO REQUIREDFC-ENG-005
Database Claw
database-eng-claw
v0.2.0May 22, 2026Database engineering — schema design, query optimization, and performance tuning with ERDs tied to real query patterns
Database design that starts with the ORM's defaults ends with a schema that fights the query planner. I model schemas around access patterns — indexing for the queries that actually run, partitioning for the tables that grow unbounded, and migrations that don't lock the table for the duration of the deploy.
OpenClaw
Hermes
Claude Code
Codex
Cursor
Windsurf
Aider
OllamaPRIMARY ACTION
Unlock with ProCOMPATIBLE WITH
OpenClawHermesClaude CodeCodex+4
8 compatible tools3 output formats
When to Use
- Implement production-grade code and architecture
- Audit design decisions and tradeoffs
- Catch reliability issues before release
- Raise quality consistency across teams
Compatible Frameworks
OpenClawHermesClaude CodeCodexCursorWindsurfAiderOllama8 TOOLS
Quality Gates
- Queries analyzed with EXPLAIN plans
- Indexes justified with write performance analysis
- Migrations include rollback procedures
- Configurations justified by workload patterns
- Denormalization documented with trade-offs
3 GATES DEFINED
Expected Outputs
Database Schema Design with Index StrategyMigration Scripts Validated for Online-Safe ExecutionEXPLAIN Plan Analysis for Top-N Query Paths
Native exports per tool
OpenClaw10 files
openclaw/AGENTS.mdopenclaw/SOUL.mdopenclaw/TOOLS.md+7 moreHermes5 files
hermes/skills/flickclaw/database-eng-claw/SKILL.mdhermes/skills/flickclaw/database-eng-claw/references/workflow.mdhermes/skills/flickclaw/database-eng-claw/references/quality-gates.md+2 moreClaude Code6 files
claude-code/CLAUDE.mdclaude-code/.claude/skills/database-eng-claw/SKILL.mdclaude-code/.claude/skills/database-eng-claw/references/workflow.md+3 moreCodex5 files
codex/AGENTS.mdcodex/.flickclaw/agents/database-eng-claw/codex.mdcodex/.flickclaw/agents/database-eng-claw/workflow.md+2 moreCursor3 files
cursor/.cursor/rules/flickclaw-database-eng-claw.mdccursor/.cursor/rules/flickclaw-database-eng-claw-workflow.mdccursor/.cursor/rules/flickclaw-database-eng-claw-quality-gates.mdcWindsurf3 files
windsurf/.windsurf/rules/flickclaw-database-eng-claw.mdwindsurf/.windsurf/rules/flickclaw-database-eng-claw-workflow.mdwindsurf/.windsurf/rules/flickclaw-database-eng-claw-quality-gates.mdAider3 files
aider/CONVENTIONS.mdaider/aider.mdaider/.aider.conf.ymlOllama4 files
ollama/Modelfileollama/system-prompt.mdollama/template.md+1 moreInstall Commands
Install the FlickClaw CLI, then select your AI agent framework below to get the correct install command.
Step 1: Install CLI (one-time)
npm install -g @flickclaw/cli@latestStep 2: Select Framework
OpenClaw
npm exec --yes @flickclaw/cli@latest -- install database-eng-claw --target openclawDownload as ZIP
Example Prompt
Try this prompt with Database Claw to see what it can do:
Review the codebase architecture and identify 3 areas for improvement. Focus on maintainability, test coverage, and performance. Produce Database Schema Design with Index Strategy, Migration Scripts Validated for Online-Safe Execution, EXPLAIN Plan Analysis for Top-N Query Paths.Example Output
IllustrativeWhat a typical Database Claw report looks like:
# Database Claw — Assessment Report **Project**: data-pipeline **Context**: an ETL pipeline processing 2M events/hour with PostgreSQL and Redis **Generated**: 2026-07-10 ## Executive Summary The Database Claw completed its review of data-pipeline (an ETL pipeline processing 2M events/hour with PostgreSQL and Redis). 3 findings were identified with concrete remediation steps. All quality gates were verified before delivery. ## Findings | # | Severity | Area | Finding | Recommended Action | |---|----------|------|---------|-------------------| | 1 | **P0** | Performance | N+1 queries in batch processing loop | Use eager loading with batch size 500 | | 2 | **P1** | Architecture | Tight coupling between extract and transform | Introduce event queue with dead letter handling | | 3 | **P2** | Testing | No integration tests for Redis failover | Add chaos test with Redis connection drop | ## Quality Gates - [✓] indexes_are_backed_by_explain_plan_output_for_top_queries - [✓] every_migration_is_online_safe_or_has_a_documented_lock_window - [✓] foreign_keys_and_constraints_enforced_at_the_database_level ## Outputs Generated - **Database Schema Design with Index Strategy**: Included in the report above. - **Migration Scripts Validated for Online-Safe Execution**: Included in the report above. - **EXPLAIN Plan Analysis for Top-N Query Paths**: Included in the report above. ## Validation - [x] All quality gates passed (3/3) - [x] 3 findings documented with severity and remediation - [x] 3 output sections generated - [x] Evidence collected and referenced --- *This is an illustrative example output from FlickClaw. Results vary based on project context.*
RELATED AGENTS