Skip to main content
skill CX Codex

database-designer · borghei — Claude Code skill: schema analysis and setup

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.

LicenseRef-MIT-Commons-Clause 176 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-designer -a claude-code
Open on GitHub

What database-designer does

The skill includes three Python scripts: a schema analyzer, an index optimizer, and a migration generator. They work with DDL or JSON schemas; index suggestions also need query patterns.

The analyzer checks normalization, constraints, naming, and data types, and can produce a Mermaid ERD. The optimizer proposes single-column, composite, and covering indexes, while flagging overlap and redundancy. The migration tool compares two JSON schemas and outputs ordered forward and rollback SQL steps, risk levels, and validation queries.

Index suggestions depend on the supplied query patterns, so test each one with EXPLAIN on real data. The migration generator has a --zero-downtime mode for large or busy tables, but drops and type changes still call for careful review.

What it helps with

  • spot normalization and constraint issues in an SQL schema
  • choose indexes for known query patterns
  • find redundant or overlapping indexes
  • turn a schema diff into SQL with rollback steps
  • generate a Mermaid ERD from DDL or JSON

Example prompts for the agent

  • Review schema.sql for normalization and missing constraints.
  • Suggest indexes for schema.json using the patterns in queries.json.
  • Compare old.json with new.json and create SQL with rollback and validation steps.

How to install database-designer

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

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

Questions about database-designer

How do I install database-designer in Claude Code?

Run npx skills add borghei/Claude-Skills --skill database-designer -a claude-code. The skill file is at ~/.claude/skills/database-designer/SKILL.md.

What does database-designer do?

It reviews existing SQL schemas, recommends indexes based on query patterns, and creates migrations between schema versions with rollback SQL.

What does the index optimizer need?

Give it a JSON schema and the query patterns to optimize for. Test its suggestions with EXPLAIN against real data.

Similar skills

All skills for Data and databases →

database-designer by other authors comes first.

From the same set120

The whole set →
database-schema-designer 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. CX Codex +1 183installs 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 api-design-reviewer api-design-reviewer — a skill for Claude Code inspects OpenAPI specs, catches breaking schema changes between versions, and grades REST API architecture maturity. CX Codex +1 167installs information-security-manager-iso27001 information-security-manager-iso27001 is a Claude Code skill for designing and auditing an ISO 27001:2022 ISMS, covering risk assessment, Annex A controls, and certification readiness. CX Codex +1 166installs agent-designer agent-designer — a skill for Claude Code and related platforms that plans multi-agent architectures. It generates tool definitions for Anthropic and OpenAI, diagrams communication flows, and parses runtime logs. CX Codex +1 161installs marketing-psychology The marketing-psychology skill uses behavioral psychology and mental models to diagnose marketing friction. Use it for landing pages, pricing, email, ads, and conversion work. CX Codex +1 151installs

More in the catalog

Project sponsors

Companies that keep this analytics open