Skip to content
TrustedSkillsbeta
Back to all skills

Designing Database Schemas

Listed
jeremylongshore·vlatest·database·MIT

Designs efficient and normalized relational database schemas based on provided data requirements and constraints.

Repository

Install on your platform

Showing Claude Code. One command installs this skill into any of the agents below.

  1. 1

    Run this in your project

    terminal
    $ npx skills add jeremylongshore/tons-of-skills-marketplace --skill designing-database-schemas -a claude-code

  2. Uses the open-source skills CLI and needs Node.js. Add -g to install it for your user instead of this project.

What we know about this skill

Publisher

jeremylongshore

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. none of the 396 skills in the repository match this slug — it was most likely renamed or removed upstream after the registry indexed it Source recorded as jeremylongshore/claude-code-plugins-plus-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill allows AI agents to design database schemas based on user requirements. It can define tables, columns, data types, and relationships between entities. The agent will produce a textual representation of the schema suitable for implementation in various database systems.

When to use it

  • You need to quickly prototype a database structure for a new application.
  • You're refactoring an existing database and want assistance with designing improvements.
  • You have complex data relationships that require careful consideration when structuring a database.
  • You’re teaching someone about relational databases and want a demonstration of schema design.

Key capabilities

  • Defines tables and columns.
  • Specifies appropriate data types for columns.
  • Establishes relationships between tables (e.g., one-to-many, many-to-many).
  • Generates textual database schema representations.

Example prompts

  • "Design a database schema for an online bookstore, including tables for books, authors, and customers."
  • "Create a relational database schema to track student enrollment in courses, with details on students, courses, and instructors."
  • “I need a database design for managing inventory in a warehouse. Include tables for products, suppliers, and shipments.”

Tips & gotchas

The agent's output is a textual representation; you may need to adapt it slightly depending on the specific database system (e.g., MySQL, PostgreSQL) you intend to use. Providing clear and detailed requirements will result in more accurate and useful schema designs.