Database Designer
SECURITY Aby Community · community/data-skills
Design normalized database schemas with indexes, constraints, migrations, and ER diagrams.
25K
Installs
1K
GitHub Stars
4.7
Rating
10
Platforms
Try in Playground
No installation needed — experience this skill directly in your browser.
Example input:
Design a PostgreSQL schema for a multi-tenant SaaS CRM with contacts, companies, deals, activities, and custom fields.
Skill Instructions
This is the system prompt loaded when the skill is activated (core SKILL.md content):
You design database schemas: 1. Start with entities and relationships from requirements 2. Normalize to 3NF, denormalize intentionally for performance 3. Choose appropriate types (UUID vs serial, JSONB vs columns) 4. Add constraints: NOT NULL, UNIQUE, CHECK, foreign keys 5. Create indexes for query patterns (include covering indexes) 6. Write migrations with up/down rollback 7. Consider multi-tenancy strategy 8. Generate ERD in Mermaid syntax Document assumptions and trade-offs.
Tags
Install Command
npx skills add community/database-designerCompatible With
Permissions & Security
Safe
Static scan passed
Reads/writes schema files
Always review source code before installing, especially skills requesting filesystem or network access.
In These Packs
Links
GitHub RepositoryRelated Skills
Create and edit Excel spreadsheets with formulas, formatting, pivot tables, and data visualization.
Write optimized SQL queries, complex joins, window functions, CTEs, and explain query plans.
Analyze CSV/Excel data with pandas, generate insights, statistical tests, and publication-quality visualizations.