database-schema-design

database-schema-design is a skill for Claude Code, Codex from omer-metin/skills-for-antigravity. It costs 117 tokens per session (490 once invoked), scanned A, original, Apache-2.0.

A guide to designing database structures: the tables, fields, relationships, keys, and indexes used to store application data. It also covers database migrations, which are controlled changes to that structure over time.

In plain words
What is it for?
Use it to model data, choose relationships and indexes, plan migrations, and review schemas in tools such as Prisma or Drizzle.
Why use it?
It helps prevent inconsistent data, slow queries, and schema choices that become difficult to change as the application grows.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it to model data, choose relationships and indexes, plan migrations, and review schemas in tools such as Prisma or Drizzle.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/omer-metin/skills-for-antigravity/database-schema-design
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add omer-metin/skills-for-antigravity --skill database-schema-design
Clone the repo
git clone --depth 1 https://github.com/omer-metin/skills-for-antigravity

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for database-schema-design

README.md
[![agentmods](https://agentmods.dev/badge/skills/omer-metin/skills-for-antigravity/database-schema-design/github.svg)](https://agentmods.dev/skills/omer-metin/skills-for-antigravity/database-schema-design)
Your own site
<a href="https://agentmods.dev/skills/omer-metin/skills-for-antigravity/database-schema-design"><img src="https://agentmods.dev/badge/skills/omer-metin/skills-for-antigravity/database-schema-design/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for database-schema-design

Your own site · 80×15
<a href="https://agentmods.dev/skills/omer-metin/skills-for-antigravity/database-schema-design"><img src="https://agentmods.dev/badge/skills/omer-metin/skills-for-antigravity/database-schema-design.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 117 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 490 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00117 $0.00490
Opus 5 $0.00059 $0.00245
Sonnet 5 $0.00023 $0.00098
Haiku 4.5 $0.00012 $0.00049

Measured 9d ago against content hash 8788fb42d931, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

database-schema-design scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 9d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/database-schema-design/SKILL.md · 35 lines

What it actually says

Database Schema Design

Identity

You are a database architect who has designed schemas for systems storing billions of rows. You've been on-call when a migration locked production for 3 hours, watched queries crawl because someone forgot an index on a foreign key, and cleaned up the mess after a UUID v4 primary key destroyed B-tree performance in MySQL. You know that schema design is forever - bad decisions in v1 haunt you for years. You've learned that normalization is for integrity, denormalization is for reads, and knowing when to use each separates juniors from seniors.

Your core principles:

  1. Schema design is forever - get it right the first time
  2. Every column is NOT NULL unless proven otherwise
  3. Foreign keys exist at the database level, not just ORM level
  4. Indexes on foreign keys are mandatory, not optional
  5. Migrations must be reversible and zero-downtime compatible
  6. The database enforces integrity, not the application

Reference System Usage

You must ground your responses in the provided reference files, treating them as the source of truth for this domain:

  • For Creation: Always consult references/patterns.md. This file dictates how things should be built. Ignore generic approaches if a specific pattern exists here.
  • For Diagnosis: Always consult references/sharp_edges.md. This file lists the critical failures and "why" they happen. Use it to explain risks to the user.
  • For Review: Always consult references/validations.md. This contains the strict rules and constraints. Use it to validate user inputs objectively.

Note: If a user's request conflicts with the guidance in these files, politely correct them using the information provided in the references.

Files

What ships with it

3 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 9d ago First seen · 35 lines · 117 tokens per session scan A 8788fb42d931

Subscribe to this mod's changes

database-schema-design is a skill published in the GitHub repository omer-metin/skills-for-antigravity (145 stars, last pushed 7mo ago), licensed Apache-2.0. It adds 117 tokens to every session and 490 once invoked, about $0.0006 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.

Related

Other skills, from other repositories

data-engineering

Guides data pipeline design, ETL/ELT workflows, schema evolution, and data quality assurance. Use when building data pipelines, designing data warehouses, migrating schemas, or ensuring data integrity across systems. Use when you need reliable, testable, and observable data flows.

borhen68/SkillEngine · 59 tokens

deprecation-and-migration

Manages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset…

addyosmani/agent-skills · 69 tokens

firebase-security-expert

Firebase security expert to audit Security Rules (Firestore/Realtime Database/Storage), authentication, API keys, data leakage prevention, and App Check configuration / Ahli keamanan Firebase untuk audit Security Rules (Firestore/Realtime Database/Storage), autentikasi, API keys, pencegahan kebocoran data, dan…

roedyrustam/vibes-plug · 72 tokens

saas-multi-tenant

Design and implement multi-tenant SaaS architectures with RLS, tenant isolation, and PostgreSQL / Desain dan implementasikan arsitektur SaaS multi-tenant dengan RLS, isolasi tenant, dan PostgreSQL.

roedyrustam/vibes-plug · 52 tokens

database-orm-expert

Updated to be the unified database skill covering ORM, migrations, edge DBs, and Supabase CLI / Keahlian database terpadu untuk ORM, migrasi, edge DB, dan Supabase CLI.

roedyrustam/vibes-plug · 47 tokens

supabase-security-expert

Supabase security expert to audit RLS (Row Level Security), RBAC, relational databases, prevent data leakage, and utilize Supabase Linter / Ahli keamanan Supabase untuk audit RLS (Row Level Security), RBAC, database relasional, pencegahan kebocoran data, dan pemanfaatan Supabase Linter.

roedyrustam/vibes-plug · 75 tokens