[Preset]: Add db-standards

Start by reviewing the linked preset repository's preset.yml, README.md, templates, and engine-specific reference files. Install it with the documented specify preset add command, then verify template resolution and the checked submission requirements. Done means the preset installs successfully, its documentation and license are present, and the provided checklist remains satisfied.

Preset ID

db-standards

Preset Name

Database Standards

Version

0.8.2

Description

Database conventions for spec-driven work: naming, data-model design, constraints, data protection, performance, query safety, a schema-review checklist, and engine-specific references. ORM-agnostic.

Author

Guilherme 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 — adds Database + Data protection sections (engine, version, migration tool; security posture)
• spec-template — adds Data Requirements section
• plan-template — adds Database Design section (naming, data-model design, constraints & integrity, data protection, performance, query safety)
• tasks-template — adds Schema Review Checklist

Commands Provided

• speckit.constitution — 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)