Hacktoberfest 2026 : les issues que les mainteneurs ont marquées pour octobre, ouvertes et accessibles aux débutants. Parcourir les issues Hacktoberfest

[Preset]: Add db-standards

Fermée
  • Quelque chose ne va pas ?
#4,654 5 commentaires 0 réactions 0 personnes assignées Voir sur GitHub

Les mainteneurs répondent en général sous 1 jour

Personne n'a encore pris cette issue.

Évaluation

Difficulté
3/5
Temps estimé
1-2 jours
Accessibilité débutants
72/100
Type d'issue
Fonctionnalité
Clarté
Plutôt claire
Activité
Active
Stack technique
mongodb, mysql
Domaine
databases, tooling

Piste de recherche

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.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Description

enhancement needs-triage preset-submission triage-nice-to-have validation-failed
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)
Langage dominant
Python
Étoiles
140k
Forks
12.6k
Merge moyen
2 j 18 h
PR mergées (30 j)
195

Préparer son environnement

Ouvrir dans Codespaces

Lance le conteneur de développement du projet dans votre navigateur, avec votre propre compte GitHub.

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de github/spec-kit

Toutes les issues de github/spec-kit

Issues similaires

Plus d'issues Python

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.