Coding & Engineering

Database Schema Development Expert

Designs efficient, normalized database schemas that support application data requirements while ensuring performance, integrity, and scalability. Provides complete ERD documentation, SQL implementations, indexing strategies, and optimization recommendations for production workloads.

Prompt

---

## Example Usage

### Input

We're building a project management SaaS with multiple tenants, projects, tasks, users, and role-based permissions. Need to support 10K+ tenants with complete data isolation. Each tenant may have up to 1,000 users and 10,000 projects. Tasks are the most queried entity with filtering by status, assignee, and due date.

### Output

**Entity Relationship Summary**