Skills database-design
📦

database-design

Content revision r2 Safe ⚙️ External commands

Design Better Database Schemas

Database choices often ignore workload, deployment, and migration constraints. This skill guides selection, schema design, indexing, optimization, and safer changes.

Supports: Claude Codex Code(CC)
📊 75 Adequate

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "database-design" from https://skillstore.io/skills/sickn33-database-design.md and its manifest at https://skillstore.io/api/skills/sickn33-database-design/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/sickn33-database-design.md Signed manifest GET /api/skills/sickn33-database-design/manifest Signed lockfile GET /api/skills/sickn33-database-design/lockfile

Test it

Using "database-design". Select storage for a small local desktop application with simple relational data and one writer.

Expected outcome:

  • Recommendation: SQLite.
  • Reasoning: Embedded storage and single-writer access match the stated workload.
  • Trade-off: Reassess if concurrent writes or global distribution become requirements.

Using "database-design". Review an orders table queried by customer, status, and creation date.

Expected outcome:

  • Start with an index aligned to the most frequent customer and status filter.
  • Place equality columns before the creation-date range column.
  • Confirm the choice with an execution plan and production-like data.

Using "database-design". Add a required column to a large production table without downtime.

Expected outcome:

  • Add the column as nullable first.
  • Backfill existing rows in controlled batches.
  • Deploy compatible application code, then add the required constraint.
  • Prepare rollback steps before each stage.

Security Audit

Safe
v5 • 7/23/2026 Open versioned report

All nine static findings are false positives. Backticks in SKILL.md format filenames, while flagged lines elsewhere contain ordinary database guidance and validation logic. No prompt injection or malicious intent was found.

8
Files scanned
494
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (6)
SKILL.md:19 SKILL.md:20 SKILL.md:21 SKILL.md:22 SKILL.md:23 SKILL.md:24
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/sickn33-database-design/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-database-design/security.svg)](https://skillstore.io/skills/sickn33-database-design?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-database-design?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-database-design/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-database-design.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

sickn33. (2026). database-design security audit report (audit version 5) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-database-design/audits/5

BibTeX citation

@techreport{sickn33-sickn33-database-design-2026, author = {sickn33}, title = {database-design security audit report (audit version 5)}, institution = {Skillstore}, year = {2026}, number = {5}, url = {https://skillstore.io/skills/sickn33-database-design/audits/5}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "database-design security audit report (audit version 5)" version: "unspecified" type: report authors: - name: "sickn33" date-released: "2026-07-23" url: "https://skillstore.io/skills/sickn33-database-design/audits/5" identifiers: - type: other value: "skillstore:sickn33-database-design:audit:5" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
45
Architecture
85
Maintainability
87
Content
70
Community
83
Spec Compliance

What You Can Build

Choose a Database Stack

Compare database and ORM options against deployment, latency, query, scaling, and developer experience requirements.

Review a New Schema

Evaluate entities, keys, relationships, timestamps, normalization, and indexes before implementation.

Plan Production Changes

Prepare staged migrations and query improvements that reduce locking, downtime, and performance regressions.

Try These Prompts

Choose a Database 
Choose a database for [application]. Requirements include [deployment], [traffic], [query needs], and [availability]. Compare suitable options and explain trade-offs.
Design a Schema 
Design a schema for [domain]. Include entities, primary keys, relationships, deletion behavior, timestamps, normalization choices, and expected access patterns.
Review Indexes and Queries 
Review these tables and query patterns: [details]. Recommend indexes, identify N+1 risks, and explain what to verify with execution plans.
Plan a Safe Migration 
Create a zero-downtime migration plan for [change]. Account for [database], [table size], [deployment process], rollback, backfill, locking, and compatibility.

Best Practices

  • Provide deployment, workload, consistency, latency, and growth requirements before requesting a recommendation.
  • Share representative queries and data volumes when planning indexes or optimization.
  • Test migrations on a realistic data copy and verify rollback procedures before production.

Avoid

  • Do not choose PostgreSQL or any ORM without comparing requirements and operational trade-offs.
  • Do not add indexes without considering write cost, selectivity, and actual query patterns.
  • Do not perform breaking schema changes in one deployment step.

Frequently Asked Questions

Does this skill generate complete production SQL?
It provides design guidance and may suggest structures, but production SQL still requires database-specific review and testing.
Which databases does it compare?
It covers PostgreSQL, Neon, Turso, SQLite, PlanetScale, and CockroachDB in its selection guidance.
Which ORMs does it discuss?
It compares Drizzle, Prisma, Kysely, raw SQL, and SQLAlchemy for different deployment and development needs.
Can it validate Drizzle schemas?
The script discovers likely Drizzle files, but detailed Drizzle validation is not implemented.
Does the Prisma validator modify files?
No. It reads matching schema files and prints warnings without changing project content.
Can it guarantee zero-downtime migrations?
No. It outlines safer stages, but guarantees require testing against the actual database, data volume, traffic, and deployment process.

Developer Details

Author

sickn33

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Repository

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-design

Ref

f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526

Maintenance freshness

7/26/2026

Usage

17 downloads · 167 views

File structure

📄 database-selection.md

📄 indexing.md

📄 migrations.md

📄 optimization.md

📄 orm-selection.md

📄 schema-design.md

📁 scripts/

📄 schema_validator.py

📄 SKILL.md

More from sickn33

View all

Related Skills

View all