# Database Design

> >-

- **Type:** Skill
- **Install:** `agentstack add skill-viktorbezdek-skillstack-database-design`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [viktorbezdek](https://agentstack.voostack.com/s/viktorbezdek)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [viktorbezdek](https://github.com/viktorbezdek)
- **Source:** https://github.com/viktorbezdek/skillstack/tree/main/database-design/skills/database-design

## Install

```sh
agentstack add skill-viktorbezdek-skillstack-database-design
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# database-design

SQL schema design, ORM patterns, migration strategies, query optimisation, and data-modelling for relational databases.

## When to use

- Design a schema for a multi-tenant SaaS application
- Write an Alembic migration to add a non-null column to an existing table
- This query takes 4 seconds, help me add the right index
- Should I use a junction table or an array column for tags?
- Model a user → orders → line-items hierarchy in SQLAlchemy
- What constraints should I add to prevent orphaned records?
- Explain the difference between 3NF and BCNF
- Write a Drizzle ORM schema for a blog with posts, tags, and comments

## When NOT to use

- How do I set up PostgreSQL connection pooling with pgBouncer? — Connection pooling config — NOT data modelling
- Configure Redis as a session store — NoSQL / caching — out of scope
- Set up a Kafka consumer for event streaming — ETL / streaming pipeline — out of scope
- How do I back up my PostgreSQL database? — Operations/DBA — not schema engineering

## Anti-patterns

### Symptom
Invoking this skill for tasks outside its scope — e.g., infrastructure concerns when the request is about application code, or vice versa.

### Problem
Scope mismatch wastes context and produces advice tuned for the wrong domain. A database schema skill answering a connection-pooling question gives schema advice when the real problem is operational configuration.

### Solution
Read the NOT for clauses carefully. If the request matches an exclusion, identify the correct skill (check SkillStack for the right domain) rather than stretching this skill to cover adjacent ground.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [viktorbezdek](https://github.com/viktorbezdek)
- **Source:** [viktorbezdek/skillstack](https://github.com/viktorbezdek/skillstack)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-viktorbezdek-skillstack-database-design
- Seller: https://agentstack.voostack.com/s/viktorbezdek
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.