Skills database-architect
๐Ÿ“ฆ

database-architect

Content revision r2 Safe

Design Scalable Database Architectures

Poor database choices create expensive migrations, weak performance, and operational risk. This skill turns requirements and access patterns into practical schemas, technology choices, and migration plans.

Supports: Claude Codex Code(CC)
๐Ÿฅ‰ 78 Bronze

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-architect" from https://skillstore.io/skills/sickn33-database-architect.md and its manifest at https://skillstore.io/api/skills/sickn33-database-architect/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.

Test it

Using "database-architect". Choose a database for a multi-tenant commerce service with complex transactions and flexible product attributes.

Expected outcome:

  • Recommendation: PostgreSQL for transactional integrity, mature indexing, and flexible reporting.
  • Schema direction: normalized order tables with selective JSONB for variable product attributes.
  • Validation: benchmark peak writes and confirm multi-region recovery objectives before commitment.

Using "database-architect". Plan a low-downtime migration from MySQL to PostgreSQL for a busy order platform.

Expected outcome:

  • Preparation: inventory incompatible types, queries, extensions, and replication constraints.
  • Transition: backfill historical data, stream changes, compare records, and run shadow reads.
  • Cutover: pause risky writes, verify lag and checksums, switch traffic gradually, and preserve a tested rollback window.

Security Audit

Safe
v5 โ€ข 7/23/2026 Open versioned report

All ten static findings are false positives caused by ordinary database architecture language. The cited lines describe safety guidance, design patterns, constraints, and Mermaid outputs. No prompt injection, reconnaissance intent, executable behavior, or data exfiltration instructions were found in SKILL.md.

1
Files scanned
269
Lines analyzed
0
Review items
0
False positives ignored
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-architect/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-architect/security.svg)](https://skillstore.io/skills/sickn33-database-architect?utm_source=security_passport_badge)

HTML badge

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

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-database-architect.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-architect security audit report (audit version 5) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-database-architect/audits/5

BibTeX citation

@techreport{sickn33-sickn33-database-architect-2026, author = {sickn33}, title = {database-architect security audit report (audit version 5)}, institution = {Skillstore}, year = {2026}, number = {5}, url = {https://skillstore.io/skills/sickn33-database-architect/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-architect 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-architect/audits/5" identifiers: - type: other value: "skillstore:sickn33-database-architect:audit:5" description: "Skillstore immutable audit report identifier"

Skillstore Score

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

What You Can Build

Select a Greenfield Database

Compare storage technologies and define an initial schema from product requirements, workload patterns, team skills, and expected growth.

Plan a Platform Migration

Create phased migration, compatibility, validation, cutover, and rollback plans for changing engines or decomposing a shared database.

Design Regulated Data Storage

Map sensitive data, access controls, encryption, retention, audit logging, backups, and recovery requirements into a defensible architecture.

Try These Prompts

Choose a Database
Recommend a database for [application]. Expected scale is [volume], with [read/write pattern] and [consistency requirement]. Explain trade-offs and required clarifications.
Design a Schema
Design a schema for [domain] using [database]. Include entities, relationships, constraints, indexes, retention rules, and assumptions based on these access patterns: [patterns].
Plan a Safe Migration
Plan a migration from [source] to [target] for [data size and traffic]. Include phases, compatibility, validation, rollback triggers, backups, and cutover criteria.
Architect Global Scale
Design a multi-region data architecture for [system]. Address consistency, partitioning, replication, failover, RPO, RTO, cost, compliance, observability, and growth to [target scale].

Best Practices

  • Provide concrete read, write, latency, consistency, availability, retention, and growth requirements.
  • Separate current constraints from future targets so recommendations avoid premature complexity.
  • Validate architecture decisions with representative data, load tests, migration rehearsals, recovery tests, and cost estimates.

Avoid

  • Choosing a database from popularity alone without documenting workload fit and operational trade-offs.
  • Treating generated schemas or capacity estimates as production-ready without benchmarks and environment-specific review.
  • Executing irreversible migrations without backups, staged validation, rollback criteria, and accountable approval.

Frequently Asked Questions

Can this skill choose between SQL and NoSQL databases?
Yes. It compares data shape, access patterns, consistency, scale, team capability, cost, and operational complexity.
Can it create an entity-relationship diagram?
Yes. Request a Mermaid ERD and provide entities, relationships, cardinality, and key business rules.
Will it modify my database?
No by default. It recommends designs and migration steps, and it avoids execution unless explicitly requested and supported.
What information improves the recommendation?
Provide data volume, growth, query patterns, write rate, latency, consistency, availability, retention, compliance, budget, and team constraints.
Does it replace database testing or expert review?
No. Validate all recommendations with representative benchmarks, staging migrations, recovery tests, security review, and current vendor guidance.
Can it plan a zero-downtime migration?
It can propose phased backfills, change capture, compatibility controls, validation, cutover, and rollback. Actual feasibility depends on your environment.

Developer Details

Author

sickn33

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Ref

f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526

Maintenance freshness

7/26/2026

Usage

9 downloads ยท 148 views

File structure

๐Ÿ“„ SKILL.md

More from sickn33

View all
View all