Generate production-ready database schemas, migrations, and ERD diagrams from natural language descriptions.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install db-schema-gen
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 db-schema-gen 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 DB Schema?
DB Schema is a technical utility within the Openclaw Skills ecosystem designed to bridge the gap between conceptual data modeling and production code. By interpreting plain English descriptions, it automatically generates high-quality SQL schemas, migration files, and relationship diagrams, significantly reducing the manual overhead of database administration tasks.
Utilizing this specific tool among your Openclaw Skills ensures that your database architecture follows industry best practices. It handles the nuances of different database dialects like PostgreSQL, MySQL, and SQLite, while providing first-class support for modern ORMs, making it an essential asset for developers who need to move quickly from idea to implementation.
DB Schema Use Cases
- Rapidly bootstrapping a database for a new project using plain English triggers.
- Generating migration files for ORMs like Prisma, Drizzle, or SQLAlchemy from a single command.
- Creating visual Mermaid or ASCII ERD diagrams to document existing or new data structures.
- Automating the creation of realistic seed data for development and CI/CD pipelines.
- Ensuring consistent indexing and foreign key naming conventions across different database engines.
How DB Schema Works
- The user describes the desired data model and relationships using natural language.
- The skill parses the description to identify entities, attributes, and relationship types like one-to-many or many-to-many.
- Based on user-defined flags, the skill selects the appropriate SQL dialect and ORM mapping.
- It applies standardized rules for primary keys, timestamps, and foreign key constraints.
- The skill performs auto-indexing based on common query patterns like unique fields and foreign keys.
- The final output is generated as code blocks containing SQL, ORM configurations, and visual diagrams.
DB Schema Setup
To integrate this functionality into your Openclaw Skills workflow, use the following configuration steps.
# Install the DB Schema skill
openclaw install db-schema
# Generate a Postgres schema for an e-commerce app
db-schema "Products, Categories, and Orders" --dialect postgres --orm prisma
DB Schema Data Schema & Taxonomy
The skill organizes generated data according to strict technical taxonomies to ensure compatibility across different environments.
| Data Type | Description | Default Pattern |
|---|---|---|
| Primary Keys | Unique identifiers for every table | BIGSERIAL / AUTO_INCREMENT |
| Timestamps | Record tracking for creation and updates | created_at, updated_at |
| Foreign Keys | Relational links between entities | table_id with ON DELETE CASCADE |
| Indexes | Performance optimization structures | B-tree for FKs, UNIQUE for identifiers |
| Seed Data | Realistic development samples | JSON or SQL INSERT statements |
DB Schema Advanced Features
- Multi-dialect support for PostgreSQL, MySQL, SQLite, and NoSQL support for MongoDB.
- Deep ORM integration providing native code for Prisma, Drizzle, Knex, SQLAlchemy, and TypeORM.
- Automated relationship detection including junction table generation for complex many-to-many links.
- Custom output formatting allowing for SQL, JSON, or Markdown-based documentation.
- Intelligent type mapping that selects the most efficient data types based on the target database engine.
SKILL.md
Loading
Related Openclaw Skills
CodeBox QR Code Skill
A powerful AI agent skill to generate, manage, and analyze trackable dynamic QR codes with over 200 custom style templates.
UAPI AI Translate Languages
A specialized skill for retrieving supported AI translation languages and configurations via the UAPI GET /ai/translate/languages endpoint.
Launch Strategy
A specialized AI agent skill designed to architect high-impact product launches and go-to-market strategies for SaaS and feature releases.
RDK X5 Network Management Skill
A comprehensive network and connectivity management toolkit designed specifically for the RDK X5 hardware platform.
GitHub Trending Search
A specialized skill for discovering trending GitHub repositories and developers through intelligent URL construction and precise filtering.
Celo Asset Bridging
A comprehensive skill for transferring tokens between Celo and other blockchain networks using native and third-party bridge protocols.
Featured*
