Database Designer
Skill Verified ActiveUse when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.
To empower users with expert-level analysis, optimization, and migration capabilities for modern database systems, ensuring scalable, performant, and maintainable schemas.
Features
- Automated normalization analysis (1NF-BCNF)
- Index gap and redundancy detection
- Zero-downtime migration planning
- Data type and constraint analysis
- ERD generation (Mermaid)
- Query performance modeling
Use Cases
- Designing new database schemas from scratch
- Optimizing existing database indexes for performance
- Planning and generating scripts for data migrations
- Choosing between SQL and NoSQL databases
- Modeling complex data relationships and normalization
Non-Goals
- Executing SQL queries directly against a database
- Performing real-time database monitoring
- Writing application code that uses the database
Documentation
- info:Configuration & parameter referenceWhile the tools have command-line interfaces, explicit documentation for all parameters and defaults is not readily available in the README or SKILL.md.
Code Execution
- info:ValidationWhile the scripts process structured input (SQL DDL, JSON), explicit use of a schema validation library like Zod or Pydantic is not evident for command-line arguments or internal data structures.
Installation
First, add the marketplace
/plugin marketplace add alirezarezvani/claude-skills/plugin install engineering@claude-code-skillsQuality Score
VerifiedTrust Signals
Similar Extensions
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
MongoDB Connection Optimizer
100Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.