plan-db

Generate database designs and SQL artifacts from project specifications.

9|1|Updated Mar 11, 2026
One-click install
npx skills add https://github.com/mark22013333/crew --skill plan-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: plan-db
Source: https://github.com/mark22013333/crew/tree/main/plugins/feature-workflow/skills/plan-db
Command: npx skills add https://github.com/mark22013333/crew --skill plan-db

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill generates a complete database design from project specifications and writes the results to the .spec directory without calling Notion API, enabling offline storage and version control.

Core Features & Use Cases

  • Spec-driven design: reads .spec/{slug}/spec.md (or README.md when spec.md is absent) to produce DB schema and SQL artifacts.
  • Artifact generation: creates .spec/{slug}/db.md with the design and .spec/{slug}/db.sql containing CREATE TABLE, INDEX, sample data, and rollback statements.
  • Status update: updates the README.md with the status "DB 設計" to reflect completion.
  • Use Case: for a new feature, it designs the database schema and generates SQL ready for review and deployment, all without external API calls.

Quick Start

Provide a complete database design by reading the spec and writing .spec/{slug}/db.md and .spec/{slug}/db.sql without calling Notion.

Frequently Asked Questions about plan-db

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

FAQPage Schema
How do I generate a database design from a project spec automatically?

You can generate a database schema from a spec by using a Skill that reads spec.md or README.md and outputs a db.md design file alongside a db.sql file containing CREATE TABLE statements.

Can I create SQL schema files without external API calls or internet access?

Yes, you can create SQL schema files offline. This database design process runs locally without calling external APIs like Notion, enabling offline storage and direct version control of your artifacts.

What is included in the generated database schema and SQL artifacts?

The generated database schema artifacts include a db.md design document and a db.sql file containing CREATE TABLE statements, INDEX definitions, sample data, and rollback statements for deployment.

Does this database schema generation tool work if I only have a README file?

Yes, the database schema generation tool works with a README file. If spec.md is absent, the process automatically reads README.md to produce the database schema and SQL artifacts.

How do I track database design completion status in my project documentation?

You track database design completion through automated status updates. After generating the schema files, the process updates README.md with the status "DB 設計" to reflect completion.