database-schema-designer
Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.
git clone --depth 1 https://github.com/OneWave-AI/claude-skills /tmp/database-schema-designer && cp -r /tmp/database-schema-designer/database-schema-designer ~/.claude/skills/database-schema-designerSKILL.md
# Database Schema Designer Design optimized, scalable database schemas with proper relationships and indexes. ## Contents - `references/schema-templates.md` — SQL/NoSQL schema templates, ASCII ERD, and migration script templates. - `references/output-format.md` — labeled section structure for the final deliverable. - `references/best-practices.md` — naming, data types, indexes, relationships, SQL/NoSQL design rules, and the output quality checklist. ## Workflow 1. Gather requirements. Determine the database engine (PostgreSQL, MySQL, MongoDB, etc.), application domain, main entities, most common queries, expected data volume and growth, performance requirements, and any compliance constraints. 2. Design the schema. Apply the engine-appropriate rules in `references/best-practices.md` (SQL Database Design or NoSQL Database Design). 3. Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in `references/schema-templates.md`. 4. Create the entity relationship diagram in text format following the ERD template in `references/schema-templates.md`. 5. Provide migration scripts with both up and down (rollback) paths, per the migration template in `references/schema-templates.md`. 6. Format the complete output using the labeled sections in `references/output-format.md`. 7. Verify the result against the output quality checklist in `references/best-practices.md`. ## Example Triggers - "Design a database schema for an e-commerce platform" - "Create SQL tables for a blog system" - "Help me design a MongoDB schema for a social network" - "Optimize this database schema for performance" - "Generate migration scripts for my schema" Generate production-ready, optimized database schemas that scale.
Audit websites for accessibility issues and WCAG compliance. Use when checking accessibility, fixing a11y issues, or ensuring WCAG compliance.
Deploy a 2-layer parallel agent hierarchy for large, parallelizable work — big refactors, multi-file migrations, codebase-wide audits, bulk generation. Layer 1 is 3-50+ specialist agents, each with its own full context window; Layer 2 is 2+ sub-agents per member. Includes git safety, tiered sizing, a pre-deploy gate, phantom-completion checks, and multi-wave follow-up.
Deploys swarms of sub-agents for massive parallel data processing tasks. Unlike agent-army (which is for code changes), this is for DATA tasks -- processing 1000 documents, analyzing datasets, bulk content generation. Configurable swarm size, task distribution, result aggregation, progress tracking, and error recovery.
Designs and deploys custom agent teams for specific business workflows. Interactive discovery of business processes, then generates complete team configurations with specialized agent roles, tool access, communication protocols, and handoff rules.
Agent-to-Agent (A2A) communication protocol. Connect two or more Claude agents that pass messages, share context, delegate tasks, and collaborate. Implements structured handoffs, shared memory, and multi-agent conversations.
Assesses how ready a business is for AI adoption across six dimensions. Evaluates data maturity, tech stack, team skills, process documentation, budget, and culture. Generates a comprehensive ai-readiness-report.md with scores, gap analysis, and recommended starting points. Aligned with OneWave AI's audit methodology.
Generate animated videos and motion graphics from natural language descriptions. Creates a standalone Vite + React project with Framer Motion scenes that auto-play in the browser. Use when the user wants to create animations, motion graphics, video intros, animated presentations, or product demos.
Generate comprehensive API documentation including endpoint descriptions, request/response examples, authentication guides, error codes, and SDKs. Creates OpenAPI/Swagger specs, REST API docs, and developer-friendly reference materials. Use when users need to document APIs, create technical references, or write developer documentation.