Database Designer
Designs relational databases based on provided requirements, optimizing schema, data types, and indexing for efficiency.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add masanao-ohba-database-designer npx -- -y @trustedskills/masanao-ohba-database-designer
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"masanao-ohba-database-designer": {
"command": "npx",
"args": [
"-y",
"@trustedskills/masanao-ohba-database-designer"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows you to design relational databases. It can generate SQL schema definitions based on your descriptions of the data and relationships, including table structures, column types, primary keys, and foreign key constraints. The resulting schemas are designed for efficiency and data integrity.
When to use it
- You need a database schema but lack expertise in SQL or database design.
- You're prototyping a new application and require a quick database structure.
- You want to refactor an existing database schema for better performance or maintainability.
- You are designing a data warehouse and need help defining the tables and relationships.
Key capabilities
- Generates SQL schema definitions
- Defines table structures
- Specifies column types
- Creates primary keys
- Establishes foreign key constraints
Example prompts
- "Design a database for managing customer orders, including customers, products, and order details."
- "Create a relational database schema to track books, authors, and genres."
- “Generate the SQL for a database that stores information about employees, departments, and projects.”
Tips & gotchas
The skill’s output is based on your descriptions. Be as clear and detailed as possible in your prompts to ensure accurate and useful database designs.
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 Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.