Skip to content
Skills Library
Data & analytics · Planning

universal-database-engineering

/universal-database-engineering

Design or evolve data models, schemas, constraints, and workload-driven database architecture across relational, embedded, document, and analytical engines. Use for substantive database modeling, integrity, query/index tradeoffs, or schema evolution; skip unrelated backend work and trivial SQL edits.

Licence
MIT
Last repository change
30.10.2026

Assessment and security

85/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content20 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
10
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 30.10.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

Design or evolve data models, schemas, constraints, and workload-driven database architecture across relational, embedded, document, and analytical engines. Use for substantive database modeling, integrity, query/index tradeoffs, or schema evolution; skip unrelated backend work and trivial SQL edits.

Original author description

Design or evolve data models, schemas, constraints, and workload-driven database architecture across relational, embedded, document, and analytical engines. Use for substantive database modeling, integrity, query/index tradeoffs, or schema evolution; skip unrelated backend work and trivial SQL edits.

How it works

  1. Understand the fact before choosing storage
  2. Make the modeling decision explicit
  3. Load only relevant detail
  4. Implement and verify the real outcome
Original SKILL.md headings · 41 lines, 624 words
SKILL.md preview
---
name: universal-database-engineering
description: Design or evolve data models, schemas, constraints, and workload-driven database architecture across relational, embedded, document, and analytical engines. Use for substantive database modeling, integrity, query/index tradeoffs, or schema evolution; skip unrelated backend work and trivial SQL edits.
---

# Universal Database Engineering

Optimize the logical model for business correctness and clarity, then optimize storage and access using evidence. The goal is neither fewer tables nor maximum normalization/indexing. Preserve a suitable existing schema, engine, driver and migration system. Do not introduce another database or copy a company's architecture merely because its workload appears similar.

## Understand the fact before choosing storage

Identify the request: new model, existing feature, query/concurrency problem, migration, architecture decision or read-only review. Inspect applicable instructions and the relevant schema/models, migrations, constraints, generated queries, readers/writers, background jobs, tests and deployment. Follow actual dependencies rather than exploring the whole repository. A simple column change does not require a multi-engine architecture review.

Establish the actual engine/version, storage engine/extensions, provider restrictions, driver/ORM, transaction and connection ownership, isolation/consistency settings and primary/replica paths. Separate configured, installed and deployed behavior. Do not assume MySQL equals MariaDB, SQLite tests prove PostgreSQL behavior, or SQL terminology implies identical guarantees. Research consequential uncertainty against the target release, using available research guidance without loading unrelated domains.

For the affected data, establish its grain (what one record means), identity, owner/tenant, lifecycle, cardinality, invariants, history/retention and access patterns. Ask only for missing business facts that materially change correctness or the model. Find whether existing structures already own the fact before proposing a table, collection or column.

## Make the modeling decision explicit

Compare reuse, extension, separation, embedding/reference, computation or deliberate materialization only where plausible. Choose from ownership, dependencies, lifecycle, atomic boundaries, growth and query costs. A separate table needs a distinct entity, relationship, lifecycle or other concrete benefit; keeping everything together needs equally sound boundaries.

For a proposed stored fact, explain who writes it, what identifies it, why it belongs there, how invalid states are prevented and how consumers access it. Distinguish a historical snapshot from an accidental duplicate of current data. Denormalized/derived values need an authoritative source, maintenance/rebuild path and acceptable lag. Avoid speculative counters, status fields, timestamps, JSON escape hatches or generic entity frameworks.

## Load only relevant detail

| Decision or engine | Reference |
| --- | --- |
| Table/collection boundaries, columns, relationships and tenant invariants | [Modeling decisions](references/modeling-decisions.md) |
| Concurrency, query/index costs, migration and production architecture | [Integrity, workload and evolution](references/integrity-workload-and-evolution.md) |
| MySQL or MariaDB | [MySQL and MariaDB distinctions](references/mysql-and-mariadb.md) |
| Embedded SQLite | [SQLite](references/sqlite.md) |
| MongoDB documents | [MongoDB](references/mongodb.md) |
| ClickHouse analytics | [ClickHouse](references/clickhouse.md) |
| Source authority, case studies or deeper upstream research | [Research index](references/sources.md) |

For deep PostgreSQL work, use available `postgresql-data-engineering` guidance and versioned upstream documentation instead of duplicating its full handbook. If unavailable, apply this workflow and research the actual engine directly. Redis, authorization, distributed workflows, runtime integration, audits and task coordination may warrant installed companion skills; none should activate automatically just because a database is involved.

## Implement and verify the real outcome

Keep changes focused and compatible with affected consumers. Use established migrations and authorized environments. Explicit read-only scope prohibits fixes or mutating experiments. Destructive DDL, irreversible data changes, backfills and operational actions require actual authorization; preserve authorization already given and prepare concrete impact/recovery details before asking for anything missing.

Derive focused tests from business invariants and actual race/failure windows. Check stored state, relationship/tenant validity, concurrent effects, old/new consumer compatibility and relevant resource costs. Plans, mocks, empty-database migration success and compilation cannot establish production concurrency or recovery. Some profiling commands execute statements; verify engine-specific effects before running them.

Use proportional verification and stop after meaningful checks pass unless a change or unresolved risk warrants more. Normal validation is sufficient for a skill-only change; do not launch benchmark/agent-evaluation infrastructure by default. Report the model decision, evidence, implementation, actual tests, compatibility/rollout implications and remaining uncertainty. Do not claim measured gains or successful restore/failover without execution.
Files in this package (10)
  • LICENSE 1 KB
  • SKILL.md 5 KB
  • agents/openai.yaml 1 KB
  • references/clickhouse.md 5 KB
  • references/integrity-workload-and-evolution.md 7 KB
  • references/modeling-decisions.md 7 KB
  • references/mongodb.md 5 KB
  • references/mysql-and-mariadb.md 5 KB
  • references/sources.md 6 KB
  • references/sqlite.md 4 KB

Versions

The database has no other skills named universal-database-engineering.

Database snapshot: 13.11.2026 · package version 1e6c4280ad16 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100database-design-engineering
    Use when designing or reviewing relational or document-backed data architecture for SaaS platforms, ERP systems, APIs, analytics stores, or mobile sync. Covers domain modeling, tenancy, indexing, migrations, event stream data contract and schema evolution, integrity, retention,…
  • 100database-architect
    Designs relational and NoSQL database schemas, indexing strategies, migration plans, and data modeling patterns. Use when designing a database or when the user mentions database architecture, schema design, or data modeling.
  • 90rc-sql
    Relational query and schema work — indexes, EXPLAIN, N+1, modeling. Read-only by default. Use when reviewing SQL. Not for infra admin.
  • 100database-schema-design
    Designs relational and document database schemas, covering entities, keys, constraints, data types, multi-tenancy, soft deletes, audit columns and access-pattern modeling for NoSQL. Use when doing schema design or data modeling, creating new tables or collections, designing the…
  • 100data-architect
    Use this skill to assess, design, and evolve data architectures, including data platforms, data products, data mesh adoption, event-driven data flows, governance, modeling, and migration decisions. Load it when teams need workload-grounded tradeoffs, ownership and quality…
  • 100schema-designer
    Help design database schemas, create tables, and plan data models. Activates when users ask to create tables, design schemas, or model data relationships.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.