# design-database-schema

> Design optimized database schemas with proper relationships, constraints, and performance considerations

- Source: https://doutorai.pt/en/components/commands__design-database-schema
- Type: Commands
- Category: Setup
- Downloads: 517
- Site: Doutor AI (https://doutorai.pt/en) - AI tools for small businesses

An open-source community component, curated and adapted by Doutor AI.

## What it does and how to use it

A **/slash command**, ready to use, that runs a setup workflow in a single step.

1. Install the command (command above).
2. In Claude Code, type "/" followed by the command name.
3. Follow the instructions the command asks for and let it run.

## Install (Claude Code)

```bash
mkdir -p .claude/commands && curl -fsSL https://doutorai.pt/data/lib/commands__design-database-schema.md -o .claude/commands/design-database-schema.md
```

Paste this command into the terminal, in your project folder, and the component installs automatically.

## Content

```
---
allowed-tools: Read, Write, Edit, Bash
argument-hint: [schema-type] | --relational | --nosql | --hybrid | --normalize
description: Design optimized database schemas with proper relationships, constraints, and performance considerations
---

# Design Database Schema

Design optimized database schemas with comprehensive data modeling: **$ARGUMENTS**

## Current Project Context

- Application type: Based on $ARGUMENTS or codebase analysis
- Data requirements: @requirements/ or project documentation
- Existing schema: @prisma/schema.prisma or @migrations/ or database dumps
- Performance needs:

- 🔒 Full content on the Pro plan (€7.99/month) -
```

## Related components

- [act](https://doutorai.pt/en/components/commands__act): Execute GitHub Actions locally using act
- [add-authentication-system](https://doutorai.pt/en/components/commands__add-authentication-system): Implement secure user authentication system with chosen method and security best practices
- [add-changelog](https://doutorai.pt/en/components/commands__add-changelog): Generate and maintain project changelog with Keep a Changelog format
- [add-mutation-testing](https://doutorai.pt/en/components/commands__add-mutation-testing): Setup comprehensive mutation testing with framework selection and CI integration
- [add-package](https://doutorai.pt/en/components/commands__add-package): Add and configure new package to workspace with proper structure and dependencies
- [add-performance-monitoring](https://doutorai.pt/en/components/commands__add-performance-monitoring): Setup comprehensive application performance monitoring with metrics, alerting, and observability

## Save hours every week with AI, no hassle

**Doutor AI** gives you 1,859 ready-to-copy AI prompts, by industry and in plain English - plus a complete technical library for those who want to go further. [See plans →](https://doutorai.pt/en/pricing)

---
Content by Doutor AI (https://doutorai.pt/en). When quoting, please cite the source: https://doutorai.pt/en/components/commands__design-database-schema