mcpbeat Sign in

Database Schema Designer Skill for Claude

by OneWave-AI

Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.

2k tokens
context cost
the whole folder, loaded on every use
4
files
instructions only
0
copies elsewhere
how many repositories repackaged it
235
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository 
npx skills add https://github.com/OneWave-AI/claude-skills --skill database-schema-designer

The instruction itself

4 sections, as written by the author

Database Schema Designer

Design optimized, scalable database schemas with proper relationships and indexes.

Contents

  • references/schema-templates.md — SQL/NoSQL schema templates, ASCII ERD, and migration script templates.
  • references/output-format.md — labeled section structure for the final deliverable.
  • references/best-practices.md — naming, data types, indexes, relationships, SQL/NoSQL design rules, and the output quality checklist.

Workflow

  • Gather requirements. Determine the database engine (PostgreSQL, MySQL, MongoDB, etc.), application domain, main entities, most common queries, expected data volume and growth, performance requirements, and any compliance constraints.
  • Design the schema. Apply the engine-appropriate rules in references/best-practices.md (SQL Database Design or NoSQL Database Design).
  • Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in references/schema-templates.md.
  • Create the entity relationship diagram in text format following the ERD template in references/schema-templates.md.
  • Provide migration scripts with both up and down (rollback) paths, per the migration template in references/schema-templates.md.
  • Format the complete output using the labeled sections in references/output-format.md.
  • Verify the result against the output quality checklist in references/best-practices.md.

Example Triggers

  • "Design a database schema for an e-commerce platform"
  • "Create SQL tables for a blog system"
  • "Help me design a MongoDB schema for a social network"
  • "Optimize this database schema for performance"
  • "Generate migration scripts for my schema"

Generate production-ready, optimized database schemas that scale.

Other skills for the same job

different authors, same section of the catalogue
Biorxiv Database
by christophacham
×4

Efficient database search tool for bioRxiv preprint server. Use this skill when searching for life sciences preprints by keywords, authors, date ranges, or categories, retrieving paper metadata, downloading PDFs, or conducting literature reviews.

9k tokens scripts
Brenda Database
by christophacham
×4

Access BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.

36k tokens scripts
Clinpgx Database
by christophacham
×4

Access ClinPGx pharmacogenomics data (successor to PharmGKB). Query gene-drug interactions, CPIC guidelines, allele functions, for precision medicine and genotype-guided dosing decisions.

13k tokens scripts
Clinvar Database
by christophacham
×4

Query NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.

10k tokens
Cosmic Database
by christophacham
×4

Access COSMIC cancer mutation database. Query somatic mutations, Cancer Gene Census, mutational signatures, gene fusions, for cancer research and precision oncology. Requires authentication.

6k tokens scripts
Ensembl Database
by christophacham
×4

Query Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research.

8k tokens scripts
Fda Database
by christophacham
×4

Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.

32k tokens scripts
Gene Database
by christophacham
×4

Query NCBI Gene via E-utilities/Datasets API. Search by symbol/ID, retrieve gene info (RefSeqs, GO, locations, phenotypes), batch lookups, for gene annotation and functional analysis.

13k tokens scripts

How to use it

Copy the folder

Take onewave-ai/database-schema-designer from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.