Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Database Schema Designer · aiskillstore | DecimalAI

databy aiskillstore

Database Schema Designer

aiskillstore/database-schema-designer

Source aiskillstore/marketplace ↗License Not recorded

Use this skill when designing database schemas for relational (SQL) or document (NoSQL) databases. Provides normalization guidelines, indexing strategies, migration patterns, and performance optimization techniques. Ensures scalable, maintainable, and performant data models.

SkillScore88Maintained

Automatic

Data Engineer packdatabaseschema-designsql

Last verified 9/2/2026

What it changes

Passed 22 of 25 test cases with the skill, and 21 of 25 without it.

Without skill84%

With skill88%

Checks it passed that the model alone missed

Uses TIMESTAMP data type

1 fixed21 passed either way3 still failing0 broke

Pass-rate lift: +4 pp
Tokens: +248%
Agent turns: 0%
Response time: -7%

Model gemini-3.6-flashMeasured 9/2/2026v122 of 25 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/aiskillstore-database-schema-designer/SKILL.md https://app.decimal.ai/s/aiskillstore-database-schema-designer/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add aiskillstore-database-schema-designer, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/aiskillstore-database-schema-designer/ and pins it in .decimal/skills.lock

decimalai skills add aiskillstore-database-schema-designer

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/aiskillstore-database-schema-designer/SKILL.md https://app.decimal.ai/s/aiskillstore-database-schema-designer/SKILL.md

Raw file: /s/aiskillstore-database-schema-designer/SKILL.md ↗ · machine-readable summary at /s/aiskillstore-database-schema-designer.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

A test case the skill fixed. Same model, same prompt, with and without the skill.

Prompt

We need a creation timestamp column for our user account records in MySQL that defaults to current time when a row is inserted and automatically updates when modified. How should this column be defined in SQL?

What was checked, without and with the skill
Checked	Without skill	With skill
Uses TIMESTAMP data type	Missed	Passed
Includes DEFAULT CURRENT_TIMESTAMP clause	Passed	Passed
Includes ON UPDATE CURRENT_TIMESTAMP clause	Passed	Passed

case-02 · gemini-3.6-flash · 9/2/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md710 lines2 files

Database Schema Designer

Overview

This skill provides comprehensive guidance for designing robust, scalable database schemas for both SQL and NoSQL databases. Whether building from scratch or evolving existing schemas, this framework ensures data integrity, performance, and maintainability.

When to use this skill:

Designing new database schemas
Refactoring or migrating existing schemas
Optimizing database performance
Choosing between SQL and NoSQL approaches
Creating database migrations
Establishing indexing strategies
Modeling complex relationships
Planning data archival and partitioning

Database Design Philosophy

Core Principles

1. Model the Domain, Not the UI

Schema reflects business entities and relationships
Don't let UI requirements drive data structure
Separate presentation concerns from data model

2. Optimize for Reads or Writes (Not Both)

OLTP (transactional): Normalized, optimized for writes
OLAP (analytical): Denormalized, optimized for reads
Choose based on access patterns

3. Plan for Scale From Day One

Indexing strategy
Partitioning approach
Caching layer
Read replicas

4. Data Integrity Over Performance

Use constraints, foreign keys, validation
Performance issues can be optimized later
Data corruption is costly to fix

Track record

Benchmark

22 / 25

test cases passed, vs 21 / 25 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan14 of 15 checks clean

0 critical · 0 warning · 2 info — scanner v4 — 8/10/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

No issues (informational notes only).

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

aiskillstore / marketplace

skills/ariegoldkin/database-schema-designer/SKILL.md

View on GitHub ↗

Imported 8/10/2026Version v1Bundled 1 file

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Database Schema Designer

Overview

Database Design Philosophy

Core Principles

Track record

Benchmark

Adoption

SkillSafety

Source

Other skills for the same job

Related skills