← Back to Skills

Database Design Expert

🌐Community
by martinholovsky · vlatest · Repository

Helps with database, design as part of working with databases and data persistence workflows.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add database-design-expert npx -- -y @trustedskills/database-design-expert
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "database-design-expert": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/database-design-expert"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill assists AI agents in designing database schemas, specializing in normalization and denormalization for performance optimization. It focuses on creating migration-friendly schemas that evolve safely while prioritizing data integrity, query performance, and application security. The skill emphasizes test-driven development (TDD) and a performance-aware approach to database design, particularly within the context of SQLite databases.

When to use it

  • Designing schemas for new features in desktop applications or local-first architectures.
  • Implementing complex relationships like many-to-many or polymorphic associations.
  • Setting up inheritance patterns within your database schema.
  • Creating audit and history tracking mechanisms.
  • Storing sensitive user data, requiring careful consideration of security examples.

Key capabilities

  • Normalization with strategic denormalization for performance.
  • Indexing strategies for query optimization.
  • Full-Text Search (FTS5) schema design.
  • Constraint design to ensure data integrity (primary keys, foreign keys, unique constraints).
  • Designing migration-friendly schemas that can be safely evolved.
  • Guidance on SQLite data types (INTEGER, TEXT, REAL, BLOB, NUMERIC).

Example prompts

  • "Design a database schema for storing user profiles with audit trails."
  • "I need to implement a many-to-many relationship between products and categories. Can you help me design the schema?"
  • "What are some best practices for indexing in SQLite when designing for efficient search?"

Tips & gotchas

  • Mandatory Reading: Before implementing any database schema, carefully review references/advanced-patterns.md and references/security-examples.md. These documents contain crucial information for advanced patterns and security considerations.
  • The skill prioritizes a TDD approach – write tests for your schema and queries before implementation.
  • Start with normalization (3NF) and then strategically denormalize based on measured performance needs.
View Repository →

Tags

🛡️

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
martinholovsky
Installs
75
Repository (canonical source) →

🌐 Community

Passed automated security scans.