Database Schema Designer
ListedHelps with database, schema design as part of working with databases and data persistence workflows.
Install on your platform
Showing Claude Code. One command installs this skill into any of the agents below.
- 1
Run this in your project
terminal$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill database-schema-designer -a claude-code Uses the open-source
skillsCLI and needs Node.js. Add-gto 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.
Automated safety checks
We could not read this skill's source, so none of the checks below were run.
About this skill
What it does
This skill designs database schemas based on textual descriptions of data requirements. It can generate SQL code to create tables, define relationships (primary keys, foreign keys), and specify data types for columns. The resulting schema is intended to be a functional blueprint for building a relational database.
When to use it
- You need to design a database but lack the expertise or time to do so manually.
- You have a clear understanding of your data requirements expressed in natural language.
- You're prototyping a new application and require a quick database schema for development purposes.
- You want to explore different schema designs based on varying data constraints.
Key capabilities
- Generates SQL
CREATE TABLEstatements. - Defines primary keys.
- Establishes foreign key relationships between tables.
- Specifies appropriate data types for columns.
Example prompts
- "Design a database schema for an online bookstore, including tables for books, authors, and customers."
- "Create a database to track student grades in different courses, with fields for student ID, course name, and grade."
- “I need a database schema for managing inventory of a small electronics store. Include tables for products, suppliers, and orders.”
Tips & gotchas
The quality of the generated schema depends heavily on the clarity and completeness of your prompt. Be as specific as possible about the data you want to store and any relationships between them.