davila7 avatar

Database Schema Designer

This handles the full lifecycle of database design, from initial schema generation to migration scripts. Feed it your data model (users, products, orders) and you get normalized SQL or NoSQL schemas with proper foreign keys, indexes, and constraints. The normalization guides are thorough, walking through 1NF to 3NF with before/after examples. It includes a solid anti-patterns section that catches common mistakes like using FLOAT for money or missing FK indexes. The verification checklist is legitimately useful for code reviews. Best for greenfield projects or major refactors where you want to avoid the usual schema debt, though it assumes you can articulate your access patterns upfront.

skills.sh installs
489
GitHub stars
33.2K
last updated
Aug 21, 2026

Install

$ npx -y skills add davila7/claude-code-templates --skill database-schema-designer --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Schema Designer

Design production-ready database schemas with best practices built-in.


Quick Start

Just describe your data model:

design a schema for an e-commerce platform with users, products, orders

You'll get a complete SQL schema like:

CREATE TABLE users (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE orders (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT NOT NULL REFERENCES users(id),
  total DECIMAL(10,2) NOT NULL,
  INDEX idx_orders_user (user_id)
);

What to include in your request:

  • Entities (users, products, orders)
  • Key relationships (users have orders, orders have items)
  • Scale hints (high-traffic, millions of records)
  • Database preference (SQL/NoSQL) - defaults to SQL if not specified

Triggers

Sponsors

Details

Repository
github.com/davila7/claude-code-templates
Categories
Backend & APIs, Debugging, Design & UI/UX, Databases
First seen
Jun 3, 2026

More from davila7/claude-code-templates

All 618
1yoanbernabeu avatarsupabase-extract-jwtyoanbernabeu/supabase-pentest-skillsExtract and decode Supabase-related JWTs from client-side code, cookies, and local storage patterns.487skills.sh installs
2secondsky avatarpayment-gateway-integrationsecondsky/claude-skillsIntegrates payment processing with Stripe, PayPal, or Square including subscriptions, webhooks, and PCI compliance. Use when implementing checkout flows, recurr469skills.sh installs
3jezweb avatargoogle-gemini-apijezweb/claude-skillsIntegrate Gemini API with @google/genai SDK (NOT deprecated @google/generative-ai). Text generation, multimodal (images/video/audio/PDFs), function calling, thi467skills.sh installs
4jezweb avataropenai-apijezweb/claude-skillsBuild with OpenAI stateless APIs - Chat Completions (GPT-5.2, o3), Realtime voice, Batch API (50% savings), Embeddings, DALL-E 3, Whisper, and TTS. Prevents 16 465skills.sh installs
5manutej avatarvector-database-managementmanutej/luxor-claude-marketplaceComprehensive guide for managing vector databases including Pinecone, Weaviate, and Chroma for semantic search, RAG systems, and similarity-based applications460skills.sh installs
6yoanbernabeu avatarsupabase-audit-authenticatedyoanbernabeu/supabase-pentest-skillsCreate a test user (with explicit permission) to audit what authenticated users can access vs anonymous users. Detects IDOR, cross-user access, and privilege es446skills.sh installs