Codebase Exploration
giancarloerra/SocratiCode
Explore and understand codebases using SocratiCode semantic search, dependency graphs, and context artifacts.
Design schemas and migrations when persistent data structures change.
Install Database Design
$ npx skills add KbWen/agentic-os --skill database-design -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install KbWen/agentic-os database-design --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/KbWen/agentic-os.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/database-design .claude/skills/database-design && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "database-design" agent skill from https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-design into .claude/skills/database-design/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-design", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-designType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add KbWen/agentic-os --skill database-design -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install KbWen/agentic-os database-design --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/KbWen/agentic-os.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/database-design .agents/skills/database-design && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "database-design" agent skill from https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-design into .agents/skills/database-design/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-design", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add KbWen/agentic-os --skill database-design -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install KbWen/agentic-os database-design --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/KbWen/agentic-os.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/database-design .cursor/skills/database-design && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "database-design" agent skill from https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-design into .cursor/skills/database-design/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-design", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/KbWen/agentic-os.git --path .agents/skills/database-design--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add KbWen/agentic-os --skill database-design -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install KbWen/agentic-os database-design --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/KbWen/agentic-os.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/database-design .gemini/skills/database-design && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "database-design" agent skill from https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-design into .gemini/skills/database-design/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-design", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install KbWen/agentic-os database-designInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add KbWen/agentic-os --skill database-design -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/KbWen/agentic-os.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/database-design .github/skills/database-design && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "database-design" agent skill from https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-design into .github/skills/database-design/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-design", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add KbWen/agentic-os --skill database-design -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install KbWen/agentic-os database-design --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/KbWen/agentic-os.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/database-design .opencode/skills/database-design && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "database-design" agent skill from https://github.com/KbWen/agentic-os/tree/main/.agents/skills/database-design into .opencode/skills/database-design/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-design", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
database-design- GitHub stars
- 206
- Token cost
- ~1.2k tokens
- SKILL.md length
- 588 words
- Files
- 2
- Skills in repo
- 12
- Repo updated
- First seen
- Licence
- MIT
At a glance
Design schemas and migrations when persistent data structures change.
- Tasks that involve Database schema design
- SKILL.md covers When to Apply, Conventions, Checklist and Heading-Scoped Read Note, plus 2 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Database Design is an agent skill from KbWen/agentic-os. Design schemas and migrations when persistent data structures change.
Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `agents/openai.yaml`).
It sits in Databases, covering Database schema design. The repository describes itself as: Governance framework for AI coding agents. It runs them through a five-step workflow (plan, build, review, test, ship) where no step counts as done without evidence. Drop-in… The licence is MIT.
When your agent uses it
- Tasks that involve Database schema design
Example prompts
- “/database-design”
What it can do on your machine
Read from SKILL.md and the folder at commit 81a4034. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Database Design loads about 1.2k tokens when it runs. Until then it costs about 21 tokens; SKILL.md has 588 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from KbWen/agentic-os at commit 81a4034, republished under its MIT licence (© KbWen). 588 words, ~1,242 tokens.
Download SKILL.mdSave it as
.claude/skills/database-design/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- database-design
- description
- Design schemas and migrations when persistent data structures change.
<!-- This is a SCAFFOLD skill -->Database Design
When to Apply
- Classification: feature (if new tables/columns), architecture-change (schema redesign), hotfix (data-related bug)
- Phase: /plan (schema design), /implement (migration creation), /review (schema review), /test (data integrity)
- Trigger: Task involves creating tables, modifying schema, writing migrations, or changing data access patterns
Conventions
Customize after /app-init: Replace these generic conventions with your project's ADR and ORM-specific patterns.
Table Design
- Every table MUST have:
id(primary key),created_at,updated_at - Use UUIDs or auto-increment IDs consistently (per ADR decision)
- Soft delete: add
deleted_atcolumn if ADR specifies soft delete - Table names: plural, snake_case (e.g.,
users,order_items) - Column names: snake_case (e.g.,
first_name,is_active)
Relationship Patterns
| Relationship | Implementation | Example |
|---|---|---|
| One-to-Many | Foreign key on "many" side | orders.user_id → users.id |
| Many-to-Many | Junction table | user_roles (user_id, role_id) |
| One-to-One | Foreign key + unique constraint | user_profiles.user_id (UNIQUE) → users.id |
| Self-referencing | Foreign key to same table | categories.parent_id → categories.id |
Index Strategy
- Every foreign key column MUST have an index
- Columns used in WHERE clauses frequently → add index
- Composite indexes: put the most selective column first
- Unique constraints for business uniqueness rules (email, username, etc.)
- DO NOT over-index: every index slows writes
Migration Rules
- One migration per logical change (don't mix table creation with data backfill)
- Migrations MUST be reversible: every
upmust have a correspondingdown - Never modify a shipped migration: create a new migration instead
- Data migrations separate from schema migrations: schema first, data second
- Test rollback: after writing migration, verify
downworks cleanly
Query Patterns
- Use parameterized queries / ORM bindings — NEVER string concatenation for SQL
- Limit SELECT columns:
SELECT id, namenotSELECT * - Add
LIMITto all list queries (even if paginated — belt and suspenders) - Use transactions for multi-table writes
- Batch inserts for bulk operations (not one INSERT per row)
Data Integrity
- Foreign key constraints enforced at DB level (not just application level)
- NOT NULL on required fields (don't rely on application validation alone)
- CHECK constraints for enum-like fields or value ranges
- Default values for fields that have sensible defaults
Show full SKILL.md (269 more words)Show less
Checklist
During /plan:
- Schema changes documented in spec (new tables, modified columns)
- Indexes planned for query patterns
- Migration rollback strategy defined
- Data backfill plan (if modifying existing tables with data)
During /implement:
- Migration file created (not manual SQL against DB)
- Foreign keys have indexes
- NOT NULL and DEFAULT constraints set appropriately
- Migration tested: up → verify → down → verify → up
- No raw SQL string concatenation (use parameterized queries)
During /review:
- No N+1 queries (use eager loading / JOIN where appropriate)
- Transaction boundaries correct (all-or-nothing for related writes)
- No schema changes without migration file
- Backward compatibility: old code can still function until deployed together
- Sensitive data columns identified (for encryption/hashing per security guardrails)
Heading-Scoped Read Note
For phase-entry loading, read only:
When to ApplyChecklist
Load Conventions, Anti-Patterns, and References on full read or cache miss only.
Anti-Patterns
- Schema via ORM only: Relying on ORM auto-sync without migration files. No rollback, no history, no review.
- God table: One table with 30+ columns. Normalize or split by domain.
- Missing indexes on FK: Every foreign key needs an index. Databases don't add them automatically (except some).
- String-typed everything: Using VARCHAR for dates, numbers, booleans. Use proper types.
- No migration rollback: Writing
upwithoutdown. You will need to rollback someday. - Mixing DDL and DML: Schema changes and data backfill in the same migration. Split them.
- SELECT * in production code: Fetching all columns when you need two. Wastes memory and bandwidth.
- Trusting application-only validation: No DB constraints means bad data WILL get in eventually.
References
- Project ADR:
docs/adr/ADR-002-project-architecture.md§ Database Design - Security guardrails:
.agent/rules/security_guardrails.md(A03: SQL Injection, A02: Secrets in connection strings) - Spec template:
.agentcortex/templates/spec-app-feature.md§ Database Schema
© KbWen, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 1 other file in .agents/skills/database-design of KbWen/agentic-os.
- SKILL.md
- agents/openai.yaml
Open the folder on GitHubat commit 81a4034
Compare with similar skills
Database Design next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Database Design this skillKbWen/agentic-os | 206 | — | ~1.2k | Automated safety check: Pass | MIT | |
| Codebase Explorationgiancarloerra/SocratiCode | 3.3k | 1 repos | ~1.5k | Automated safety check: Pass | AGPL-3.0 | |
| Tool Schema Designseb1n/awesome-ai-agent-skills | 206 | — | ~1.5k | Automated safety check: Pass | MIT | |
| Together SDK Patternsjeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~1k | Automated safety check: Pass | MIT | |
| Ma Margin Normalizationhh-health-AI/healthcare-equity | 101 | — | ~840 | Automated safety check: Pass | MIT | |
| Add Memory KindEverMind-AI/EverOS | 13k | — | ~2.6k | Automated safety check: Pass | Apache-2.0 |
Similar skills
Tool Schema Design
seb1n/awesome-ai-agent-skills
Design and validate model-facing tool definitions with clear names, action-oriented descriptions, bounded JSON Schema parameters, explicit side effects, safe defaults, idempotency, errors, and…
Together SDK Patterns
jeremylongshore/tons-of-skills-marketplace
Encapsulate Together AI SDK v2 behind a typed adapter with catalog-resolved models, bounded retries, streaming normalization, usage capture, and OpenAI-compatible migration seams.
Ma Margin Normalization
hh-health-AI/healthcare-equity
This skill should be used when the user asks about "Medicare Advantage margins", "MLR", "Star Ratings", "MA enrolment", "risk adjustment", "MedPAC benchmark", "payor margin normalisation"…
Add Memory Kind
EverMind-AI/EverOS
Walks through adding a new persisted memory kind to EverOS: choose storage among Markdown, SQLite and LanceDB, pick a Markdown strategy, then wire schemas, repos and writers.
SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
More from KbWen/agentic-os
All 12 skills in this repoAPI Design
KbWen/agentic-os
Design or review REST/GraphQL APIs when endpoints or contracts change.
Frontend Patterns
KbWen/agentic-os
Apply frontend conventions when components, pages, forms, or client state change.
Karpathy Principles
KbWen/agentic-os
Behavioral guidelines to reduce common LLM coding mistakes — Think Before Coding, Simplicity First, Surgical Changes, Goal-Driven Execution.
Production Readiness
KbWen/agentic-os
Use at review and ship, automatically for feature or architecture changes and on request for error handling, logging, crash reporting, or observability; verify errors reach production monitoring.
Doc Lookup
KbWen/agentic-os
Check official docs when framework APIs or configuration may be version-sensitive.
Systematic Debugging
KbWen/agentic-os
A skill your agent uses when investigating a bug, test failure, flaky test, unexpected behavior, or a hotfix, or an unexplained or failed fix; find the root cause first.
Related
Questions about Database Design
What does Database Design do?
Design schemas and migrations when persistent data structures change. Database Design is an agent skill from KbWen/agentic-os. Design schemas and migrations when persistent data structures change.
When should I use Database Design?
Database Design fits situations like: tasks that involve Database schema design.
How do I install Database Design in Claude Code?
Run `npx skills add KbWen/agentic-os --skill database-design -a claude-code`. Or copy the skill folder (.agents/skills/database-design in KbWen/agentic-os) into .claude/skills/database-design in your project. Claude Code loads it when a task matches its description.
How do I install Database Design in Codex?
Run `npx skills add KbWen/agentic-os --skill database-design -a codex`. Or copy the skill folder (.agents/skills/database-design in KbWen/agentic-os) into .agents/skills/database-design in your project. Codex loads it when a task matches its description.
Can I use Database Design in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add KbWen/agentic-os --skill database-design -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-design, .gemini/skills/database-design, .github/skills/database-design and .opencode/skills/database-design in your project.
What does Database Design need to run?
SKILL.md names no scripts, command-line tools or credentials: Database Design is instructions for the agent only.
Does Database Design access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Database Design safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Database Design use?
Database Design is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Database Design use?
About 1.2k tokens (SKILL.md is roughly 5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Database Design?
Skills that share tags, products or a category with Database Design: Codebase Exploration (giancarloerra/SocratiCode, 3.3k stars), Tool Schema Design (seb1n/awesome-ai-agent-skills, 206 stars), Together SDK Patterns (jeremylongshore/tons-of-skills-marketplace, 2.8k stars) and Ma Margin Normalization (hh-health-AI/healthcare-equity, 101 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Database Design?
KbWen (a GitHub user) maintains it in KbWen/agentic-os, which has 206 GitHub stars. The repository holds 12 skills in this directory. The repository was last updated on October 6, 2026.
Source: KbWen/agentic-os on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.