Skip to main content
skill CX Codex

database-schema-designer · borghei — Claude Code skill for relational schemas

database-schema-designer — a Claude Code skill that turns product requirements into a normalized relational schema with tables, ORM models, RLS, indexes and migrations. Works across six platforms, including Codex, Cursor and Gemini CLI.

LicenseRef-MIT-Commons-Clause 183 installs ★ 1,183 updated 2026-11-08

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add borghei/Claude-Skills --skill database-schema-designer -a claude-code
Open on GitHub

What database-schema-designer does

The skill targets PostgreSQL, MySQL and SQLite, and writes output as Drizzle, Prisma, TypeORM or Alembic. From a plain-language list of entities and relationships it builds tables, adds id, created_at, updated_at, and where needed deleted_at, organization_id and version. Primary keys use UUIDv7 or CUID2, which keeps B-tree inserts local.

Security gets its own pass. The skill generates Row-Level Security for tenant isolation, column-level PII encryption, and audit logging with before/after JSON snapshots. Migration planning covers rollback SQL and zero-downtime patterns for large tables.

Three Python scripts do the heavy lifting. schema_validator.py flags missing FK indexes and soft-delete tables without a partial index. migration_diffr.py produces forward and rollback SQL between two DDL versions. erd_generator.py renders a Mermaid ERD. You need Python 3 and a .sql file to run the first one.

What it helps with

  • design tables from natural-language requirements
  • add RLS and multi-tenancy to a single-tenant schema
  • plan a migration with rollback for a large table
  • catch missing foreign-key indexes
  • render a Mermaid ERD

Example prompts for the agent

  • Design tables for orders, products and customers, with soft deletes
  • Run schema_validator.py on assets/schema.sql and show me the errors
  • Build a migration from schema_v1.sql to schema_v2.sql, with the rollback SQL

How to install database-schema-designer

1Skills CLI (Vercel)

npx skills add borghei/Claude-Skills --skill database-schema-designer -a claude-code

2Manually: put the files in place

~/.claude/skills/database-schema-designer/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/database-schema-designer/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about database-schema-designer

How do I install database-schema-designer in Claude Code?

Run npx skills add borghei/Claude-Skills --skill database-schema-designer -a claude-code, then the skill lands in ~/.claude/skills/database-schema-designer/SKILL.md.

What does database-schema-designer do?

It turns product requirements into a normalized schema: tables, constraints, RLS, indexes, migrations, plus TypeScript or Python types. Supports PostgreSQL, MySQL and SQLite through Drizzle, Prisma, TypeORM or Alembic.

How is it different from engineering/database-designer?

This skill is for designing a new schema; database-designer is for deep analysis of an existing one and index tuning. The README draws that line explicitly.

Similar skills

All skills for Data and databases →

database-schema-designer by other authors comes first.

database-schema-designer softaworks database-schema-designer is a Claude Code skill for designing SQL and NoSQL schemas, including relationships, constraints, indexes, and migrations. It can create or review a data model. CX Codex +1 4,400installs database-schema-designer Alireza Rezvani The database-schema-designer skill turns database requirements into relational schemas, ERDs, and migrations. Use it when planning tables for a feature or reviewing an existing design. CX Codex +1 692installs database-schema-designer OneWave-AI database-schema-designer designs relational and document database schemas based on real app queries. Generates tables, keys, constraints, ERDs, and reversible migrations. CX Codex +1 432installs database-migration-management aj-geddes database-migration-management is a Claude Code skill for planning schema migrations, rollbacks, and data transformations in PostgreSQL and MySQL. It supports table versioning and non-blocking index creation. CX Codex +1 505installs planetscale-schema-recommendations-agent-loop planetscale planetscale-schema-recommendations-agent-loop is a Claude Code skill that processes PlanetScale schema recommendations and turns them into plans for migrations, branches, and pull requests without touching production. CX Codex +1 2,000installs database-design MoizIbnYousaf database-design — a skill for schema design, migrations and query optimization on PostgreSQL, MySQL and NoSQL. Useful whenever the agent writes SQL. CX Codex +1 624installs database-expert carlrannaberg database-expert — a subagent for optimizing database queries, index layouts, connection pools, and migrations across PostgreSQL, MySQL, MongoDB, and SQLite. CX Codex ★ 763repo stars database-schema-design aj-geddes database-schema-design designs relational database schemas with normalization, constraints, and table relationships. Built for modeling data in PostgreSQL and MySQL. CX Codex +1 599installs relational-database-mcp-cloudbase TencentCloudBase relational-database-mcp-cloudbase operates existing CloudBase MySQL through MCP tools: queries, schema changes, permissions, destruction. New projects should use PostgreSQL instead. CX Codex +1 962installs

From the same set120

The whole set →
code-reviewer code-reviewer is a Claude Code skill that automatically checks pull requests for risk, code smells, and SOLID violations, scores the diff, and prioritizes findings. CX Codex +1 193installs delivery-manager delivery-manager — a skill for managing software delivery: plans releases, picks deployment strategies, coordinates incidents, and tracks reliability budgets. Use it to standardize how your team ships code. CX Codex +1 193installs page-cro page-cro is a Claude Code skill for analyzing and improving sales pages across seven dimensions, including value clarity, CTA hierarchy, and objection handling. CX Codex +1 188installs senior-ml-engineer The senior-ml-engineer Claude Code skill supports production work on ML models and LLM features. Use it to plan a deployment, design a RAG pipeline, or check for model drift. CX Codex +1 187installs ml-ops-engineer ml-ops-engineer is a skill for MLOps automation: deploying models, orchestrating training pipelines, monitoring feature drift, and configuring feature stores. It addresses gaps in ML deployment workflows. CX Codex +1 180installs ma-playbook ma-playbook is a Claude Code skill that structures M&A target assessment, due diligence, and deal structuring. CX Codex +1 179installs cto-advisor cto-advisor — a skill for technology strategy, team scaling and architecture decisions. Helps plan engineering growth, prioritise technical debt and evaluate vendors. CX Codex +1 177installs database-designer The database-designer skill for Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, and OpenCode reviews SQL schemas, suggests indexes, and creates migrations. Use it for DDL reviews, index tuning, or schema diffs. CX Codex +1 176installs

Project sponsors

Companies that keep this analytics open