Database Architect
Designs, optimizes, and troubleshoots relational databases based on provided requirements and data models.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add herdiansah-database-architect npx -- -y @trustedskills/herdiansah-database-architect
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"herdiansah-database-architect": {
"command": "npx",
"args": [
"-y",
"@trustedskills/herdiansah-database-architect"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to design and architect database solutions. It can handle requirements gathering, schema design (including tables, columns, data types), and consideration of factors like scalability and performance. The agent can also generate SQL scripts for creating the database structure based on the defined architecture.
When to use it
- New Project Setup: When starting a new software project that requires persistent data storage.
- Database Redesign: To modernize or optimize an existing database schema for improved performance or functionality.
- Data Migration Planning: To design the target database structure when migrating data from one system to another.
- Proof of Concept: Quickly prototype a database architecture to validate ideas and requirements.
Key capabilities
- Requirements gathering
- Schema Design (tables, columns, data types)
- Scalability considerations
- Performance optimization
- SQL script generation
Example prompts
- "Design a database schema for an e-commerce platform that tracks products, customers, and orders."
- "I need to migrate our legacy MySQL database to PostgreSQL. Can you design the new schema?"
- "Create a database architecture for managing library books, authors, and borrowers, ensuring efficient searching capabilities."
Tips & gotchas
The agent's output is based on its understanding of database principles; review and validate generated SQL scripts before deployment. Providing clear and detailed requirements will lead to more 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.