skills.rest
sitechfromgeorgia
sitechfromgeorgiaCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-architect

Design and optimize SQL and NoSQL database schemas with migrations and security policies.

Updated Aug 27, 2026
Search Tags:#design#indexing#database#migrations#schema#GDPR#normalization
One-click install
npx skills add https://github.com/sitechfromgeorgia/georgian-distribution-system --skill database-schema-architect
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-architect
Source: https://github.com/sitechfromgeorgia/georgian-distribution-system/tree/main/.claude/skills/database-schema-architect
Command: npx skills add https://github.com/sitechfromgeorgia/georgian-distribution-system --skill database-schema-architect

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill provides expert guidance for designing, optimizing, and maintaining scalable database schemas across SQL and NoSQL platforms, ensuring data integrity and performance.

Core Features & Use Cases

  • Normalization strategy: guidance from 1NF to 3NF with practical examples to reduce redundancy.
  • Indexing and data types: best practices for primary keys, foreign keys, constraints, and data type choices for performance and storage efficiency.
  • Migration and security: templates and checklists for safe migrations, RLS patterns, and GDPR-aligned privacy considerations.

Quick Start

  • Read the SKILL.md frontmatter for scope and recommended practices.
  • Review the example E-commerce schema in the references to see normalization and indexing in action.
  • Use the scripts in the scripts/ directory to generate migrations and validate schema changes.

Frequently Asked Questions about database-schema-architect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a scalable database schema for both SQL and NoSQL platforms?▼

Design scalable database schemas by applying normalization strategies, selecting appropriate data types, and implementing indexing best practices to ensure data integrity and performance across SQL and NoSQL systems.

What's the best way to plan safe database migrations without losing data?▼

Plan safe database migrations using provided templates and checklists that guide schema changes step by step, validating updates to prevent data loss and maintain structural integrity during transitions.

How does normalization from 1NF to 3NF reduce data redundancy in my schema?▼

Normalization from 1NF to 3NF reduces data redundancy by organizing fields and relationships systematically, minimizing duplicate data storage and improving overall database consistency.

Can I implement GDPR compliance and row-level security policies in my database design?▼

Implement GDPR compliance and row-level security by applying aligned privacy considerations and RLS patterns provided in the schema design guidelines to protect sensitive data.

What are the best practices for choosing primary keys, foreign keys, and indexing strategies?▼

Choose primary keys, foreign keys, and indexing strategies based on best-practice guidance that balances query performance with storage efficiency, utilizing constraints to enforce data relationships.

Related Skills

Explore More Software Engineering Skills→
CinderZhangCinderZhang
3

represent-datamodel

Define core system entities and their plain-language relationships.

Community
Basic
jeremylongshorejeremylongshore
2.6k

comparing-database-schemas

Compare PostgreSQL or MySQL schemas and generate transaction-safe migration scripts.

Community
Advanced
phuonghxphuonghx
1

database-design

Guide database schema modeling, indexing, ORM selection, and query optimization.

Community
Advanced
OneWave-AIOneWave-AI
245

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

Official
Basic