ms-database-design

Generate ERDs and up/down migrations for SQL and NoSQL schemas.

Updated Oct 16, 2025
One-click install
npx skills add https://github.com/beomeodev/specter --skill ms-database-design
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ms-database-design
Source: https://github.com/beomeodev/specter/tree/main/.claude/skills/ms-database-design
Command: npx skills add https://github.com/beomeodev/specter --skill ms-database-design

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing robust, scalable database schemas that balance performance, maintainability, and Constitution constraints across SQL and NoSQL platforms.

Core Features & Use Cases

  • ERD generation for PostgreSQL, MySQL, and MongoDB
  • Migration script templates with up/down changes and rollback safety
  • Performance optimization guidance including indexing, partitioning, and sharding
  • Constitution-compliant schema complexity and SLOC controls
  • Use Case: design a new schema from requirements or refactor an existing one for performance

Quick Start

Provide your data requirements and target database type, and the tool will generate a Constitution-compliant schema and migration plan.

Frequently Asked Questions about ms-database-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a database schema with partitioning and indexing for PostgreSQL?

You can generate an ERD for PostgreSQL by providing your data requirements to this schema design automation tool. It produces a complete schema with Constitution-compliant constraints, documentation, and performance optimization guidance.

What is the best way to generate ERDs and migration scripts for MongoDB?

Generating ERDs and migration scripts for MongoDB involves automated schema design that balances performance and maintainability. The tool produces up/down migration templates with rollback safety and outputs a complete schema tailored to NoSQL platforms.

How do I create up/down migration scripts with rollback safety for database refactoring?

Up/down migration scripts with rollback safety are generated automatically as templates during the schema design workflow. This ensures safe up and down changes when you refactor an existing database schema for performance.

Does this database design automation support both SQL and NoSQL platforms?

Yes, this database design automation supports both SQL and NoSQL platforms including PostgreSQL, MySQL, and MongoDB. It analyzes requirements to generate ERDs and produces a complete schema tailored to the target system.

When do I need Constitution-compliant schema complexity and SLOC controls?

Constitution-compliant schema complexity and SLOC controls are needed when designing robust, scalable database schemas that must balance performance and maintainability. The tool enforces these constraints automatically during schema generation.

Why does my database schema need optimization guidance for sharding and partitioning?

Database schema optimization guidance for sharding and partitioning is required to ensure scalability and performance across large datasets. The tool analyzes your requirements and outputs tailored optimization recommendations for your target system.