[Preset]: Add db-standards #4618

Preset ID

db-standards

Preset Name

DB Standards

Version

0.8.2

Description

A Spec Kit preset that bakes database conventions into the spec-driven workflow. ORM-agnostic — the rules are about SQL schema design, not a particular framework.

Author

Guilherme Makoto Sacoman Dakuzaku

Repository URL

https://github.com/gdakuzak/spec-kit-preset-db-standards

Download URL

https://github.com/gdakuzak/spec-kit-preset-db-standards/archive/refs/tags/v0.8.2.zip

Documentation URL

https://github.com/gdakuzak/spec-kit-preset-db-standards/blob/main/README.md

License

MIT

Required Spec Kit Version

0.1.0

Required Extensions (optional)

None

Templates Provided

• constitution-template.md — adds Database + Data protection sections (engine, version, migration tool; security posture)
• spec-template.md — adds Data Requirements section
• plan-template.md — adds Database Design section (naming, data-model design, constraints & integrity, data protection, performance, query safety)
• tasks-template.md — adds Schema Review Checklist

Commands Provided

• speckit.constitution.md — requires confirming the target database (engine, version, migration tool) and the security posture (roles, RLS) before the constitution is drafted

Number of Scripts (optional)

No response

Tags

database, standards, data-modeling, performance

Key Features

• Forces confirming the target database (engine, version, migration tool) before the constitution is drafted, and records it in a Database section
• Adds a Data Requirements section to specs: entities, reads/writes, retention, consistency
• Adds Database Design guidance to plans: naming conventions, OLTP/OLAP classification, normalization (3NF) vs. denormalization trade-offs, constraints & integrity, data protection (column classification, secrets, RLS, least-privilege), external identifier exposure, SQL portability (ANSI-first), query safety (SQL injection), indexing plan, N+1/query-volume plan
• Adds a Schema Review Checklist to tasks, run before merging any migration
• Ships engine-specific reference files (Oracle, MySQL, SQL Server, DynamoDB, MongoDB) — read on demand from the plan, not bloating every project's plan with guidance for engines it doesn't use
• ORM-agnostic; all overrides use append, so it stacks cleanly with other presets

Testing Checklist

• Preset installs successfully via specify preset add
• Template resolution works correctly after installation
• Documentation is complete and accurate
• Tested on at least one real project

Submission Requirements

• Valid preset.yml manifest included
• Linked README (Documentation URL) explains how to use this preset and includes a valid specify preset add ... command (preferably specify preset add --from <download-url> using the exact download URL)
• LICENSE file included
• GitHub release created with version tag
• Preset ID follows naming conventions (lowercase-with-hyphens)