[Preset]: Add spec-kit-preset-db-standards

[gdakuzak]

Preset ID

spec-kit-preset-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)

=0.1.0

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)

[github-actions]

cc @github/spec-kit-maintainers — new catalog submission for review.

[github-actions]

Validation failed for this preset submission.

Failed checks:

• Preset manifest consistency: The submitted Preset ID is spec-kit-preset-db-standards, but the repository's preset.yml declares preset.id: db-standards. Please make the issue field and manifest use the same ID.
• Required Extensions: The issue field contains only >=0.1.0, which is not an extension ID and cannot be represented as a valid catalog requires.extensions entry. Please provide the required extension ID (and version constraint if applicable), or state that no extension is required.

The repository contains preset.yml and LICENSE; the README URL is a GitHub README and includes an accepted specify preset add --from command matching the submitted download URL; the pinned v0.8.2 release exists; and the required checklists are checked. Please update the inconsistent fields and resubmit.

Posted on behalf of @mnriem by GitHub Copilot (model: gpt-5.2-codex, autonomous); comment fully AI-drafted.

Generated by 🎨 Add Community Preset from Issue Submission for #4618 · copilot · gpt52codex · 2.43 AIC · ⌖ 8.72 AIC · ⊞ 27K · ◷