Database Design Expert
Expert in database schema design with focus on normalization, indexing strategies, FTS optimization, and performance-oriented architecture for desktop applications
Install
npx skills add martinholovsky/claude-skills-generator --skill Database Design Expertgit clone --depth 1 https://github.com/martinholovsky/claude-skills-generator.git /tmp/claude-skills-generator
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills-generator/skills/database-design ~/.claude/skills/Database-Design-ExpertPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Database Design Expert ## 0. Mandatory Reading Protocol **CRITICAL**: Before implementing ANY database schema, you MUST read the relevant reference files: ### Trigger Conditions for Reference Files **Read `references/advanced-patterns.md` WHEN**: - Designing schemas for new features - Implementing complex relationships (many-to-many, polymorphic) - Setting up inheritance patterns - Designing for high-performance queries **Read `references/security-examples.md` WHEN**: - Storing sensitive user data - Designing audit trails - Implementing access control at database level - Handling PII or financial data --- ## 1. Overview **Risk Level: MEDIUM** **Justification**: Database schema design impacts data integrity, query performance, and application security. Poor design can lead to data corruption, performance bottlenecks, and difficulty in maintaining data consistency. Schema changes in production require careful migration planning. You are an expert in database schema design, specializing in: - **Normalization** with appropriate denormalization for performance - **Indexing strategies** for query optimization - **Full-Text Search (FTS5)** schema design - **Constraint design** for data integrity - **Migration-friendly schemas** that evolve safely ### Core Principles 1. **TDD First** - Write tests for schema and queries before implementation 2. **Performance Aware** - Design for query patterns, optimize indexes, profile regularly
Details
- Skill name
Database Design Expert- Repository
- martinholovsky/claude-skills-generator
- Path
skills/database-design/SKILL.md- License
- Unlicense
- Repo updated
- 6 December 2025
FAQ
What does the Database Design Expert skill do?
Expert in database schema design with focus on normalization, indexing strategies, FTS optimization, and performance-oriented architecture for desktop applications
How do I install the Database Design Expert skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add martinholovsky/claude-skills-generator --skill Database Design Expert. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Database Design Expert popular?
It lives in martinholovsky/claude-skills-generator, which has 48 GitHub stars and 4 forks.
Related skills
API Expert
48martinholovsky/claude-skills-generator
Expert API architect specializing in RESTful API design, GraphQL, gRPC, and API security. Deep expertise in OpenAPI 3.1, authentication patterns (OAuth2, JWT), rate limiting, pagination, and OWASP API Security Top 10. Use when designing scalable APIs, implementing API gateways, or securing API endpoints.
Applescript
48martinholovsky/claude-skills-generator
Expert in AppleScript and JavaScript for Automation (JXA) for macOS system scripting. Specializes in secure script execution, application automation, and system integration. HIGH-RISK skill due to shell command execution and system-wide control capabilities.
Appsec Expert
48martinholovsky/claude-skills-generator
Elite Application Security engineer specializing in secure SDLC, OWASP Top 10 2025, SAST/DAST/SCA integration, threat modeling (STRIDE), and vulnerability remediation. Expert in security testing, cryptography, authentication patterns, and DevSecOps automation. Use when securing applications, implementing security controls, or conducting security assessments.
Graph Database Expert
48martinholovsky/claude-skills-generator
Expert in graph database design and development with deep knowledge of graph modeling, traversals, query optimization, and relationship patterns. Specializes in SurrealDB but applies generic graph database concepts. Use when designing graph schemas, optimizing graph queries, implementing complex relationships, or building graph-based applications.
Receipt Tracker Setup
46zocomputer/skills
Automatically scans receipts you drop in a folder, extracts the details, and saves them to a searchable database
SQLCipher Encrypted Database Expert
48martinholovsky/claude-skills-generator
Expert in SQLCipher encrypted database development with focus on encryption key management, key rotation, secure data handling, and cryptographic best practices
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.